From: Tom Lane <tgl@sss.pgh.pa.us>
To: gkchinna.oracle@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18455: DST information is flagged wrongly
Date: Thu, 02 May 2024 12:12:22 -0400
Message-ID: <2235698.1714666342@sss.pgh.pa.us> (raw)
In-Reply-To: <2219450.1714662503@sss.pgh.pa.us>
References: <18455-1f7c5337666bbd1a@postgresql.org>
<2219450.1714662503@sss.pgh.pa.us>
I wrote:
> I suspect this may be down to different options being used in
> the "zic" run that builds the zone data files, but haven't
> had time to look closer than that.
Ah ... having now refreshed my memory, the answer is that RHEL
and Apple are distributing "rearguard" tzdata files, whereas
ours are built with the main ("vanguard") data model. The
relevant difference is that the main model has the Irish rules as
being standard time in summer and negative 1 hour DST in winter.
The "rearguard" data is for parsers that cannot cope with the
idea of negative DST, so it has +1 DST in summer and a different
base GMT offset. It's alleged that this summer-time-is-standard
concept more nearly matches the way the Irish law is written;
the tzdb commentary includes
# (Note that the time in the Republic of Ireland since 1968 has been defined
# in terms of standard time being GMT+1 with a period of winter time when it
# is GMT, rather than standard time being GMT with a period of summer time
# being GMT+1.)
In short: so far as the upstream tzdb project is concerned,
we're doing the right thing, and I feel no need to change it.
If you want to match the behavior of some other software,
point --with-system-tzdata at the same zoneinfo tree that
that other software is using.
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, gkchinna.oracle@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18455: DST information is flagged wrongly
In-Reply-To: <2235698.1714666342@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