From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nigel Bishop <Nigel.Bishop@ioko.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump Error
Date: Tue, 29 Jun 2004 10:16:03 -0400
Message-ID: <28954.1088518563@sss.pgh.pa.us> (raw)
In-Reply-To: <72558D9A7573814BB4082A28843E03D40B414D@intyodc01.uk.ioko365.com>
References: <72558D9A7573814BB4082A28843E03D40B414D@intyodc01.uk.ioko365.com>
"Nigel Bishop" <Nigel.Bishop@ioko.com> writes:
> pg_dump: Attempt to lock table "Foo" failed. ERROR: MySchema:
> permission denied
Looks like you need to grant yourself usage rights on the schema
"MySchema".
> If I try to drop this it errors saying the table foo doesn't exist.
Can't tell whether you forgot to schema-qualify the name or whether
you forgot to quote it to protect the mixed case, but something
along the lines of
drop table "MySchema"."Foo";
is what you would need. Note that that will also fail unless you've
fixed the permissions problem for MySchema, though.
> Where did this object come from
Presumably, you created it.
regards, tom lane
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: tgl@sss.pgh.pa.us, Nigel.Bishop@ioko.com
Subject: Re: pg_dump Error
In-Reply-To: <28954.1088518563@sss.pgh.pa.us>
* 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