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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Order of triggers


  • From: "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
  • To: pgsql-novice(at)postgresql(dot)org
  • Subject: Re: Order of triggers
  • Date: Thu, 24 Jan 2008 15:59:29 +0100
  • Message-id: <20080124145929.GT22715@a-kretschmer.de> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group