pg_dump bug

From: jose soares <jose(at)sferacarta(dot)com>
To: hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_dump bug
Date: 1999-11-19 11:32:04
Message-ID: 38353533.B8E39770@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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é

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-11-19 12:28:43 Re: [HACKERS] 7.0 status request
Previous Message Oleg Bartunov 1999-11-19 11:19:00 Re: [BUGS] Problems in 6.5.3 with Multi-Byte encoding