Re: Dump/Restore of cvs regression database gives invalid timestamp syntax error - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: Dump/Restore of cvs regression database gives invalid timestamp syntax error
Date
Msg-id 20040624170218.GD2761@dcc.uchile.cl
Whole thread Raw
In response to Re: Dump/Restore of cvs regression database gives invalid timestamp syntax error  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Dump/Restore of cvs regression database gives invalid timestamp
List pgsql-bugs
On Thu, Jun 24, 2004 at 11:38:59AM -0400, Tom Lane wrote:
> Kris Jurka <books@ejurka.com> writes:
> > ERROR:  invalid input syntax for type timestamp with time zone:
> > "0097-02-16 17:32:01 BC-08"
>
> Thanks for catching this.  It never came up before because we never
> would try to output timezone info for a BC date...

Maybe it's a good idea to routinely test regression dump/restore/dump
(and compare both dumps).  This could also mean trying to keep the most
objects in it so features tested for regression are also tested for
recoverability ...

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El número de instalaciones de UNIX se ha elevado a 10,
y se espera que este número aumente" (UPM, 1972)

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dump/Restore of cvs regression database gives invalid timestamp syntax error
Next
From: Sergei Koveshnikov
Date:
Subject: Trouble with C-Language Functions