On Sun, May 23, 2010 at 2:11 PM, Jehan-Guillaume (ioguix) de Rorthais <j...@dalibo.com> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hello, > > A user reported us the following bug under phpPgAdmin with 9.0beta1, but it > seems it comes from backend. > > Here is how to reproduce the bug: > > ================> > postgres=# SELECT version(); > version > - > ---------------------------------------------------------------------------------------------- > PostgreSQL 9.0beta1 on i686-pc-linux-gnu, compiled by GCC gcc (Debian > 4.4.3-2) 4.4.3, 32-bit > (1 row) > > 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 -- Joshua Tolley / eggyknap End Point Corporation -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
