| From: | Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Trigger position |
| Date: | 2021-09-15 10:28:37 |
| Message-ID: | CAB-JLwY9iLY_4hYemtOJSeG3QbfevcB_rEE0Z4_a=-HXULzGXQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bucoo@sohu.com | 2021-09-15 10:34:01 | Re: Re: parallel distinct union and aggregate support patch |
| Previous Message | tanghy.fnst@fujitsu.com | 2021-09-15 10:01:20 | RE: Remove double check when field_name is not NULL in be-secure-openssl.c |