Postgres Pro
Downloads
Home   >   mailing lists

Re: Joins on over 10 tables returns unreliable results - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Joins on over 10 tables returns unreliable results
Date
Msg-id 24517.973150888@sss.pgh.pa.us
Whole thread Raw
In response to Joins on over 10 tables returns unreliable results  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> Running Postgres version 7.01 on Redhat linux 6.2.  When joining on
> more than 10 tables not all of the expected results are returned.

Do you get a query plan involving mergejoins for these queries?
If so it's probably fixed for 7.0.3, please try that as soon as
it's out...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: RPM install weirdness & BugreportPage Bug
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: JDBC-Driver produces wrong output.