Re: [HACKERS] attlen weirdness?

Marc G. Fournier <scrappy@hub.org>

From: The Hermit Hacker <scrappy@hub.org>
To: "Julia A.Case" <julie@hub.org>
Cc: pgsql-hackers@postgreSQL.org, julie@MageNet.com
Date: 1998-03-11T13:11:48Z
Lists: pgsql-hackers
Bruce?  Guys?  Any word on this one?  I *thought* I remembered reading
soething about the 'attlen' becoming -1, but just checked the mailing list
archives and couldn't find anything :(

Thanks...

On Tue, 10 Mar 1998, Julia A.Case wrote:

> I am using the following info to migrate a table from 6.2.1 to 6.3
> 
> \connect template1 
> drop database magecal;
> create database magecal;
> \connect magecal 
> \connect - julie
> CREATE TABLE dates (id int4, date char(10), news char(1024)) archive = none;
> COPY dates FROM stdin;
> 1	1998Jan16	<H3>Calendar Created</H3>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          !
> !
> !
>                                              
> \.
> CREATE  INDEX dates_indx on dates using btree ( id int4_ops, date bpchar_ops );
> 
> 
> now if I connect to the database and do
> 
> select attlen from pg_attribute where attname='news';
> 
> I get
> -1
> 
> This doesn't seem quite right.
> 
> Julie
> 
> -- 
> [  Julia Anne Case  ] [        Ships are safe inside the harbor,       ]
> [Programmer at large] [      but is that what ships are really for.    ]  
> [   Admining Linux  ] [           To thine own self be true.           ]
> [ Windows/WindowsNT ] [ Fair is where you take your cows to be judged. ]
>