Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 98050475E14 for ; Fri, 8 Nov 2002 22:51:06 -0500 (EST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 7A427474E61 for ; Fri, 8 Nov 2002 22:49:49 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 09305D61C; Fri, 8 Nov 2002 19:49:53 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id F303F5C03; Fri, 8 Nov 2002 19:49:52 -0800 (PST) Date: Fri, 8 Nov 2002 19:49:52 -0800 (PST) From: Stephan Szabo To: Ludwig Lim Cc: PostgreSQL Mailing List Subject: Re: More than 1 trigger of the same kind In-Reply-To: <20021109033533.20773.qmail@web80313.mail.yahoo.com> Message-ID: <20021108194914.Q18660-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/150 X-Sequence-Number: 10292 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.