Andreas Pflug wrote:I just checked out (at the moment hba.c changed, so I had to redo it), make clean, make, pgsql stop, make install, pgsql start and it's still there.
The current snapshot won't initdb, because running information_schema.sql fails.
The two occurences of "WHERE u.usesysid = ANY( g.grolist )" are the problem. Replacing the ANY clause with some dummy will let everything run ok.
select usename from pg_user, pg_group where usesysid = ANY (grolist)
will yield ERROR: syntaxt error at or near "grolist", so I believe that the ANY(ARRAY) support is broken.
I'm not seeing any problems with a fresh copy of cvs from 15 minutes after you posted. Are you still having the problem?
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html