CREATE OR REPLACE FUNCTION code_translit_list_obj_entity() 
RETURNS TRIGGER AS 
$BODY$
DECLARE
    codetext text;
    nametext text;
BEGIN
 
    nametext := NEW.id::text;
    codetext := 'entity' || nametext;
    NEW.code := codetext;
 
    INSERT INTO test_log_proc ( text_1, text_2 ) VALUES ( nametext, codetext );
 
    RETURN NEW;
 
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;

CREATE TRIGGER tr_code_translit_list_obj_entity
AFTER INSERT OR UPDATE ON list_obj_entity FOR EACH ROW EXECUTE PROCEDURE code_translit_list_obj_entity ();