Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger function interface - Mailing list pgsql-general

From Jim Nasby
Subject Re: Trigger function interface
Date
Msg-id 568DE7D2.6050705@BlueTreble.com
Whole thread Raw
In response to Trigger function interface  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: Trigger function interface  (Tatsuo Ishii <ishii@postgresql.org>)
List pgsql-general
Tree view 
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.
--
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: Definitive answer: can functions use indexes?
Next
From: Jim Nasby
Date:
Subject: Re: COPY FROM STDIN