| 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: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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 | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-04-11 00:04:23 | Re: Workaround for custom aggregate which would need "internal" as statetype |
| Previous Message | Florian G. Pflug | 2006-04-10 23:49:27 | Re: Workaround for custom aggregate which would need "internal" |