ERROR: failed to build any 8-way joins

Lists: pgsql-general
From: "Ian Harding" <harding(dot)ian(at)gmail(dot)com>
To: "PostgreSQL General ML" <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: failed to build any 8-way joins
Date: 2007-02-12 04:20:24
Message-ID: 725602300702112020r6a7e14f5h359a6a2989c13248@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

What is this? I just upgraded from 8.1.3 to 8.2.3 and things are
blowing up a little bit.

I noticed something in postgresql.conf about max_stack_depth, is this related?

- Ian


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: harding(dot)ian(at)gmail(dot)com
Cc: "PostgreSQL General ML" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: failed to build any 8-way joins
Date: 2007-02-12 05:40:31
Message-ID: 22821.1171258831@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

"Ian Harding" <harding(dot)ian(at)gmail(dot)com> writes:
> What is this? I just upgraded from 8.1.3 to 8.2.3 and things are
> blowing up a little bit.

Please provide a self-contained test case. It's clearly a planner bug
but I can't fix it without a test case.

regards, tom lane