From: Joel Burton <jburton@scw.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@postgresql.org
Cc: pgsql-docs@postgresql.org
Subject: Re: Rules with Conditions: Still Doesn't Work (Bug Rpt)
Date: Tue, 5 Dec 2000 15:26:37 -0500
Message-ID: <3A2D092D.14054.15DCFC7@localhost> (raw)
In-Reply-To: <17797.976044068@sss.pgh.pa.us>
References: <3A2B7D2B.27409.3A1124@localhost>
> 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.
Fast work! (Boy, I sure wish I had a commercial Oracle/M$ contract
instead. I'm sure they could have done it faster ;-) ). Thanks!
Just to be clear (as much for other as for me): this should fix the
syntax as my (more recent) bug report submitted? That is, one non-
conditional rule that tries to handle both inserting and updating
together, as opposed to 2 different conditional rules that, together,
try to handle all cases.
> 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 ;-)
My Mom always said I loved finding problems. :-)
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: jburton@scw.org, tgl@sss.pgh.pa.us, pgsql-bugs@postgresql.org
Subject: Re: Rules with Conditions: Still Doesn't Work (Bug Rpt)
In-Reply-To: <3A2D092D.14054.15DCFC7@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox