CVS 3-22-99 \d broken?

Поиск
Список
Период
Сортировка
От James Thompson
Тема CVS 3-22-99 \d broken?
Дата
Msg-id Pine.GSO.4.05.9903222102370.24113-100000@noether.math.ksu.edu
обсуждение исходный текст
Ответы Re: [HACKERS] CVS 3-22-99 \d broken?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Vadim Mikheev
Дата:
Сообщение: Re: portals vs. memory contexts
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] portals vs. memory contexts