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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
