problem with arrays

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 |
+----------------------------------------------------------------------+

Responses

Browse pgsql-hackers by date

  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