Skip site navigation (1) Skip section navigation (2)

BUG #2489: Metadata dosen't match tables

From: "James A Cole" <jacole(at)acm(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2489: Metadata dosen't match tables
Date: 2006-06-21 17:08:38
Message-ID: 200606211708.k5LH8c35082513@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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  
 | 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

Responses

pgsql-bugs by date

Next:From: Klaus ItaDate: 2006-06-22 06:23:07
Subject: Re: Error on createuser
Previous:From: Masao FujiiDate: 2006-06-21 13:20:47
Subject: BUG #2488: backup history file is archived doubly

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group