BUG #3865: ERROR: failed to build any 8-way joins

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