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
Subject: Re: Typo in the Timezone
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>
Comments: In-reply-to Daniel Gustafsson <daniel@yesql.se>
	message dated "Fri, 23 May 2025 12:38:21 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2178210.1748009440.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 23 May 2025 10:10:40 -0400
Message-ID: <2178211.1748009440@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2178211.1748009440%40sss.pgh.pa.us>
Precedence: bulk

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" a=
nd not "Asia/katmandu".

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

It looks to me like both spellings are accepted already:

regression=3D# 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