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

I assume this is not fixed yet, right?

---------------------------------------------------------------------------

Tom Lane wrote:
> Kris Jurka <books(at)ejurka(dot)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...
>
> We could make it output either of
> 0097-02-16 17:32:01 BC -08
> 0097-02-16 17:32:01-08 BC
> as the input parser will take either. I'm kinda leaning to the latter;
> any contrary opinions?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073