Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group