An idea only.
Ever try this?
select reltype from pg_class where relname='foo';
Then, delete the reltype from pg_class
To me goes fine.
Best wishes, Guido
Nigel Bishop wrote:
Hi
I'm getting an error with pg_dump:
I'm using
pg_dump -v -C -U username database > ./dumpfile.dmp
and it errors with:
pg_dump: saving database definition pg_dump: reading namespaces pg_dump: reading user-defined types pg_dump: reading user-defined functions pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined operator classes pg_dump: reading user-defined tables pg_dump: Attempt to lock table "Foo" failed. ERROR: MySchema: permission denied pg_dump: *** aborted because of error
Issueing a SELECT * FROM PG_TABLES;
Shows:
MySchema | Foo | postgres | t | f | f
If I try to drop this it errors saying the table foo doesn't exist.
Where did this object come from and how can I resolve the pg_dump error
TIA
Nigel
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
