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

From Mario Weilguni
Subject Re: Strange left join problems in 8.1
Date
Msg-id FA095C015271B64E99B197937712FD026679F5@freedom.grz.icomedias.com
Whole thread Raw
List pgsql-hackers
<p><font size="2">I've tried this with cvs , -r REL8_1_STABLE (hope this was the right one), and works flawless now.<br
/><br/> Thanks a lot!<br /><br /> Best regards<br /> Mario Weilguni<br /><br /><br /> -----Ursprüngliche
Nachricht-----<br/> Von: Tom Lane [<a href="mailto:tgl@sss.pgh.pa.us">mailto:tgl@sss.pgh.pa.us</a>]<br /> Gesendet: Sa
03.12.200517:53<br /> An: Mario Weilguni<br /> Cc: pgsql-hackers@postgresql.org<br /> Betreff: Re: [HACKERS] Strange
leftjoin problems in 8.1<br /><br /> "Mario Weilguni" <mario.weilguni@icomedias.com> writes:<br /> > It seems
likethe planner is pulling the last where condition into the<br /> > second left join, evaluating it in wrong
order.<br/><br /> Can you try this on 8.1 branch tip?  It sounds suspiciously similar to<br /> an already-fixed issue
(seereports from Sebastian Böck around<br /> mid-November).  You haven't provided a complete test case so I really<br
/>can't investigate for myself ...<br /><br />                         regards, tom lane<br /><br /></font> 

pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: SERIAL type feature request
Next
From: Simon Riggs
Date:
Subject: Re: generalizing the planner knobs