From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Sanchez-Mariscal <mariscal@javahispano.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: Unrecognized node type
Date: Tue, 29 Jun 2004 12:18:17 -0400
Message-ID: <1624.1088525897@sss.pgh.pa.us> (raw)
In-Reply-To: <1087916170.2821.23.camel@mariscal>
References: <1087916170.2821.23.camel@mariscal>
Alvaro Sanchez-Mariscal <mariscal@javahispano.org> writes:
> 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".
I couldn't duplicate this:
regression=# CREATE TABLE ca_persona (
regression(# lssi boolean DEFAULT NULL::boolean,
regression(# postal boolean DEFAULT NULL::boolean,
regression(# tele_marketing boolean DEFAULT NULL::boolean);
CREATE TABLE
regression=# \d ca_persona
Table "public.ca_persona"
Column | Type | Modifiers
----------------+---------+-----------------------
lssi | boolean | default NULL::boolean
postal | boolean | default NULL::boolean
tele_marketing | boolean | default NULL::boolean
regression=# insert into ca_persona default values;
INSERT 154658 1
regression=#
I suppose there's some other factor involved in the problem that
you didn't show us.
> My question is simple: what the h... can I do? :-)
As far as finding the bug, you need to provide a complete,
self-contained test case.
As far as loading the schema, how about just removing the DEFAULT
clauses? "default null" is the default behavior anyway.
regards, tom lane
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: tgl@sss.pgh.pa.us, mariscal@javahispano.org
Subject: Re: Unrecognized node type
In-Reply-To: <1624.1088525897@sss.pgh.pa.us>
* 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