Thread: More than 1 trigger of the same kind

Hi:
  Can I have more than 1 trigger of same kind on one
table? (i.e. 2 AFTER INSERT TRIGGER) on 1 table?
  I'm planning to split up a large trigger function
(about 200 lines) into 2 seperate triggers. Since
PL/PGSQL functions cannot accepts OPAQUE as arguments,
I have to create 2 triggers instead of just creating 2
functions and having the trigger function calling
another function passing the record NEW and OLD.
  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?

Thank you in advance,
ludwig. 


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

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.

Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
>> 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.

That's true as of 7.3; I do not think prior versions promised anything
about firing order.
        regards, tom lane