Обсуждение: table disappear from pg_class

Hi all,
I have a problem with a table which is disappeared from pg_class
with all objects related (views, indexes and so on).
pg_dump against this table does not work (I think because it is not
present in pg_class).

The strange behaviour is that I can select data from this table !!
We are using a 7.4.6 on linux (slackware).

Any help will be appreciated we are in emergency

regards
M.

marco wrote:
> Hi all,
> I have a problem with a table which is disappeared from pg_class
> with all objects related (views, indexes and so on).
> pg_dump against this table does not work (I think because it is not
> present in pg_class).
>
> The strange behaviour is that I can select data from this table !!

This sounds very much like transaction Id wraparound, meaning you failed
to vacuum pg_class (and possibly other system catalogs as well) in a
timely fashion.  Basically you need to return the transaction counter a
little bit, then vacuum and make sure all your data is still consistent.

This has been discussed before.  See for example:

http://archives.postgresql.org/pgsql-bugs/2005-05/msg00079.php

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.