The following bug has been logged online: Bug reference: 2489 Logged by: James A Cole Email address: [EMAIL PROTECTED] 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 | etatype | cetatime ------------------------+----------+---------+--------+--------+----------+- ---- ---+------------------------+--------+----------+----------+----------+----- ---- -+---------+------------------------------- 2006-06-21 00:16:52-04 | ACT301 | ACT | 01L | MDW | MKE | PA31 | | | | | | | 8 | 2006-06-21 00:18:29.538826-04 2006-06-21 01:04:08-04 | USC361 | USC | 01L | MDW | MKE | C208 | | | | | | | 8 | 2006-06-21 01:05:53.170079-04 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