How to find owning schema in function
От | Andrus |
---|---|
Тема | How to find owning schema in function |
Дата | |
Msg-id | 590C7236EDF84F6CB786F6C7678A7167@dell2 обсуждение исходный текст |
Ответы |
Re: How to find owning schema in function
|
Список | pgsql-general |
8.1+ database contains separate schemas for every company named company1, company2, .... companyi. order tables in those schemas contain trigger like for company1: CREATE OR REPLACE FUNCTION dok_seq_trig() RETURNS "trigger" AS $$BEGIN IF NEW.tasudok IS NULL AND NEW.doktyyp!='O' THEN NEW.tasudok = nextval( 'company1.'|| TG_RELNAME || '_'|| NEW.doktyyp ||'_seq'); END IF; IF NEW.arvenumber IS NULL AND NEW.doktyyp='O' THEN NEW.arvenumber = nextval( 'company1.'|| TG_RELNAME || '_'|| NEW.doktyyp ||'_seq'); END IF; RETURN NEW; END$$ LANGUAGE plpgsql STRICT; This code has hard coded schema name 'company1' . If new company schema n is created from existing one, trigger functions needs manual update to change schema to companyn. How to change this code so that instead of hard-coded schema name it automatically uses the schema where trigger function is defined ?
В списке pgsql-general по дате отправления: