From: Tom Lane <tgl@sss.pgh.pa.us>
To: Daniel Gustafsson <daniel@yesql.se>
Cc: Joseph Rana <josephranamgr7@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Typo in the Timezone
Date: Fri, 23 May 2025 10:10:40 -0400
Message-ID: <2178211.1748009440@sss.pgh.pa.us> (raw)
In-Reply-To: <B21D889F-082F-4BAA-B82B-AF0E06A6B415@yesql.se>
References: <CAD7jd6V7rDzi44_mvTh0ePWuUQsbhf6rQ=HUZKR24V6_cOzDHw@mail.gmail.com>
<B21D889F-082F-4BAA-B82B-AF0E06A6B415@yesql.se>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, daniel@yesql.se, josephranamgr7@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: Typo in the Timezone
In-Reply-To: <2178211.1748009440@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox