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

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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
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 14:07:50
Message-ID: 20060622140750.GK29883@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-bugs
James A Cole wrote:

> mkeB_reports=# \d arrivals
> Did not find any relation named "arrivals".
> 
> mkeB_reports=# select * from arrivals where ontime>'2006-6-21';
> [data]

> There are many other databases on this server.  Most
> do not have this problem.

Ah, so this is the only one that has suffered transaction id wraparound.
If you don't want to restore from backup, you may want to search the
archives for old threads.  Use keywords "transaction id wraparound" or
maybe "xid wraparound".

Next time you really want to make sure you vacuum the whole database,
often.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-06-22 14:55:07
Subject: Re: BUG #2487: Immutable functions results
Previous:From: tomasDate: 2006-06-22 10:24:31
Subject: Re: Error on createuser

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