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

From Tom Lane
Subject Re: [BUGS] INSTEAD rule bug?
Date
Msg-id 18691.1058817663@sss.pgh.pa.us
Whole thread Raw
In response to INSTEAD rule bug?  (Dmitry Tkach <dmitry@openratings.com>)
Responses Re: [BUGS] INSTEAD rule bug?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
DeJuan Jackson <djackson@speedfc.com> writes:
>   Or is it simply any conditional rule using UNION/EXCEPT/INTERSECT/...?

Yeah, that's about the size of it :-(.  Note though that you could
probably work around the problem by pushing the UNION etc. down into a
sub-select:
    SELECT * FROM (SELECT ... UNION ...) foo;

At some point we could look at automatically transforming the query in
that way, but I'm not planning to worry about it now.

            regards, tom lane

pgsql-general by date:

Previous
From: "Abhishek Goyal"
Date:
Subject: Postgres Database Error Codes
Next
From: "FRANKLIN,JOHNSON (HP-Singapore,ex5)"
Date:
Subject: Need help to take PGSql Dump