Re: Trigger position

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Trigger position
Дата
Msg-id 202109151530.sdgdd7k4tode@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Trigger position  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
On 2021-Sep-15, Pavel Stehule wrote:

> Triggers that depend on execution order are pretty hell. It is a clean
> signal of some crazy design and overusing of triggers.

Yeah.  The only case I've seen where order of triggers was important
(beyond the "before" / "after" classification) is where you have
something that you need to ensure runs before the FK triggers.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"XML!" Exclaimed C++.  "What are you doing here? You're not a programming
language."
"Tell that to the people who use me," said XML.
https://burningbird.net/the-parable-of-the-languages/



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails
Следующее
От: Chapman Flack
Дата:
Сообщение: Re: Trigger position