Re: [HACKERS] Strange left join problems in 8.1

2005-12-04 Thread Mario Weilguni
t: Sa 03.12.2005 17:53 An: Mario Weilguni Cc: pgsql-hackers@postgresql.org Betreff: Re: [HACKERS] Strange left join problems in 8.1 "Mario Weilguni" <[EMAIL PROTECTED]> writes: > It seems like the planner is pulling the last where condition into the > second left join, evaluating

Re: [HACKERS] Strange left join problems in 8.1

2005-12-03 Thread Tom Lane
Mario Weilguni <[EMAIL PROTECTED]> writes: > Of course I can give it a try, do I need to re-initdb when I use cvs to > checkout 8.1 tip? No, not if you're on 8.1 final (or anything post-beta4, IIRC). Just be sure to use the same configure arguments as before (pg_config can help remind you if you

Re: [HACKERS] Strange left join problems in 8.1

2005-12-03 Thread Mario Weilguni
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 Of course I ca

Re: [HACKERS] Strange left join problems in 8.1

2005-12-03 Thread Tom Lane
"Mario Weilguni" <[EMAIL PROTECTED]> 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 aro