Re: Multiple triggers/rules - Mailing list pgsql-general

From brichard@cafod.org.uk (Bruce Richardson)
Subject Re: Multiple triggers/rules
Date
Msg-id 20010221222721.A21127@usb.cafod.org.uk
Whole thread Raw
In response to Re: Multiple triggers/rules  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Multiple triggers/rules
List pgsql-general
On Wed, Feb 21, 2001 at 10:17:25AM -0500, Tom Lane wrote:
>
> > And while I'm at it, can you define more than one rule for the same
> > event on the one table?
>
> Yes, with the same ordering issues as for triggers.

OK, great.  Now - if a table has both a before-update trigger and an
DO (as opposed to DO INSTEAD) update rule and the trigger cancels the
update, is the update rule (or rules) cancelled?

--
Bruce

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Weird indices
Next
From: newsreader@mediaone.net
Date:
Subject: Re: DBD::Pg is suddenly acting up!