ERROR: aclcheck: first entry in ACL is Not 'world' entry - Mailing list pgsql-general

From Phil Geer
Subject ERROR: aclcheck: first entry in ACL is Not 'world' entry
Date
Msg-id 01d601c1c7f4$d25ea450$4ac16dd8@offback2000
Whole thread Raw
Responses Re: ERROR: aclcheck: first entry in ACL is Not 'world' entry  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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




pgsql-general by date:

Previous
From: "Michael"
Date:
Subject: postgres 7.2 make check problem
Next
From: Tom Lane
Date:
Subject: Re: postgres 7.2 make check problem