Tom Lane wrote:
If increasing join_collapse_limit to 9 or more makes the problem go away
for you, that would be additional evidence that what you are seeing is
the same problem already diagnosed. That might be a usable workaround
for you until 8.2.7 comes out...
Thank Tom. That worked aroun
Ken Johanson <[EMAIL PROTECTED]> writes:
> Sorry Tom, I just missed you and responded on list, also asking if there
> were a test implied in adjusting the query. Anyway, here is trimmed-down
> DDL.
Well, if I just load this script into an empty DB in 8.2-CVS-tip and
then run the given query, it
Tom Lane wrote:
Please see if this patch fixes it for you:
http://archives.postgresql.org/pgsql-committers/2008-01/msg00164.php
If not, we'll need a self-contained test case.
Please pardon my non-awareness, what comprises a test case for this; is
DDL sufficent? I'm electing to go that route
Ken Johanson <[EMAIL PROTECTED]> writes:
> Hi all, I've seen other mentions of this happening but this instance is
> with a newer server version than the ones that had a patch applied.
Please see if this patch fixes it for you:
http://archives.postgresql.org/pgsql-committers/2008-01/msg00164.php
