Joshua Tolley <eggyk...@gmail.com> writes: > On Sun, May 23, 2010 at 2:11 PM, Jehan-Guillaume (ioguix) de Rorthais > <j...@dalibo.com> wrote: >> Here is how to reproduce the bug: >> postgres=# SELECT rolname FROM pg_catalog.pg_roles AS r, pg_auth_members AS m >> WHERE r.oid=m.roleid >> AND member IN ( >> SELECT oid FROM pg_catalog.pg_roles >> WHERE rolname='postgres') >> ORDER BY rolname; >> ERROR: failed to build any 3-way joins
> Just a guess, but I'd bet this was fixed by the very recent commit to > fix this: http://archives.postgresql.org/pgsql-hackers/2010-05/msg01203.php Worksforme in CVS HEAD, so apparently it is that same bug. Thanks for the report though! regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs