<kynn(at)panix(dot)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