The following bug has been logged online:
Bug reference: 3865
Logged by: Oleg Kharin
Email address: ok(at)uvadrev(dot)udmnet(dot)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