Re: More than 1 trigger of the same kind

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
Cc: PostgreSQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: More than 1 trigger of the same kind
Date: 2002-11-09 03:49:52
Message-ID: 20021108194914.Q18660-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ludwig Lim 2002-11-09 04:30:13 Some more weird NULL behavior
Previous Message Ludwig Lim 2002-11-09 03:35:33 More than 1 trigger of the same kind