On 11/05/2011 05:36 PM, Andrus wrote:
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
?
http://www.postgresql.org/docs/8.2/interactive/plpgsql-trigger.html
Shows all available variables. In this case - TG_TABLE_SCHEMA
Sim
|
