> The following bug has been logged online:
> The timezone designation SGT is not recognized on inserts to "timestamp
> time zone" fields.
fyi, I am on this list, if anyone wants to tell me I'm way off base here or
something tells me I'm going to hit this problem again when our app gets
deployed at our plants in thailand and china and indonesia (and, no, I don't
yet know what time zone codes they use, I'm trying to figure out how to dump
the linux timezone files)
ok, on my redhat enterprise linux server, /usr/share/zoneinfo/Asia/Bangkok
uses ICT which is defined.
however, mainland china, ugh.
CN Asia/Shanghai east China - Beijing, Guangdong, Shanghai, etc.
CN Asia/Harbin Heilongjiang
CN Asia/Chongqing central China - Gansu, Guizhou, Sichuan, Yunnan, etc.
CN Asia/Urumqi Tibet & most of Xinjiang Uyghur
CN Asia/Kashgar southwest Xinjiang Uyghur
Asia/Shanghai Thu Aug 26 08:29:36 2004 CST
Asia/Harbin Thu Aug 26 08:29:36 2004 CST
Asia/Chongqing Thu Aug 26 08:29:36 2004 CST
Asia/Urumqi Thu Aug 26 08:29:36 2004 CST
Asia/Kashgar Thu Aug 26 08:29:36 2004 CST
so all of china uses CST, which is *NOT* CST as we know it here in North
(btw, thats the trimmed output of...
$ grep ^CN /usr/share/zoneinfo/zone.tab
$ cd /usr/share/zoneinfo; /usr/sbin/zdump Asia/*
In response to
pgsql-bugs by date
|Next:||From: Stephan Szabo||Date: 2004-08-26 01:23:44|
|Subject: Re: BUG #1231: Probelm with transactions in stored code.|
|Previous:||From: Sean Murphy||Date: 2004-08-25 22:52:52|
|Subject: pgsql 8 beta - Service fails... problem found|