Horton

Thread

  1. psql bug?

    Sarah Officer <officers@aries.tucson.saic.com> — 2000-01-26T22:14:08Z

    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)