Re: pg_dump Error

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
>
>
>
>