Trigger position - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Trigger position
Date
Msg-id CAB-JLwY9iLY_4hYemtOJSeG3QbfevcB_rEE0Z4_a=-HXULzGXQ@mail.gmail.com
Whole thread Raw
Responses Re: Trigger position  (Daniel Gustafsson <daniel@yesql.se>)
Re: Trigger position  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Trigger position  (Chapman Flack <chap@anastigmatix.net>)
List pgsql-hackers
Hi Hackers, 

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.

What do you think about it, do you know an old/abandoned patch that was not committed ?

CREATE TRIGGER RECALC_THAT BEFORE UPDATE POSITION 1 ON ORDERS...
CREATE TRIGGER DO_OTHER_CALC BEFORE UPDATE POSITION 2 ON ORDERS...

Regards, 
Marcos

pgsql-hackers by date:

Previous
From: "tanghy.fnst@fujitsu.com"
Date:
Subject: RE: Remove double check when field_name is not NULL in be-secure-openssl.c
Next
From: "bucoo@sohu.com"
Date:
Subject: Re: Re: parallel distinct union and aggregate support patch