Re: functions - triggers cross schemas
| От | David G. Johnston |
|---|---|
| Тема | Re: functions - triggers cross schemas |
| Дата | |
| Msg-id | CAKFQuwaJuuge+NRg0eeJjcShN90qPDQk=4xst-FuSmxPRCqeeg@mail.gmail.com обсуждение исходный текст |
| Ответ на | functions - triggers cross schemas ("Armand Pirvu (home)" <armand.pirvu@gmail.com>) |
| Ответы |
Re: functions - triggers cross schemas
|
| Список | pgsql-general |
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_SCHEMAAny 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 по дате отправления: