Re: Strange left join problems in 8.1 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Strange left join problems in 8.1
Date
Msg-id 677.1133628835@sss.pgh.pa.us
Whole thread Raw
In response to Strange left join problems in 8.1  ("Mario Weilguni" <mario.weilguni@icomedias.com>)
Responses Re: Strange left join problems in 8.1
List pgsql-hackers
"Mario Weilguni" <mario.weilguni@icomedias.com> writes:
> It seems like the planner is pulling the last where condition into the
> second left join, evaluating it in wrong order.

Can you try this on 8.1 branch tip?  It sounds suspiciously similar to
an already-fixed issue (see reports from Sebastian B�ck around
mid-November).  You haven't provided a complete test case so I really
can't investigate for myself ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Striping CLOG and Subtrans
Next
From: Tom Lane
Date:
Subject: Re: Reducing relation locking overhead