Thread: trigger firing order

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 ??

thanks for your help

Postgres  8.0.4
Windows XP

> 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 ??

IIRC, I've read some where that they are activated in alphabetical order.

Regards,

Richard.

On Monday 10 April 2006 05:09 pm, Hugo saith:
> 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 ??
>
> thanks for your help
>
> Postgres  8.0.4
> Windows XP

Triggers of the same type fire in alphabetical order; at least, that's how it
works is 7.4.6.

Terry Lee Tucker wrote:
> On Monday 10 April 2006 05:09 pm, Hugo saith:
>> 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 ??
>>
>> thanks for your help
>>
>> Postgres  8.0.4
>> Windows XP
>
> Triggers of the same type fire in alphabetical order; at least, that's how it
> works is 7.4.6.

Although, you should really be on at LEAST 7.4.12... :)

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


--
Until later, Geoffrey

Any society that would give up a little liberty to gain a little
security will deserve neither and lose both.  - Benjamin Franklin

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 //