Re: [HACKERS] ERROR: failed to build any 8-way joins

2007-02-15 Thread Alvaro Herrera
Mario Weilguni wrote: Interesting: remove any of the above where conditions solves the problem go away, e.g. removing and bei.id=10157309. Testet with 8.2.1 and 8.1.4, same effect on both systems. Because of the large number of tables involved it's difficult to find a self contained

Re: [HACKERS] ERROR: failed to build any 8-way joins

2007-02-15 Thread Mario Weilguni
Thanks for the info. Is there a fix for 8.1 branch, the production system is still 8.1. Regards Mario Weilguni Am Donnerstag, 15. Februar 2007 16:25 schrieb Alvaro Herrera: Mario Weilguni wrote: Interesting: remove any of the above where conditions solves the problem go away,

Re: [HACKERS] ERROR: failed to build any 8-way joins

2007-02-15 Thread Tom Lane
Mario Weilguni [EMAIL PROTECTED] writes: ERROR: failed to build any 8-way joins Could you provide a self-contained test case for this? You probably don't need any data, just the table schemas. I fixed a problem with a similar symptom a couple days ago, but that was in logic that was new in