attlen weirdness?

From: "Julia A(dot)Case" <julie(at)hub(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: attlen weirdness?
Date: 1998-03-10 10:00:56
Message-ID: 19980310100056.45534@MageNet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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. ]

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Maarten Boekhold 1998-03-10 10:56:57 Re: [HACKERS] Heh, the disappearing problem!
Previous Message Zeugswetter Andreas 1998-03-10 09:13:08 WG: [HACKERS] newoid in invapi.c