Skip site navigation (1) Skip section navigation (2)

Order of triggers

From: "Didier Gasser-Morlay" <didiergm(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Order of triggers
Date: 2008-01-24 14:50:12
Message-ID: 608b66ce0801240650w5dc2fe0bq46a9c1ec26800838@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

In my database, I am creating several triggers, some tables have more
than one trigger for the same Fire/Event (ie BEFORE INSERT)
combination.

How can I know in which order the triggers will fire or how can I
force a specific order to be used ?

In firebird, I used to use a "Position" parameter to determine the
order, is there an equivalent in PostgreSQL ?

Thanks for your help

Didier

Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2008-01-24 14:59:29
Subject: Re: Order of triggers
Previous:From: Jonah H. HarrisDate: 2008-01-24 13:36:33
Subject: Re: WITH ENCRYPTION feature ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group