Skip site navigation (1) Skip section navigation (2)

Re: Rules with Conditions: Still Doesn't Work (Bug Rpt)

From: "Joel Burton" <jburton(at)scw(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org
Subject: Re: Rules with Conditions: Still Doesn't Work (Bug Rpt)
Date: 2000-12-05 20:26:37
Message-ID: 3A2D092D.14054.15DCFC7@localhost (view raw, whole thread or download thread mbox)
Lists: pgsql-bugspgsql-docs
> 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(at)scw(dot)org
Support Center of Washington (

In response to


pgsql-docs by date

Next:From: Tom LaneDate: 2000-12-05 20:42:54
Subject: Re: Rules with Conditions: Still Doesn't Work (Bug Rpt)
Previous:From: Tom LaneDate: 2000-12-05 19:21:08
Subject: Re: Rules with Conditions: Still Doesn't Work (Bug Rpt)

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2000-12-05 20:35:32
Subject: foreign key check makes a big LOCK
Previous:From: Tom LaneDate: 2000-12-05 20:17:35
Subject: Re: bug: UNION

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group