CVS 3-22-99 \d broken?

From: James Thompson <jamest(at)math(dot)ksu(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: CVS 3-22-99 \d broken?
Date: 1999-03-23 03:29:03
Message-ID: Pine.GSO.4.05.9903222102370.24113-100000@noether.math.ksu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


This afternoon CVS download.

Table created via
create table
customer (
uid varchar(30) primary key,
id varchar(30) unique,
name_first varchar(30) not null,
name_middle varchar(30),
name_last varchar(30) not null,
company varchar(80),
address1 varchar(50) not null,
address2 varchar(50),
city varchar(30) not null,
state char(2),
country varchar(80),
zip int4,
phone_work varchar(12),
phone_home varchar(12),
phone_fax varchar(12),
email varchar(30),
date_entered date not null,
billing_terms varchar(15) not null,
confirmation_method varchar(10)
);

\d reports

obe=> \d customer

Table = customer
+----------------------------------+----------------------------------+-------+
| Field | Type |Length|
+----------------------------------+----------------------------------+-------+
| uid | varchar() not null |30 |
| id | varchar() |30 |
| name_first | varchar() not null |30 |
| name_middle | varchar() |30 |
| name_last | varchar() not null |30 |
| company | varchar() |80 |
| address1 | varchar() not null |50 |
| address2 | varchar() |50 |
| city | varchar() not null |30 |
| date_entered | date not null |4 |
+----------------------------------+----------------------------------+-------+
Indices: customer_id_key
customer_pkey

But select * shows the columns exist

obe=> select * from customer;
uid|id|name_first|name_middle|name_last|company|address1|address2|city|state|country|zip|phone_work|phone_home|phone_fax|
---+--+----------+-----------+---------+-------+--------+--------+----+-----+-------+---+----------+----------+---------+
email|date_entered|billing_terms|confirmation_method
-----+------------+-------------+-------------------
(0 rows)

I deleted my data dir and started over with initdb with the same results.
All of the tables where created with a script that was not generated by
pgdump.

System tables and views seem to be affected as well

->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
James Thompson 138 Cardwell Hall Manhattan, Ks 66506 785-532-0561
Kansas State University Department of Mathematics
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim Mikheev 1999-03-23 03:33:44 Re: [HACKERS] portals vs. memory contexts
Previous Message Vadim Mikheev 1999-03-23 03:17:09 Re: portals vs. memory contexts