CVS 3-22-99 \d broken? - Mailing list pgsql-hackers
From | James Thompson |
---|---|
Subject | CVS 3-22-99 \d broken? |
Date | |
Msg-id | Pine.GSO.4.05.9903222102370.24113-100000@noether.math.ksu.edu Whole thread Raw |
Responses |
Re: [HACKERS] CVS 3-22-99 \d broken?
|
List | 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 ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
pgsql-hackers by date: