Re: Allowed timezone values - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Allowed timezone values
Date
Msg-id 20051014.100747.74751758.ishii@sraoss.co.jp
Whole thread Raw
In response to Re: Allowed timezone values  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Allowed timezone values
Re: Allowed timezone values
List pgsql-hackers
> > Also, JST doesn't work anymore, but JST9 does.
> 
> JST9 is valid per the POSIX rules.  JST isn't listed as a zone name in
> the zic database, so it's not valid.  (Try "Japan" instead.)

Shall I add JST to our zic database? It's quite confusing that
"2005-10-14 12:00 JST" is allowed while ""SET TIME ZONE 'JST'" is not,
and "2005-10-14 12:00 Japan" is NOT allowed while ""SET TIME ZONE
'Japan'" is OK. Note that there's no daylight-saving time in Japan (at
this point).
--
SRA OSS, Inc. Japan
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: Robert Creager
Date:
Subject: Seeing context switch storm with 10/13 snapshot of 8.1beta3
Next
From: Bruce Momjian
Date:
Subject: Re: Allowed timezone values