Thread

pg_dump bug

Jose Soares <jose@sferacarta.com> — 1999-11-19T11:32:04Z

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é