Search Postgresql Archives

Re: BEFORE ... Statement-level trigger

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: BEFORE ... Statement-level trigger
From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
Date: Mon, 18 Feb 2019 08:12:19 -0800
In-reply-to: <CAGBkuseBKiU5Sj-7hboGzYtock80JnyQ0hNLQpBKMgsoFscLzw@mail.gmail.com>
References: <CAGBkuseBKiU5Sj-7hboGzYtock80JnyQ0hNLQpBKMgsoFscLzw@mail.gmail.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.5.0

On 2/18/19 4:06 AM, Jitendra Loyal wrote:

The behaviour is not clear for BEFORE Statement-level Trigger. This isbecause transition tables cannot be used. So how does one get access tothe 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@xxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: BEFORE ... Statement-level trigger
  - From: Jitendra Loyal

References:
- BEFORE ... Statement-level trigger
  - From: Jitendra Loyal

Prev by Date: Re: Statement-level trigger results in recursion
Next by Date: Re: Statement-level trigger results in recursion
Previous by thread: BEFORE ... Statement-level trigger
Next by thread: Re: BEFORE ... Statement-level trigger
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux