Constraint Triggers

Поиск
Список
Период
Сортировка
От Donald Fraser
Тема Constraint Triggers
Дата
Msg-id 001201c67276$0bc62440$0264a8c0@demolish1
обсуждение исходный текст
Список pgsql-admin
I'm looking for a way to create a trigger function that gets called once per transaction as an AFTER EVENT.
Because there is no option for creating such a trigger function I was looking at the "create constraint trigger" command.
 
My approach would be to check the current transaction id to ensure that I only execute the function once per transaction and if it was deferred it would happen at the end of the transaction which would simulate an AFTER EVENT.
 
Apart from the obvious backup and restore problems can anyone think of any undesired side effects if I used this command?
 
Thanks in advance,
Donald Fraser

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Ben K."
Дата:
Сообщение: Re: How to list all the privileges a user has?
Следующее
От: Francesco Dalla Ca'
Дата:
Сообщение: OIDs wraparaound: postgresql (different versions) behavior