Postgres Pro
Downloads
Home   >   mailing lists

Re: More than 1 trigger of the same kind - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: More than 1 trigger of the same kind
Date
Msg-id 20021108194914.Q18660-100000@megazone23.bigpanda.com
Whole thread Raw
In response to More than 1 trigger of the same kind  (Ludwig Lim <lud_nowhere_man@yahoo.com>)
Responses Re: More than 1 trigger of the same kind  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
On Fri, 8 Nov 2002, Ludwig Lim wrote:

> Hi:
>
>    Can I have more than 1 trigger of same kind on one
> table? (i.e. 2 AFTER INSERT TRIGGER) on 1 table?

Yes.

>    Does having more than 1 trigger of the same kind
> produces some side effect? I mean is the order of the
> trigger firing is always the same?

IIRC the triggers are fired in name order.

pgsql-sql by date:

Previous
From: Ludwig Lim
Date:
Subject: More than 1 trigger of the same kind
Next
From: Ludwig Lim
Date:
Subject: Some more weird NULL behavior