Re: Trigger position - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Re: Trigger position
Date
Msg-id CAB-JLwaQsqw7BZZ0bcTd+uckyv2v8LR2OP-kwSRrVu6_u=nwsw@mail.gmail.com
Whole thread Raw
In response to Re: Trigger position  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
This way would be interesting for those are migrating from these databases too. But ok, I´ll forget it.

Em qua., 15 de set. de 2021 às 08:40, Tom Lane <tgl@sss.pgh.pa.us> escreveu:
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: Marcos Pegoraro
Date:
Subject: Re: Trigger position
Next
From: vignesh C
Date:
Subject: Re: Column Filtering in Logical Replication