Trigger Firing Order

From: Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>
To: PostgreSQL General Discussion Forum <pgsql-general(at)postgresql(dot)org>
Subject: Trigger Firing Order
Date: 2013-12-11 04:02:23
Message-ID: CADp-Sm6c0zsuFjtRG4=4=zGbeZOygR+9mafrrE87e1vaB1dvVw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is it possible for me to define the order in which triggers will be fired?

So far what I have understood from PostgreSQL documentation, in order to
fire 2 triggers in sequence (say trigger1 and trigger2) on a table, I need
to name them in that way.
But with certain packaged products who create their own triggers, I won't
have control over this. Also, this could be an issue for me if I write
business logic in triggers.

Any better way known to work in PostgreSQL?

Best Regards,
*Sameer Kumar | Database Consultant*

*ASHNIK PTE. LTD.*101 Cecil Street, #11-11 Tong Eng Building, Singapore
069533
M : *+65 8110 0350* T: +65 6438 3504 | www.ashnik.com
www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz

[image: email patch]

This email may contain confidential, privileged or copyright material and
is solely for the use of the intended recipient(s).

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sandeep Gupta 2013-12-11 04:17:17 Re: [Postgres-xc-general] "Tuple not found error" during Index creation
Previous Message Koichi Suzuki 2013-12-11 03:50:10 Re: [Postgres-xc-general] "Tuple not found error" during Index creation