Re: Rules with Conditions: Still Doesn't Work (Bug Rpt)
Joel Burton <jburton@scw.org>
From: "Joel Burton" <jburton@scw.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@postgresql.org, pgsql-docs@postgresql.org
Date: 2000-12-05T20:26:37Z
Lists: pgsql-bugs
> 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)