To: "Joel Burton" <jburton@scw.org>
cc: pgsql-bugs@postgresql.org, pgsql-docs@postgresql.org
Subject: Re: Rules with Conditions: Still Doesn't Work (Bug Rpt) 
In-reply-to: <3A2B7D2B.27409.3A1124@localhost> 
References: <3A2B7D2B.27409.3A1124@localhost>
Comments: In-reply-to "Joel Burton" <jburton@scw.org>
	message dated "Mon, 04 Dec 2000 11:16:59 -0500"
Date: Tue, 05 Dec 2000 14:21:08 -0500
Message-ID: <17797.976044068@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

"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