Re: Allowed timezone values

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgman(at)candle(dot)pha(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Allowed timezone values
Date: 2005-10-14 01:07:47
Message-ID: 20051014.100747.74751758.ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-10-14 01:21:11 Re: Allowed timezone values
Previous Message Robert Creager 2005-10-14 00:12:43 Seeing context switch storm with 10/13 snapshot of 8.1beta3