Re: invalid input syntax for type timestamp.

"Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp> writes:
> 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.

This seems like the well-known issue that if there is some timezone
{unknownzone} that PostgreSQL is unaware of, you oughtn't operate
either Slony-I or PostgreSQL with TZ={unknownzone} or
PGTZ={unknownzone}.

JST strikes me as being a timezone that I'd be a tad surprised for
PostgreSQL NOT to recognize. But that should represent a PostgreSQL
regression problem, not a problem with Slony-I...
--
let name="cbbrowne" and tld="ca.afilias.info" in String.concat "@" [name;tld];;
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)