Need some help: attlen is pg_attributes gives a negative value.. .
Klein, Robert <rvklein@ober.com>
From: "Klein, Robert" <rvklein@ober.com>
To: pgsql-sql@postgresql.org
Cc: bugs@postgresql.org
Date: 2000-05-03T20:27:22Z
Lists: pgsql-bugs
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