Re: [HACKERS] ERROR: failed to build any 8-way joins
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 8.2 ... regards, tom lane ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [HACKERS] ERROR: failed to build any 8-way joins
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, 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 > > patch, but if necessary I'll give it a try. I could give 8.2.3 a try, but > > I doubt this will help. > > I think a similar problem was fixed after 8.2.3 was released, so you may > want to check out the REL8_2_STABLE branch. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] ERROR: failed to build any 8-way joins
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 > patch, but if necessary I'll give it a try. > I could give 8.2.3 a try, but I doubt this will help. I think a similar problem was fixed after 8.2.3 was released, so you may want to check out the REL8_2_STABLE branch. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly