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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Dump/Restore of cvs regression database gives invalid timestamp syntax error
Дата
Msg-id 14588.1088091539@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Dump/Restore of cvs regression database gives invalid timestamp syntax error  (Kris Jurka <books@ejurka.com>)
Ответы Re: Dump/Restore of cvs regression database gives invalid timestamp syntax error
Re: Dump/Restore of cvs regression database gives invalid timestamp
Список pgsql-bugs
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 по дате отправления:

Предыдущее
От: "Hebert, Caroline"
Дата:
Сообщение: ECPG doesn't return the correct length for an empty
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Dump/Restore of cvs regression database gives invalid timestamp syntax error