Postgres Pro
Downloads
Home   >   mailing lists

Re: BEFORE ... Statement-level trigger - Mailing list pgsql-general

From Adrian Klaver
Subject Re: BEFORE ... Statement-level trigger
Date
Msg-id 476285d1-d477-72b0-6da8-199bc03cc669@aklaver.com
Whole thread Raw
In response to BEFORE ... Statement-level trigger  (Jitendra Loyal <jitendra.loyal@gmail.com>)
Responses Re: BEFORE ... Statement-level trigger
List pgsql-general
Tree view 
On 2/18/19 4:06 AM, Jitendra Loyal wrote:
> The behaviour is not clear for BEFORE Statement-level Trigger. This is 
> because transition tables cannot be used. So how does one get access to 
> the rows being affected? It is not documented either.

If you need the row values then use a FOR ROW trigger.

> 
> Thanks
> Jiten


-- 
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Statement-level trigger results in recursion
Next
From: Jitendra Loyal
Date:
Subject: Re: BEFORE ... Statement-level trigger