Postgres Pro
Downloads
Home   >   mailing lists

Re: Join Problem in Postgres 7.0.2 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Join Problem in Postgres 7.0.2
Date
Msg-id 27642.975515775@sss.pgh.pa.us
Whole thread Raw
In response to Join Problem in Postgres 7.0.2  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> I get into a situation, in which I think it is a bug in either psql or
> the database.  I have experienced that when I ran two queries in psql,
> which are equivalent, I received two different results

Does EXPLAIN show that the failing query has a Merge Join directly
underneath another Merge Join?  If so, this is a known bug.  It's
fixed in 7.0.3.

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Join Problem in Postgres 7.0.2
Next
From: Karla Peralta
Date:
Subject: Re: PortalHeapMemoryFree...in diskless client