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