Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0G1Jc025127
	for <pgsql-sql@postgresql.org>; Mon, 15 Jan 2001 20:19:38 -0500 (EST)
	(envelope-from t-ishii@sra.co.jp)
Received: from sranhk.sra.co.jp (sranhk [133.137.36.134])
	by sraigw.sra.co.jp (8.8.7/3.7W-sraigw) with ESMTP id KAA02699;
	Tue, 16 Jan 2001 10:19:32 +0900 (JST)
Received: from localhost (IDENT:t-ishii@srapc1474 [133.137.36.84])
	by sranhk.sra.co.jp (8.9.3/3.7W-srambox) with ESMTP id KAA23407;
	Tue, 16 Jan 2001 10:19:32 +0900
To: pjw@rhyme.com.au
Cc: jhspies@adept.co.za, pgsql-sql@postgresql.org
Subject: Re: pg_dump error
In-Reply-To: <3.0.5.32.20010116120349.02e707d0@mail.rhyme.com.au>
References: <20010115221325.A18814@adept.co.za>
	<3.0.5.32.20010116120349.02e707d0@mail.rhyme.com.au>
X-Mailer: Mew version 1.94.2 on Emacs 20.7 / Mule 4.1
	=?iso-2022-jp?B?KBskQjAqGyhCKQ==?=
Mime-Version: 1.0
Content-Type: Text/Plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-Id: <20010116101929G.t-ishii@sra.co.jp>
Date: Tue, 16 Jan 2001 10:19:29 +0900
From: Tatsuo Ishii <t-ishii@sra.co.jp>
X-Dispatcher: imput version 20000228(IM140)
Lines: 18
X-Archive-Number: 200101/154
X-Sequence-Number: 815

> >Can not create pgdump_oid table.  Explanation from backend: 'ERROR:
> >cannot create pgdump_oid
> >
> >Is there a way to repair this?
> >
> 
> If there was an earlier crash while running pg_dump, the table may already
> exist. If so, try deleting it. Also, can you confirm that the username
> under which you run pg_dump has the rights to create tables?

I have observed it several times on 7.0.x while using
pg_dumpall. Since pg_dumpall would create pgdump_oid as many times as
the number of databases, I suspect there might be an internal cache
problem in the backend. However this problem was hard to reproduce, I
have not tackled it yet. If someone has a reproducible data, please
let us know...
--
Tatsuo Ishii