"Hiroshi Saito" <[EMAIL PROTECTED]> 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)
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
