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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-06-22 14:55:07 | Re: BUG #2487: Immutable functions results |
Previous Message | tomas | 2006-06-22 10:24:31 | Re: Error on createuser |