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

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(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

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

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