On Fri, Mar 09, 2007 at 06:29:21PM -0500, Tom Lane wrote:
> "Glen W. Mabey" <Glen(dot)Mabey(at)swri(dot)org> writes:
> > What I see is a bunch of stuff related to the Acquisitions table,
> > including a relation for the primary key, which was created back when
> > the table was named "Acquisition" (not plural), and two different views
> > which draw on Acquisitions, both of which appear to be fully
> > functional.
> I wonder whether "reindex index pg_class_relname_nsp_index" would make
> this go away.
Great -- that did it.
However, after I executed that command, SELECT FROM "Acquisitions" LIMIT 1; still
indicated that "Acquisitions" did not exist. But then a pg_dump command
succeeded, and afterwared, SELECT FROM "Acquisitions" LIMIT 1; did also
Thank you very much for your help.
Is this a bug that should be reported?
And, what does "reindex index pg_class_relname_nsp_index" do, anyway?
Also, there is another user who has posted to this list describing what
I first saw when encountering this problem: trouble running pg_dump.
In response to
pgsql-admin by date
|Next:||From: Glen W. Mabey||Date: 2007-03-12 15:07:38|
|Subject: Re: pg_dump and pg_dumpall is hanging|
|Previous:||From: Magnus Hagander||Date: 2007-03-12 14:37:57|
|Subject: Re: [GENERAL] PostgreSQL crashes on Windows 2003|