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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "James A Cole" <jacole(at)acm(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2489: Metadata dosen't match tables
Date: 2006-06-22 15:42:47
Message-ID: 234.1150990967@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-06-22 17:41:32 Re: BUG #2490: '||' and type casting for user defined types
Previous Message Tom Lane 2006-06-22 14:55:07 Re: BUG #2487: Immutable functions results