naming triggers for execution

Поиск
Список
Период
Сортировка
От PegoraroF10
Тема naming triggers for execution
Дата
Msg-id 1573828269057-0.post@n3.nabble.com
обсуждение исходный текст
Ответы Re: naming triggers for execution
Re: naming triggers for execution
Список pgsql-general
On create trigger page of the doc:
If multiple triggers of the same kind are defined for the same event, they
will be fired in alphabetical order by name.
But suppose we have two triggers, one is called for every table for auditing
purposes, for example. And other for a specific process of that table.
Considering that the auditing needs to be the last, how can I be sure it´ll
ran lastly ?

Would be cool if we could define position for triggers, or like SQL Server
which defines first and last position of it. But as we cannot use this
thing, what is the way you use.




--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html



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

Предыдущее
От: Andrei Zhidenkov
Дата:
Сообщение: Race condition while creating a new partition
Следующее
От: Michael Nolan
Дата:
Сообщение: Re: naming triggers for execution