invalid input syntax for type timestamp. - Mailing list pgsql-hackers

From Hiroshi Saito
Subject invalid input syntax for type timestamp.
Date
Msg-id 05b801c72015$13f7afb0$3043040a@wiseknot.local
Whole thread Raw
Responses Re: invalid input syntax for type timestamp.
Re: invalid input syntax for type timestamp.
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Operator class group proposal
Next
From: "Albe Laurenz"
Date:
Subject: Re: unixware and --with-ldap