Use case for BEFORE STATEMENT level trigger

Поиск
Список
Период
Сортировка
От Jitendra Loyal
Тема Use case for BEFORE STATEMENT level trigger
Дата
Msg-id CAGBkuseoBcOyobwU66+1fBcRcJ7-e=9BvfqT8uh0HucETAHtRA@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes
Следующее
От: Noah Misch
Дата:
Сообщение: Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes