Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Dump/Restore of cvs regression database gives invalid timestamp syntax error
Date
Msg-id 14588.1088091539@sss.pgh.pa.us
Whole thread Raw
In response to Dump/Restore of cvs regression database gives invalid timestamp syntax error  (Kris Jurka <books@ejurka.com>)
Responses Re: Dump/Restore of cvs regression database gives invalid timestamp syntax error
Re: Dump/Restore of cvs regression database gives invalid timestamp
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: "Hebert, Caroline"
Date:
Subject: ECPG doesn't return the correct length for an empty
Next
From: Alvaro Herrera
Date:
Subject: Re: Dump/Restore of cvs regression database gives invalid timestamp syntax error