"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