Re: Typo in the Timezone

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>
Cc: Joseph Rana <josephranamgr7(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Typo in the Timezone
Date: 2025-05-23 14:10:40
Message-ID: 2178211.1748009440@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Daniel Gustafsson <daniel(at)yesql(dot)se> writes:
>> On 23 May 2025, at 11:40, Joseph Rana <josephranamgr7(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Masahiko Sawada 2025-05-23 17:31:54 Re: Logical replication 'invalid memory alloc request size 1585837200' after upgrading to 17.5
Previous Message Daniel Gustafsson 2025-05-23 10:38:21 Re: Typo in the Timezone