| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Order of triggers |
| Date: | 2008-01-24 14:59:29 |
| Message-ID: | 20080124145929.GT22715@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mag Gam | 2008-01-25 04:07:03 | Creating diff scripts for upgrades |
| Previous Message | Didier Gasser-Morlay | 2008-01-24 14:50:12 | Order of triggers |