On Wed, May 06, 2009 at 03:47:46PM -0400, Tom Lane wrote: > I wrote: > > I suppose the change I made here > > http://archives.postgresql.org/pgsql-committers/2009-04/msg00329.php > > to improve constant-join-qual handling is what is preventing the > > assertion failure, though I'm still not quite sure why (I'd better look > > closer to see if there is still some form of the bug lurking). >
<snipp> > Kind of a long-winded explanation of what will be a one-line patch, > but there you have it. Hi, i did retest the original failing query on current head. Sepcifically: git clone up to and including the on liner patch by you: 86a4abb3a187bf2cc548aedd58125274ac724b1c Tweak distribute_qual_to_rels so that when we decide a pseudoconstant ... and cannot reproduce the failure anymore in this version. :) Thanks for the timely investigation of the issue Regards, Stefan -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
