From: Alvaro Sanchez-Mariscal <mariscal@javahispano.org>
To: pgsql-sql@postgresql.org
Subject: Unrecognized node type
Date: Tue, 22 Jun 2004 16:56:10 +0200
Message-ID: <1087916170.2821.23.camel@mariscal> (raw)
Hi:
I've to import a DB schema and data from one pgsql to another. The
source version is 7.3.4. The destination version is 7.4.2.
I've tried to import a dump from pg_dump. Everything goes ok, but at
certain point, in the following sentence:
CREATE TABLE ca_persona (
...
lssi boolean DEFAULT NULL::boolean,
postal boolean DEFAULT NULL::boolean,
tele_marketing boolean DEFAULT NULL::boolean,
...
)
I get the following error message:
"ERROR: unrecognized node type: 656".
If I remove those fields, then nothing fails. But I cannot simply change
table definition, because then the (J2EE) application doesn't works. The
sql must be with NULL::boolean default values.
Both source and destination databases have the same encoding
(iso-8859-15, "LATIN_9"). Both servers are running on Linux.
The same dump have worked correctly in many other machines running
Postgres on Windows with Cygwin, with many different versions (7.3.x and
7.4.x).
I've tried all the ways of dumping with pg_dump, and using pg_restore in
those ways, or loading the sql script from psql, and always fails :-(.
Also I've tried with different versions of Postgres, from RPM packages
and building from source code, and again always fails :-(.
My question is simple: what the h... can I do? :-)
Please CC me your replies as I'm not suscribed to this list. Thanks in
advance.
PS: sorry about my english :-).
--
Álvaro Sánchez-Mariscal Arnaiz | Departamento de Comunicación
mariscal@javahispano.org | javaHispano
javaHispano. Una Comunidad al Servicio de Todos
www.javaHispano.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mariscal@javahispano.org
Subject: Re: Unrecognized node type
In-Reply-To: <1087916170.2821.23.camel@mariscal>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox