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

From: <kynn(at)panix(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Permission denied: LOCK TABLE test.__proc IN ACCESS SHARE MODE
Date: 2006-05-05 22:04:58
Message-ID: 200605052204.k45M4w810864@panix3.panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2006-05-06 05:13:37 Switch to Linux Dev Questions
Previous Message Obe, Regina DND\MIS 2006-05-05 20:43:12 Re: looking for some suggestions