SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 10:28 AM
| ||||
| ||||
 BUG #2837: i received ERROR: failed to build any 7-way joins The following bug has been logged online: Bug reference: 2837 Logged by: canli Email address: canli@wp.pl PostgreSQL version: 8.2.0 Operating system: Linux ES 4 Description: i received ERROR: failed to build any 7-way joins Details: When I execute a query: SELECT n1.numer AS wydany_nr, n2.numer AS zwrocony_nr FROM operacje o LEFT JOIN (wydane_numery wt1 JOIN boki_ numery bn1 USING(id_nr_w_bok) JOIN numery n1 USING(id_numeru )) ON(wt1.id_operacji = o.id_operacji AND wt1.wydanie_zwrot = 'W') LEFT JOIN (wydane_numery wt2 JOIN boki_numery bn2 USING(id_nr_w_bok) JOIN numery n2 USING(id_numeru )) ON(wt2.id_operacji = o.id_operacji AND wt2.wydanie_zwrot = 'Z') WHERE o.id_operacji = 349736 i received an error: failed to build any 7-way joins ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate      |
|
04-10-2008, 10:28 AM
| ||||
| ||||
| Re: BUG #2837: i received ERROR: failed to build any 7-way joins "canli" <canli@wp.pl> writes: > i received an error: failed to build any 7-way joins I think this is the same problem already reported here: http://archives.postgresql.org/pgsql...2/msg00092.php and patched here: http://archives.postgresql.org/pgsql...2/msg00102.php regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
 |
« BUG #2835: Table inheritance and statement level trigger.
|
No error when FROM is missing in subquery »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 11:10 PM.
