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

I assume this is not fixed yet, right?

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

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...
>
> 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@postgresql.org)
>

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