CREATE OR REPLACE FUNCTION tr_user_create () RETURNS trigger AS
$body$
declare
 username text;
 createuserstr text;
 dropuserstr text;
 cur_schema text;
BEGIN
  /* Тело новой функции */
  username:=NewUserName(new.role_id);
  dropuserstr:='drop user if exists '|| username; 
  execute dropuserstr;
  new.password_text=COALESCE(new.password_text, '');
  createuserstr:='create user '|| username ||' encrypted password '''|| new.password_text||''' IN ROLE '; 

-- CREATE ROLE admin SUPERUSER; -- 1
-- CREATE ROLE SimpleUser;      -- 2
-- CREATE ROLE TheNextRole;     -- 3
-- CREATE ROLE Loginer;         -- 4

 IF new.Role_id= 1  THEN
     createuserstr:=createuserstr || 'UsrAdmin'; ELSIF
    new.Role_ID= 2  THEN
  createuserstr:=createuserstr || 'SimpleUser'; ELSIF
    new.Role_ID= 3  THEN
  createuserstr:=createuserstr || 'TheNextRole'; ELSIF
    new.Role_ID= 4  THEN
  createuserstr:=createuserstr || 'Loginer';

 END IF;
  execute createuserstr;
   IF new.Role_id= 1  THEN
     createuserstr:='ALTER USER '|| username ||' WITH CREATEROLE';
     execute createuserstr;
    END IF;
  SELECT current_setting('search_path') INTO cur_schema;
  createuserstr:='ALTER USER '|| username ||' SET search_path TO ' || cur_schema;
  execute createuserstr;

  new.password_text:=NULL;
  new.pg_username:=username;
  RETURN new;
END;
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;