Re: failed to build any 8-way joins: SQLSTATE: XX000 on PostgreSQL 8.2.6

From: Ken Johanson <pg-user(at)kensystem(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: failed to build any 8-way joins: SQLSTATE: XX000 on PostgreSQL 8.2.6
Date: 2008-02-05 06:06:48
Message-ID: 47A7FCF8.3060908@kensystem.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 around it.

I always knew I hated arbitrary limits. I set it to 1 ("# 1 disables
collapsing of explicit JOINS") and all seems OKAY. That was 3 hours of
my life (experimenting, researching, communicating) under the bridge.
Anyway, back in business.

Ken

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hiroshi Saito 2008-02-05 06:16:23 Re: Question for Postgres 8.3
Previous Message Ken Johanson 2008-02-05 05:55:42 Simplest syntax (or a UI?) to rename columns and sequences and constraints (etc)?