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

Bruce Momjian <pgman@candle.pha.pa.us> 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

> ---------------------------------------------------------------------------

> 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

> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?

>                http://www.postgresql.org/docs/faqs/FAQ.html