Re: [HACKERS] beta testing - planner bug - ERROR: XX000: failed to build any 2-way joins

2010-05-23 Thread Tom Lane
Pavel Stehule writes: > postgres=# explain SELECT name > FROM person > WHERE name IN ( >SELECT name FROM person p >LEFT JOIN person_data ON p.id = person_data.id); > ERROR: failed to build any 2-way joins Fixed, thanks. regards, tom lane -- Sent via pgs

[HACKERS] beta testing - planner bug - ERROR: XX000: failed to build any 2-way joins

2010-05-21 Thread Pavel Stehule
Hello there are maybe planner bug. test case: CREATE TABLE person ( id SERIAL PRIMARY KEY, name VARCHAR(64) ) WITHOUT OIDS; CREATE TABLE person_data ( id SERIAL PRIMARY KEY ) WITHOUT OIDS; SELECT name FROM person WHERE name IN (