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
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
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 |