Re: functions - triggers cross schemas

Поиск
Список
Период
Сортировка
От Armand Pirvu (home)
Тема Re: functions - triggers cross schemas
Дата
Msg-id DF1AB7C7-AE66-4347-81DC-BDFFEF9420D4@gmail.com
обсуждение исходный текст
Ответ на Re: functions - triggers cross schemas  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения
Ok that was my oversight in understanding that the path does not change upon entering a function. I assumed that .it does by simply picking it from the schema2.test1 

Thanks a bunch

Armand

On Oct 13, 2016, at 5:31 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

On Thu, Oct 13, 2016 at 3:18 PM, Armand Pirvu (home) <armand.pirvu@gmail.com> 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:


​
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.


В списке pgsql-general по дате отправления: