From: Guido Barosio <gbarosio@sinectis.com.ar>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump Error
Date: Tue, 29 Jun 2004 08:27:13 -0300
Message-ID: <40E15211.4060009@sinectis.com.ar> (raw)
References: <72558D9A7573814BB4082A28843E03D40B414D@intyodc01.uk.ioko365.com>
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
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gbarosio@sinectis.com.ar
Subject: Re: pg_dump Error
In-Reply-To: <40E15211.4060009@sinectis.com.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox