Re: [SQL] More than 1 trigger of the same kind

2002-11-08 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> 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 a

Re: [SQL] More than 1 trigger of the same kind

2002-11-08 Thread Stephan Szabo
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 t

[SQL] More than 1 trigger of the same kind

2002-11-08 Thread Ludwig Lim
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 inst