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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

am Thu, dem 24.01.2008, um 15:50:12 +0100 mailte Didier Gasser-Morlay folgendes:
> 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 ?

The triggers fires alphabetical.


Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org