ERROR: aclcheck: first entry in ACL is Not 'world' entry

Поиск
Список
Период
Сортировка
Искать
От
Phil Geer
Тема
ERROR: aclcheck: first entry in ACL is Not 'world' entry
Дата
Msg-id
01d601c1c7f4$d25ea450$4ac16dd8@offback2000
Список
Дерево обсуждения
Re: ERROR: aclcheck: first entry in ACL is Not 'world' entry "Phil Geer" <philg@gearcc.com>
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 по дате отправления
От: Michael
Дата:
От: Tom Lane
Дата:
FAQ