This is a discussion on Permission denied: LOCK TABLE test.__proc IN ACCESS SHARE MODE within the pgsql Novice forums, part of the PostgreSQL category; --> Hi. I was checking out the idea that Tom Lane kindly gave me in his reply to an earlier ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi. I was checking out the idea that Tom Lane kindly gave me in his reply to an earlier post, and I'm running into a strange error when I run pg_dump: 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 The thing is that neither the schema test nor the relation test.__proc exists any longer! How do I fix this? Thanks! kj ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |