Use case for BEFORE STATEMENT level trigger - Mailing list pgsql-general

From Jitendra Loyal
Subject Use case for BEFORE STATEMENT level trigger
Date
Msg-id CAGBkuseoBcOyobwU66+1fBcRcJ7-e=9BvfqT8uh0HucETAHtRA@mail.gmail.com
Whole thread Raw
List pgsql-general
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 though as I have not experienced this need in more than two decades of developing business applications. I am looking forward to some one who can enlighten me with the use case because I may be missing something.

Thanks

pgsql-general by date:

Previous
From: Thomas Munro
Date:
Subject: Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes
Next
From: Noah Misch
Date:
Subject: Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes