View Single Post

   
  #1 (permalink)  
Old 04-10-2008, 10:04 AM
James A Cole
 
Posts: n/a
Default BUG #2489: Metadata dosen't match tables


The following bug has been logged online:

Bug reference: 2489
Logged by: James A Cole
Email address: jacole@acm.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
| 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

Reply With Quote