Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AE6C8475AA1 for ; Fri, 8 Nov 2002 22:35:29 -0500 (EST) Received: from web80313.mail.yahoo.com (web80313.mail.yahoo.com [66.218.79.29]) by postgresql.org (Postfix) with SMTP id 06ACA475458 for ; Fri, 8 Nov 2002 22:35:29 -0500 (EST) Message-ID: <20021109033533.20773.qmail@web80313.mail.yahoo.com> Received: from [203.87.150.116] by web80313.mail.yahoo.com via HTTP; Fri, 08 Nov 2002 19:35:33 PST Date: Fri, 8 Nov 2002 19:35:33 -0800 (PST) From: Ludwig Lim Subject: More than 1 trigger of the same kind To: PostgreSQL Mailing List MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/149 X-Sequence-Number: 10291 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