Re: Typo in the Timezone

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Daniel Gustafsson <daniel@yesql.se>
Cc: Joseph Rana <josephranamgr7@gmail.com>, pgsql-bugs@lists.postgresql.org
Date: 2025-05-23T14:10:40Z
Lists: 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 should be "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