Re: Trigger function interface - Mailing list pgsql-general

From Jim Nasby
Subject Re: Trigger function interface
Date
Msg-id 569319C6.1090400@BlueTreble.com
Whole thread Raw
In response to Re: Trigger function interface  (Tatsuo Ishii <ishii@postgresql.org>)
List 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 by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Using xmax to detect deleted rows
Next
From: "Kharage, Suraj"
Date:
Subject: Re: Recovery regression tests