naming triggers for execution - Mailing list pgsql-general

From PegoraroF10
Subject naming triggers for execution
Date
Msg-id 1573828269057-0.post@n3.nabble.com
Whole thread Raw
Responses Re: naming triggers for execution  (Michael Nolan <htfoot@gmail.com>)
Re: naming triggers for execution  (srkrishna@myself.com)
List pgsql-general
On create trigger page of the doc:
If multiple triggers of the same kind are defined for the same event, they
will be fired in alphabetical order by name.
But suppose we have two triggers, one is called for every table for auditing
purposes, for example. And other for a specific process of that table.
Considering that the auditing needs to be the last, how can I be sure it´ll
ran lastly ?

Would be cool if we could define position for triggers, or like SQL Server
which defines first and last position of it. But as we cannot use this
thing, what is the way you use.




--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html



pgsql-general by date:

Previous
From: Andrei Zhidenkov
Date:
Subject: Race condition while creating a new partition
Next
From: Michael Nolan
Date:
Subject: Re: naming triggers for execution