Re: Trigger position - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Trigger position
Date
Msg-id 971794.1631706044@sss.pgh.pa.us
Whole thread Raw
In response to Trigger position  (Marcos Pegoraro <marcos@f10.com.br>)
Responses Re: Trigger position  (Marcos Pegoraro <marcos@f10.com.br>)
Re: Trigger position  (Andreas Karlsson <andreas@proxel.se>)
List pgsql-hackers
Marcos Pegoraro <marcos@f10.com.br> writes:
> Alphabetical order of triggers sometimes makes me write a_Recalc or z_Calc
> to be sure it´ll be the first or the last trigger with same event of that
> table

> Oracle and SQL Server have FOLLOWS and PRECEDES when defining trigger
> execution order. Firebird has POSITION, which I like it more.

Color me skeptical: doesn't that introduce more complication without
fundamentally solving anything?  You still don't know which position
numbers other triggers have used, so it seems like this is just a
different way to spell the same problem.

            regards, tom lane



pgsql-hackers by date:

Previous
From: "Drouvot, Bertrand"
Date:
Subject: Re: Minimal logical decoding on standbys
Next
From: Amul Sul
Date:
Subject: Re: Deduplicate code updating ControleFile's DBState.