problem with arrays
Massimo Dal Zotto <dz@cs.unitn.it>
From: Massimo Dal Zotto <dz@cs.unitn.it>
To: hackers@postgreSQL.org (PostgreSQL Hackers)
Date: 1999-01-06T16:39:09Z
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@cs.unitn.it | | Via Marconi, 141 phone: ++39-0461534251 | | 38057 Pergine Valsugana (TN) www: http://www.cs.unitn.it/~dz/ | | Italy pgp: finger dz@tango.cs.unitn.it | +----------------------------------------------------------------------+