Re: [BUGS] INSTEAD rule bug? - Mailing list pgsql-general

From Tom Lane
Subject Re: [BUGS] INSTEAD rule bug?
Date
Msg-id 23479.1058288014@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] INSTEAD rule bug?  (Dmitry Tkach <dmitry@openratings.com>)
Responses Re: [BUGS] INSTEAD rule bug?
Re: [BUGS] INSTEAD rule bug?
List pgsql-general
Dmitry Tkach <dmitry@openratings.com> writes:
> I know... That was a typo in my sql :-)
> But for this example it doesn't matter - that view/table is only needed
> to illustrate the rules behaviour on insert.

Oh, I see what you're on about.  Sorry, a "DO INSTEAD NOTHING" only
suppresses the original command, it does not suppress other rules.
I think what you want is to make the insert_test rule conditional
on x being not null.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: perfromance impact of vacuum
Next
From: Steve Crawford
Date:
Subject: Re: Are you frustrated with PostgreSQL