Re: Typo in the Timezone - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Typo in the Timezone
Date
Msg-id 2178211.1748009440@sss.pgh.pa.us
Whole thread Raw
In response to Re: Typo in the Timezone  (Daniel Gustafsson <daniel@yesql.se>)
List pgsql-bugs
Daniel Gustafsson <daniel@yesql.se> writes:
>> On 23 May 2025, at 11:40, Joseph Rana <josephranamgr7@gmail.com> wrote:
>> Hi i am a nepali developer and i saw a small typo here in the official supported timezone list. The correct spelling
shouldbe "Asia/Kathmandu" and not "Asia/katmandu". 

> We consume the timezone database without changes, any proposals for updates
> should be raised with the maintainers:
>     https://www.iana.org/time-zones

It looks to me like both spellings are accepted already:

regression=# select * from pg_timezone_names where name ilike 'asia/kat%';
      name      | abbrev | utc_offset | is_dst
----------------+--------+------------+--------
 Asia/Kathmandu | +0545  | 05:45:00   | f
 Asia/Katmandu  | +0545  | 05:45:00   | f
(2 rows)

            regards, tom lane



pgsql-bugs by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Typo in the Timezone
Next
From: Laurenz Albe
Date:
Subject: Re: BUG #18936: Trigger enable users to modify the tables which hedoesn't have privilege