Re: Rules with Conditions: Still Doesn't Work (Bug Rpt) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Rules with Conditions: Still Doesn't Work (Bug Rpt)
Date
Msg-id 17797.976044068@sss.pgh.pa.us
Whole thread Raw
In response to Rules with Conditions: Still Doesn't Work (Bug Rpt)  ("Joel Burton" <jburton@scw.org>)
Responses Re: Rules with Conditions: Still Doesn't Work (Bug Rpt)  ("Joel Burton" <jburton@scw.org>)
List pgsql-bugs
"Joel Burton" <jburton@scw.org> writes:
> Tom Lane pointed out that, given the current handling of
> conditional rules, this should be one rule, with two
> actions.
> For, this either fails to work, or in some circumstances,
> or in some circumstances, crashes the backend.

It turns out that all of these failures come from the same place,
which is that I had broken the handling of INSERT ... SELECT actions
inside rules.

I have committed a patch that appears to fix the problem.
I think that Marc has already tagged beta1, however, so the patch
will not be in the beta1 tarball due to appear Real Soon Now.
You can pull current sources from the CVS server, or grab a nightly
snapshot tarball after tonight.

Thanks for the detailed, easy-to-reproduce bug example!  These sorts of
reports are by far the nicest from a developer's point of view ;-)

            regards, tom lane

pgsql-bugs by date:

Previous
From: Nabil Sayegh
Date:
Subject: bug: UNION
Next
From: Tom Lane
Date:
Subject: Re: bug: UNION