Need some help: attlen is pg_attributes gives a negative value.. .

From: "Klein, Robert" <rvklein(at)ober(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Cc: bugs(at)postgresql(dot)org
Subject: Need some help: attlen is pg_attributes gives a negative value.. .
Date: 2000-05-03 20:27:22
Message-ID: C71D2D07293AD31186F50004ACB848F28419D2@EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Klein, Robert 2000-05-03 20:40:27 RE: Need some help: attlen is pg_attributes gives a negat ive value.. .
Previous Message Peter Eisentraut 2000-05-03 09:07:43 Re: Database corruption caused by long insert strings