From: | "Klein, Robert" <rvklein(at)ober(dot)com> |
---|---|
To: | "Klein, Robert" <rvklein(at)ober(dot)com>, pgsql-sql(at)postgresql(dot)org |
Cc: | bugs(at)postgresql(dot)org |
Subject: | RE: Need some help: attlen is pg_attributes gives a negat ive value.. . |
Date: | 2000-05-03 20:40:27 |
Message-ID: | C71D2D07293AD31186F50004ACB848F28419D3@EXCHANGE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I just answered my own question. atttypmod now holds this value.
thanks,
Rob
-----Original Message-----
From: Klein, Robert [mailto:rvklein(at)ober(dot)com]
Sent: Wednesday, May 03, 2000 4:27 PM
To: pgsql-sql(at)postgresql(dot)org
Cc: bugs(at)postgresql(dot)org
Subject: [BUGS] Need some help: attlen is pg_attributes gives a negative
value.. .
I have a table defined as:
create table contacts (
c_name char (20),
c_title char (30),
c_phone char (13),
c_ext char (5),
c_email char (60),
c_sort char (5)
);
when I query the catalog to get the field length for auto generating HTML
forms I get:
attnum|attname|typname|attlen
------+-------+-------+------
1|c_name |bpchar | -1
2|c_title|bpchar | -1
3|c_phone|bpchar | -1
4|c_ext |bpchar | -1
5|c_email|bpchar | -1
6|c_sort |bpchar | -1
(6 rows)
I know in previous versions the length as defined in the create table
statement was given. Any ideas?
Rob
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-05-03 20:56:06 | Re: Need some help: attlen is pg_attributes gives a negative value.. . |
Previous Message | Klein, Robert | 2000-05-03 20:27:22 | Need some help: attlen is pg_attributes gives a negative value.. . |