Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group