X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 2E937D1B19F
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 29 Jun 2004 08:27:11 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 93124-07
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 29 Jun 2004 11:27:12 +0000 (GMT)
Received: from ender.capfed1.uolsinectis.com.ar (ender.capfed1.sinectis.com.ar
	[216.244.211.101])
	by svr1.postgresql.org (Postfix) with ESMTP id 9F25BD1B1B6
	for <pgsql-admin@postgresql.org>; Tue, 29 Jun 2004 08:27:07 -0300 (ADT)
Received: from sinectis.com.ar (mail.dtnet.com.ar [200.0.213.22])
	by ender.capfed1.uolsinectis.com.ar (Postfix) with ESMTP id B5331E6D22
	for <pgsql-admin@postgresql.org>;
	Tue, 29 Jun 2004 08:27:08 -0300 (GMT+3)
Message-ID: <40E15211.4060009@sinectis.com.ar>
Date: Tue, 29 Jun 2004 08:27:13 -0300
From: Guido Barosio <gbarosio@sinectis.com.ar>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020830
X-Accept-Language: en-us, en
MIME-Version: 1.0
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump Error
References: <72558D9A7573814BB4082A28843E03D40B414D@intyodc01.uk.ioko365.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200407/15
X-Sequence-Number: 14083


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