Thread

RE: Need some help: attlen is pg_attributes gives a negat ive value.. .

Klein, Robert <rvklein@ober.com> — 2000-05-03T20:40:27Z

I just answered my own question.  atttypmod now holds this value.

thanks,
Rob

-----Original Message-----
From: Klein, Robert [mailto:rvklein@ober.com]
Sent: Wednesday, May 03, 2000 4:27 PM
To: pgsql-sql@postgresql.org
Cc: bugs@postgresql.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