Re: DO INSTEAD and conditional rules - Mailing list pgsql-hackers

From Tom Lane
Subject Re: DO INSTEAD and conditional rules
Date
Msg-id 28483.1114495252@sss.pgh.pa.us
Whole thread Raw
In response to DO INSTEAD and conditional rules  (Neil Conway <neilc@samurai.com>)
Responses Re: DO INSTEAD and conditional rules  (Neil Conway <neilc@samurai.com>)
Re: DO INSTEAD and conditional rules  (David Wheeler <david@kineticode.com>)
List pgsql-hackers
Neil Conway <neilc@samurai.com> writes:
> Note that although both rules are DO INSTEAD, they both get fired for 
> the insertion.

DO INSTEAD means that the *original* query will not execute; it does
not suppress actions produced by other rules.  If we did not define
it that way, I think your example would have to error out --- how
would you choose which INSTEAD rule wins?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: [PATCHES] Continue transactions after errors in psql
Next
From: "Qingqing Zhou"
Date:
Subject: Re: simplify register_dirty_segment()