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

2010-05-23 Thread Tom Lane
Pavel Stehule pavel.steh...@gmail.com 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

[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 (