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é
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 |