Re: [HACKERS] pg_dump bugu

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> 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);
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Strange, but the query looks fine, and creates fine here in the current
sources.  We had a quoting bug in defaults at some point.  What version
are you using?

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026