Re: Trigger Priority

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: fasupport(at)allcoast(dot)net
Cc: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trigger Priority
Date: 2007-07-03 16:21:47
Message-ID: 968521.76370.qm@web31806.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


--- Mike Gould <mgould(at)allcoast(dot)net> wrote:

> Is there a way to determine the order that triggers are executed? We are converting from SQL
> Anywhere 9 and one of the features that they have is the ability to add a order statement to
> triggers. This allows from a programmatic way to control how triggers are fired if there
> is more than one trigger for a particular type (before, after) the insert, update, delete
> commands.

The triggers fire in alphbetical order.

Regards,
Richard Broersma Jr.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-07-03 16:22:02 Re: Trigger Priority
Previous Message Mike Gould 2007-07-03 16:11:01 Trigger Priority