Re: Permission denied: LOCK TABLE test.__proc IN ACCESS SHARE MODE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Permission denied: LOCK TABLE test.__proc IN ACCESS SHARE MODE
Дата
Msg-id 349.1146881338@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Permission denied: LOCK TABLE test.__proc IN ACCESS SHARE MODE  (<kynn@panix.com>)
Список pgsql-admin
<kynn@panix.com> writes:
> When I run pg_dump I get this error:

> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR:  permission denied for schema test
> pg_dump: The command was: LOCK TABLE test.__proc IN ACCESS SHARE MODE

> I can't find out what transaction is responsible for this lock.

What lock?  The error is "permission denied".  It looks like whatever
user you're running pg_dump as doesn't have USAGE permission on that
schema.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Permission denied: LOCK TABLE test.__proc IN ACCESS SHARE MODE
Следующее
От:
Дата:
Сообщение: How to list all the privileges a user has?