Re: Multiple triggers/rules

From: brichard(at)cafod(dot)org(dot)uk (Bruce Richardson)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Multiple triggers/rules
Date: 2001-02-21 22:27:21
Message-ID: 20010221222721.A21127@usb.cafod.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-02-21 23:24:09 Re: Multiple triggers/rules
Previous Message Tom Lane 2001-02-21 21:46:05 Re: Weird indices