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

psql bug?

From: Sarah Officer <officers(at)aries(dot)tucson(dot)saic(dot)com>
To: pgsql-bugs(at)postgreSQL(dot)org, officers(at)aries(dot)tucson(dot)saic(dot)com
Subject: psql bug?
Date: 2000-01-26 22:14:08
Message-ID: 388F71B0.488B7CEA@aries.tucson.saic.com (view raw or flat)
Thread:
Lists: pgsql-bugs
I can't describe any table I create.  I am able to select contents.

psql mydb
mydb=> \d
Database    = bcams
 +------------------+----------------------------------+----------+
 |  Owner           |             Relation             |   Type   |
 +------------------+----------------------------------+----------+
 | dusty            | sites                            | table    |
 | dusty            | sites_pkey                       | index    |
 +------------------+----------------------------------+----------+

mydb=> \d sites
ERROR:  typeidTypeRelid: Invalid type - oid = 0

mydb=> select * from sites
mydb-> ;
        id|site_name       |    first|   second|category_code
----------+----------------+---------+---------+-------------
1111-11111|TRI-CITY AIRPORT|44.111000|18.111000|            1
2222-22222|USED CAR LOT    |44.222000|18.222000|            1
3333-33333|BIG CITY MALL   |44.333000|18.333000|            2
4444-44444|TOWN DUMP       |44.444000|18.444000|            1
5555-55555|VILLAGE PARK NE |44.555000|18.555000|            1
(5 rows)

pgsql-bugs by date

Next:From: hbqlqxDate: 2000-01-28 17:10:26
Subject: xxxscreensavers for you 462 [2/2]
Previous:From: Alex GuryanowDate: 2000-01-26 10:24:21
Subject: pqReadData() error

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