Skip site navigation (1) Skip section navigation (2)

Re: BUG #1232: Singapore Timezone missing

From: "John R Pierce" <pierce(at)hogranch(dot)com>
To: "\"PostgreSQL Bugs List\"" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1232: Singapore Timezone missing
Date: 2004-08-26 00:32:21
Message-ID: 0e9a01c48b04$268be950$ (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
> The following bug has been logged online:
> The timezone designation SGT is not recognized on inserts to "timestamp 
> with
> time zone" fields.

fyi, I am on this list, if anyone wants to tell me I'm way off base here or 
whatever :)

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 
America ;-/


(btw, thats the trimmed output of...
    $ grep ^CN /usr/share/zoneinfo/
    $ cd /usr/share/zoneinfo; /usr/sbin/zdump Asia/*

In response to


pgsql-bugs by date

Next:From: Stephan SzaboDate: 2004-08-26 01:23:44
Subject: Re: BUG #1231: Probelm with transactions in stored code.
Previous:From: Sean MurphyDate: 2004-08-25 22:52:52
Subject: pgsql 8 beta - Service fails... problem found

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group