From: | Massimo Dal Zotto <dz(at)cs(dot)unitn(dot)it> |
---|---|
To: | hackers(at)postgreSQL(dot)org (PostgreSQL Hackers) |
Subject: | problem with arrays |
Date: | 1999-01-06 16:39:09 |
Message-ID: | 199901061639.RAA05058@nikita.wizard.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I'm trying to convert some tables from version 6.2 to 6.4.2 but I have
problems with arrays. The old table definition was:
create table a (
x int4,
y char8,
z char8[]
);
Now, because the char8 datatype has been removed from postgres, I suppose
I should use char(8) or varchar(8):
create table a (
x int4,
y char(8),
z char(8)[]
);
or
create table a (
x int4,
y varchar(8),
z varchar(8)[]
);
but when I try the above definitions I get the following errors:
dz=> create table a (
dz-> x int4,
dz-> y char(8),
dz-> z char(8)[]
dz-> );
ERROR: type name lookup of _bpchar failed
dz=> create table a (
dz-> x int4,
dz-> y varchar(8),
dz-> z varchar(8)[]
dz-> );
ERROR: type name lookup of _varchar failed
Also trying to define the _varchar or _bpchar types fails, so it seems that
the conversion from 6.2 to 6.4 is not possible for many data types.
Any suggestion?
--
Massimo Dal Zotto
+----------------------------------------------------------------------+
| Massimo Dal Zotto email: dz(at)cs(dot)unitn(dot)it |
| Via Marconi, 141 phone: ++39-0461534251 |
| 38057 Pergine Valsugana (TN) www: http://www.cs.unitn.it/~dz/ |
| Italy pgp: finger dz(at)tango(dot)cs(dot)unitn(dot)it |
+----------------------------------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1999-01-06 17:09:48 | Re: [HACKERS] Numeric type |
Previous Message | Oleg Bartunov | 1999-01-06 16:28:56 | Re: [HACKERS] Numeric type |