Re: Trigger Priority - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: Trigger Priority
Date
Msg-id 968521.76370.qm@web31806.mail.mud.yahoo.com
Whole thread Raw
In response to Trigger Priority  ("Mike Gould" <mgould@allcoast.net>)
List pgsql-general
--- Mike Gould <mgould@allcoast.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.

pgsql-general by date:

Previous
From: "Mike Gould"
Date:
Subject: Trigger Priority
Next
From: "A. Kretschmer"
Date:
Subject: Re: Trigger Priority