Re: Dump/Restore of cvs regression database gives invalid timestamp - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: Dump/Restore of cvs regression database gives invalid timestamp
Date
Msg-id 200407110314.i6B3EPf25237@candle.pha.pa.us
Whole thread Raw
In response to Re: Dump/Restore of cvs regression database gives invalid timestamp syntax error  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Dump/Restore of cvs regression database gives invalid timestamp  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1189: unbounded string copy in postmaster
Next
From: Tom Lane
Date:
Subject: Re: Dump/Restore of cvs regression database gives invalid timestamp