invalid input syntax for type timestamp.

Поиск
Список
Период
Сортировка
От Hiroshi Saito
Тема invalid input syntax for type timestamp.
Дата
Msg-id 05b801c72015$13f7afb0$3043040a@wiseknot.local
обсуждение исходный текст
Ответы Re: invalid input syntax for type timestamp.  (Martijn van Oosterhout <kleptog@svana.org>)
Re: invalid input syntax for type timestamp.  (Christopher Browne <cbbrowne@ca.afilias.info>)
Список pgsql-hackers
Hi.

I was doing the field test of Slony-I 1.2.2 release now.
However, I encounter the problem of timestamp.:-(
Was anyone recognizing this problem?

Ver 8.1.5
saito=# select 'Fri Dec 15 14:26:05.502000 2006 JST'::timestamp;       timestamp
-------------------------2006-12-15 14:26:05.502

Ver 8.2.0
saito=# select 'Fri Dec 15 14:26:05.502000 2006 JST'::timestamp;
ERROR:  invalid input syntax for type timestamp: "Fri Dec 15 14:26:05.502000 2006 JST"

saito=# select 'Fri Dec 15 14:26:05.502000 2006 GMT'::timestamp;       timestamp
-------------------------2006-12-15 14:26:05.502


Umm, I might refrain from release for 8.2 of Slony-I for this problem. 

Regards,
Hiroshi Saito




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Operator class group proposal
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: unixware and --with-ldap