Postgres Pro
Downloads
Home   >   mailing lists

Re: Permission denied: LOCK TABLE test.__proc IN ACCESS SHARE MODE - Mailing list pgsql-admin

From Tom Lane
Subject Re: Permission denied: LOCK TABLE test.__proc IN ACCESS SHARE MODE
Date
Msg-id 349.1146881338@sss.pgh.pa.us
Whole thread Raw
In response to Permission denied: LOCK TABLE test.__proc IN ACCESS SHARE MODE  (<kynn@panix.com>)
List pgsql-admin
Tree view 
<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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Permission denied: LOCK TABLE test.__proc IN ACCESS SHARE MODE
Next
From:
Date:
Subject: How to list all the privileges a user has?