Re: trigger firing order - Mailing list pgsql-general

From Alban Hertroys
Subject Re: trigger firing order
Date
Msg-id 443B82CD.3060402@magproductions.nl
Whole thread Raw
In response to trigger firing order  (Hugo <htakada@gmail.com>)
List pgsql-general
Hugo wrote:
> Hi, how can I tell in which order are triggered different triggers on the
> same table, let me explain ,
> I have three triggers for table A, all of then are intended for "before
> insert" on the table, in ASA I can tell the Db in which order I want the
> triggers to fire, is there an equivalent for postgres ??

They're fired in alphabetical order. I tend to prefix my trigger names
with numbers for that reason ;)

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

// Integrate Your World //

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Performance UPDATE/INSERT
Next
From: "A. Kretschmer"
Date:
Subject: Re: Performance UPDATE/INSERT