Re: BUG #2489: Metadata dosen't match tables

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"James A Cole" <jacole(at)acm(dot)org> writes:
> mkeB_reports=# \d arrivals
> Did not find any relation named "arrivals".

> mkeB_reports=# select * from arrivals where ontime>'2006-6-21';
> [ works ]

Looks like XID wraparound in the system catalogs.  You can probably get
out of it with a database-wide VACUUM, but there is some risk that
you've lost data.  Please read the administrator's guide part of the
manual concerning routine vacuuming requirements.

			regards, tom lane