Re: [GENERAL] How to find owning schema in function

2011-11-06 Thread Sim Zacks
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_

[GENERAL] How to find owning schema in function

2011-11-05 Thread Andrus
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.tasudo