Postgres Pro
Downloads
Home   >   mailing lists

BUG #3865: ERROR: failed to build any 8-way joins - Mailing list pgsql-bugs

From Oleg Kharin
Subject BUG #3865: ERROR: failed to build any 8-way joins
Date
Msg-id 200801091807.m09I7tMY098525@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3865: ERROR: failed to build any 8-way joins
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      3865
Logged by:          Oleg Kharin
Email address:      ok@uvadrev.udmnet.ru
PostgreSQL version: 8.2.6
Operating system:   CentOS 5.1 x86 64-bit
Description:        ERROR: failed to build any 8-way joins
Details:

After PostgreSQL 8.2.5 to 8.2.6 upgrade there is a query that generates:
ERROR: failed to build any 8-way joins.

The text of the query is rather big. It will be better to attach its text as
a file as well as the SQL script that creates a test case. But I don't know
how to post a file in the bug report form.

Oleg

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #3860: xpath crashes backend when is querying xmlagg result
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: BUG #3865: ERROR: failed to build any 8-way joins