The following bug has been logged online:

Bug reference: 2489
Logged by: James A Cole
Email address: jacole (AT) acm (DOT) org
PostgreSQL version: 7.4.13
Operating system: Red Hat Enterprise Linux 4
Description: Metadata dosen't match tables
Details:

PostgreSQL 7.4.13 on i386-redhat-linux-gnu, compiled by GCC
i386-redhat-linux-gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-2)

mkeB_reports=# \d arrivals
Did not find any relation named "arrivals".

mkeB_reports=# select * from arrivals where ontime>'2006-6-21';
ontime | flightid | airline | runway | upline | downline |
acty
pe | sta | beacon | icao24 | tail | term |
gate
----
---+------------------------+--------+----------+----------+----------+-----
----
-+---------+-------------------------------
2006-06-21 00:16:52-04 | ACT301 | ACT | 01L | MDW | MKE |
PA31
C208


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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

James A Cole wrote:

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 majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

"James A Cole" <jacole (AT) acm (DOT) org> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly