Re: [HACKERS] pg_dump bug - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] pg_dump bug
Date
Msg-id 199911191555.KAA17217@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] pg_dump bug  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
[Charset koi8-r unsupported, filtering to ASCII...]
> I confirm this bug for 6.5.3, Linux

OK, seems like it is only 6.5.* tree and not development tree, which
means development has a fix that was too risky for 6.5.*.  Seems user
will have to wait for 7.0.

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


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


pgsql-hackers by date:

Previous
From: "J. Roeleveld"
Date:
Subject: Re: [HACKERS] Mandrake Postgres RPMs
Next
From: Lamar Owen
Date:
Subject: Re: Mandrake Postgres RPMs