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