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. When I look at the pg_locks table, I see only two locks, and they both seem to be due to the fact that I am interacting with psql at the moment, and this interaction is in no way directed to the database I'm trying to dump. Is there a way for me to find out the transaction responsible for the lock that's causing the error message? If so, how can I kill this transaction? kj
