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

From Dmitry Tkach
Subject Re: [BUGS] INSTEAD rule bug?
Date
Msg-id 3F14333F.1070409@openratings.com
Whole thread Raw
In response to Re: [BUGS] INSTEAD rule bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [BUGS] INSTEAD rule bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:

>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.
>
>
>
Yeah... that's what I was afraid of :-(
The problem is that in the 'real life' situation the condition is a lot
more complicated than this simple is null test... I hate having to
duplicate it, and I hate even more having to evaluate it twice on every
insert :-(

Dima


pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Are you frustrated with PostgreSQL
Next
From: "Jay O'Connor"
Date:
Subject: Re: perfromance impact of vacuum