BUG #2862: ERROR: failed to build any 7-way joins

From: "Sergey" <for(dot)adv(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2862: ERROR: failed to build any 7-way joins
Date: 2006-12-23 12:46:17
Message-ID: 200612231246.kBNCkH9J067639@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2862
Logged by: Sergey
Email address: for(dot)adv(at)gmail(dot)com
PostgreSQL version: 8.2.0-1
Operating system: Windows XP Pro SP2
Description: ERROR: failed to build any 7-way joins
Details:

After migrating to 8.2 I received an error:
ERROR: failed to build any 7-way joins
SQL state: XX000

STATEMENT: select * from v_well_main w LEFT OUTER JOIN v_state_main s ON
(w."Id_well"=s."Id_wl") LEFT OUTER JOIN v_expl_main e ON
(w."Id_well"=e."Id_wl") where w."Id_dep"=7

View v_well_main contained statement:
SELECT w."Id_well", w."Name_wl", w."Num", w."Cod", c."Name" AS
"Categor_name", w."Inv_num", w."Balance", w."Obl", w."Reg", w."Sl_rada",
w."Latitude_deg", w."Latitude_min", w."Latitude_sec", w."Longitude_deg",
w."Longitude_min", w."Longitude_sec", w."Topograf_note", w."Passp_org",
w."Passp_date", w."Executor", w."Exec_phone", w."Director", w."Al_rotor",
w."Al_gr", w."dP", o."Id_org", o."Name", o."Address", o."EDRPOU", o."Phone",
b."Name" AS name_obl, b."KOATUU" AS obl_koatuu, r."Name" AS name_raj,
r."KOATUU" AS raj_koatuu, s."Name" AS sl, v."Id_dep", v."Name_dep", v."Typ",
v.obj_typ, v."Begin", v."End"
FROM v_well_obj v, "Categor_dic" c, "Well" w
LEFT JOIN "Obl_dic" b ON w."Obl" = b."Id_obl"
LEFT JOIN "Raj_dic" r ON w."Reg" = r."Id_raj"
LEFT JOIN "Sl_rad_dic" s ON w."Sl_rada" = s."Id_s"
LEFT JOIN "Org_dic" o ON w."Passp_org" = o."Id_org"
WHERE v."Id_well" = w."Id_well" AND c."Id_cat" = w."Categor"
ORDER BY w."Num";

The query was executed in pgAdmin III
If STATEMENT change to:
select * from v_well_main w where w."Id_dep"=113
then it executed OK

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Locke 2006-12-23 13:10:53 BUG #2863: vacuum failing, weird record in table...
Previous Message goodsforyou 2006-12-23 03:53:46 BUG #2861: when backup UTF-8 database, pgdump add comments not encoded in UTF-8