Re: [HACKERS] pg_dump bug

I confirm this bug for 6.5.3, Linux
Oleg

On Fri, 19 Nov 1999, jose soares wrote:

> Date: Fri, 19 Nov 1999 12:32:04 +0100
> From: jose soares <jose@sferacarta.com>
> To: hackers <pgsql-hackers@postgreSQL.org>
> Subject: [HACKERS] pg_dump bug
> 
> 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И
> 
> 
> 
> ************
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83