pg_dump bug
Jose Soares <jose@sferacarta.com>
From: jose soares <jose@sferacarta.com>
To: hackers <pgsql-hackers@postgresql.org>
Date: 1999-11-19T11:32:04Z
Lists: pgsql-hackers
Hi,
I think I found a bug in pg_dump:
I created a table like:
CREATE TABLE ut (
Azienda CHAR(16) NOT NULL,
ragione_sociale VARCHAR(45) NOT NULL,
indirizzo CHAR(40),
inizio_attivita DATE DEFAULT CURRENT_DATE,
fine_attivita DATE
);
and pg_dump modify the structure table as:
\connect - postgres
CREATE TABLE "ut" (
"azienda" character(16) NOT NULL,
"ragione_sociale" character varying(45) NOT NULL,
"indirizzo" character(40),
"inizio_attivita" date DEFAULT date( 'current'::datetime + '0
sec') NOT NULL,
"fine_attivita" date);
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
If I try to recreate the table I have this:
ERROR: parser: parse error at or near "'"
Any ideas ?
José