Re: problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist - Mailing list pgsql-admin

From Tom Lane
Subject Re: problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist
Date
Msg-id 4499.1173482961@sss.pgh.pa.us
Whole thread Raw
In response to Re: problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist  ("Glen W. Mabey" <Glen.Mabey@swri.org>)
Responses Re: problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist  ("Glen W. Mabey" <Glen.Mabey@swri.org>)
List pgsql-admin
"Glen W. Mabey" <Glen.Mabey@swri.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.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Glen W. Mabey"
Date:
Subject: Re: problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] index bloat problem