Re: [BUGS] Dump/Restore of cvs regression database gives invalid timestamp syntax error

2004-07-11 Thread Alvaro Herrera
On Sun, Jul 11, 2004 at 09:02:06AM -0400, Bruce Momjian wrote: > Tom just fixed this in CVS. This particular problem, yes, but maybe we want to detect early this sort of problems in the future. That's why I think a dump/restore/dump and compare both dumps could be a good test. > Alvaro Herrera

Re: [BUGS] Dump/Restore of cvs regression database gives invalid timestamp

2004-07-11 Thread Bruce Momjian
Tom just fixed this in CVS. --- Alvaro Herrera wrote: > On Thu, Jun 24, 2004 at 11:38:59AM -0400, Tom Lane wrote: > > Kris Jurka <[EMAIL PROTECTED]> writes: > > > ERROR: invalid input syntax for type timestamp with time zon

Re: [BUGS] Dump/Restore of cvs regression database gives invalid timestamp

2004-07-10 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I assume this is not fixed yet, right? It is not fixed, but given the lack of objections I'll go ahead and fix it as I proposed. regards, tom lane > --- >

Re: [BUGS] Dump/Restore of cvs regression database gives invalid timestamp

2004-07-10 Thread Bruce Momjian
I assume this is not fixed yet, right? --- Tom Lane wrote: > Kris Jurka <[EMAIL PROTECTED]> writes: > > ERROR: invalid input syntax for type timestamp with time zone: > > "0097-02-16 17:32:01 BC-08" > > Thanks for catchin

Re: [BUGS] Dump/Restore of cvs regression database gives invalid timestamp syntax error

2004-06-24 Thread Alvaro Herrera
On Thu, Jun 24, 2004 at 11:38:59AM -0400, Tom Lane wrote: > Kris Jurka <[EMAIL PROTECTED]> 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 time

Re: [BUGS] Dump/Restore of cvs regression database gives invalid timestamp syntax error

2004-06-24 Thread Tom Lane
Kris Jurka <[EMAIL PROTECTED]> 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... We could make it output either of

[BUGS] Dump/Restore of cvs regression database gives invalid timestamp syntax error

2004-06-24 Thread Kris Jurka
Dumping and restoring the regression database in cvs tip gives the following error upon restore: ERROR: invalid input syntax for type timestamp with time zone: "0097-02-16 17:32:01 BC-08" CONTEXT: COPY timestamptz_tbl, line 42, column d1: "0097-02-16 17:32:01 BC-08" Kris Jurka