I had been wondering as to where one can use BEFORE STATEMENT level
trigger, more so because one does not know (access) what rows are getting
affected. Only thing which comes to my mind is that if one wants to do
something at a table-level, then this trigger can be used; this is quite
unusual
I will not prefer to use a row trigger on this case for that will be
relatively inefficient.
So can we conclude that a sanity check is essential when using statement
level trigger.
Thanks and regards,
Jiten
I have gone through the documentation quite a number of times to establish
the understanding. However, I had been wondering about the recursion in the
case I put forth.
Is there a better way to handle this requirement? The point is that the
trigger is being called when no rows are affected.
Thank
Thanks Adrian
I am trying to understand as to how a BEFORE statement-level trigger can be
used. Since it is a trigger, one needs to know which rows are being
affected.
Regards,
Jiten
On Mon 18 Feb, 2019, 9:42 PM Adrian Klaver,
wrote:
> On 2/18/19 4:06 AM, Jitendra Loyal wrote:
>
On 2/18/19 9:11 AM, Jitendra Loyal wrote:
I have gone through the documentation quite a number of times to
establish the understanding. However, I had been wondering about the
recursion in the case I put forth.
Is there a better way to handle this requirement? The point is that the
trigger is
On 2/18/19 8:20 AM, Jitendra Loyal wrote:
Thanks Adrian
I am trying to understand as to how a BEFORE statement-level trigger can
be used. Since it is a trigger, one needs to know which rows are being
affected.
But you can't:
https://www.postgresql.org/docs/10/plpgsql-trigger.html
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
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.
Thanks
Jiten