Hello all,
I'm getting the following error message.
ERROR: aclcheck: first entry in ACL is not 'world' entry
This is on a new server I'm setting up it is postgresql 7.2 compiled from
source on SuSE Linux 7.2.
I then load a database that I dumped from postgresql 7.1.3 on my production
server.
I've gone back and revoke everyone's table privileges on all the tables and
then granted the privileges again. The only one that can seem to do selects
on the tables is the superuser. Anyone else gets this error message. One
thing I noticed was looking in the pg_class table in 7.1.3 the relacl column
the entries look like this
{"=", "user1=arw"} and in 7.2 it look like this { =, user1=arw }
I'm not sure the quotes in 7.1.3 should be there in 7.2 but if so how do I
get them in.
Thanks
Phil