Re: Trigger function interface

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Trigger function interface
Дата
Msg-id 569319C6.1090400@BlueTreble.com
обсуждение исходный текст
Ответ на Re: Trigger function interface  (Tatsuo Ishii <ishii@postgresql.org>)
Список pgsql-general
On 1/7/16 6:15 PM, Tatsuo Ishii wrote:
>> On 1/6/16 7:03 PM, Tatsuo Ishii wrote:
>>> Is it possible to get the parse tree in a C trigger function which is
>>> invoked when DML (INSERT/UPDATE/DELETE against a view) is executed?
>>
>> Yes, it's in fcinfo->flinfo->fn_expr.
>
> Thanks for the info. But is this the parse tree for the top level
> query which involves the trigger?

Hrm, apparently not. fcinfo->context would maybe be helpful, but I'm not
sure.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com


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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Using xmax to detect deleted rows
Следующее
От: "Kharage, Suraj"
Дата:
Сообщение: Re: Recovery regression tests