Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger position - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Re: Trigger position
Date
Msg-id CAB-JLwbwC-MAz3F41nszK7JOzwGnKDU3BfsXwfaDYYZ6Fk1g9Q@mail.gmail.com
Whole thread Raw
In response to Re: Trigger position  (Daniel Gustafsson <daniel@yesql.se>)
Responses Re: Trigger position
List pgsql-hackers
Tree view
This problem can raise ... there is a trigger foo using position 1, please choose another

Atenciosamente, 




Em qua., 15 de set. de 2021 às 07:59, Daniel Gustafsson <daniel@yesql.se> escreveu:
> On 15 Sep 2021, at 12:28, Marcos Pegoraro <marcos@f10.com.br> wrote:

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

For those not familiar with Firebird: triggers are executing in alphabetical
order within a position number, so it multiple triggers are defined for
POSITION 1 then they are individually executed alphabetically.

--
Daniel Gustafsson               https://vmware.com/

pgsql-hackers by date:

Previous
From: Artur Zakirov
Date:
Subject: Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events
Next
From: Marcos Pegoraro
Date:
Subject: Re: Trigger position