Re: Trigger position - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Trigger position
Date
Msg-id 202109151530.sdgdd7k4tode@alvherre.pgsql
Whole thread Raw
In response to Re: Trigger position  (Pavel Stehule <pavel.stehule@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails
Next
From: Chapman Flack
Date:
Subject: Re: Trigger position