Lists: | pgsql-general |
---|
From: | Hugo <htakada(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | trigger firing order |
Date: | 2006-04-10 21:09:05 |
Message-ID: | f3d9ba990604101409r7c39d9cfk58666e3071cc23c1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: trigger firing order |
Date: | 2006-04-10 21:29:02 |
Message-ID: | 20060410212902.48873.qmail@web31802.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
> 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.
From: | Terry Lee Tucker <terry(at)esc1(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: trigger firing order |
Date: | 2006-04-10 21:29:34 |
Message-ID: | 200604101729.34022.terry@esc1.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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.
From: | Geoffrey <esoteric(at)3times25(dot)net> |
---|---|
To: | Terry Lee Tucker <terry(at)esc1(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: trigger firing order |
Date: | 2006-04-10 23:59:34 |
Message-ID: | 443AF166.40105@3times25.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
From: | Alban Hertroys <alban(at)magproductions(dot)nl> |
---|---|
To: | Hugo <htakada(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: trigger firing order |
Date: | 2006-04-11 10:19:57 |
Message-ID: | 443B82CD.3060402@magproductions.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | 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(at)magproductions(dot)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 //