Re: functions - triggers cross schemas

"David G. Johnston" <david.g.johnston@xxxxxxxxx> · Thu, 13 Oct 2016 15:31:26 -0700

On Thu, Oct 13, 2016 at 3:18 PM, Armand Pirvu (home) <armand.pirvu@xxxxxxxxx> wrote:
2 schemas , schema1 and schema2, with same tables , a base table and a tracking one.

Search path is set to schema1 by default.

insert into schema2.test1 (col2 , col3) values ('foo1','foo2')

I get an entry in schema1.test1_hist and not in schema2.test1_hist

See:

https://www.postgresql.org/docs/current/static/plpgsql-trigger.html#PLPGSQL-DML-TRIGGER

TG_TABLE_SCHEMA

Any object name not schema qualified will use search_path for resolution.  Search path doesn't change upon entering a function unless the function defines its own - and your's does not.

David J.