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).
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 |