pg.ddx.io pgsql-committers@postgresql.org mailing list archive help / color / mirror / Atom feed From: Shay Rojansky <roji@roji.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Thomas Munro <thomas.munro@gmail.com>
Cc: Andrew Gierth <andrew@tao11.riddles.org.uk>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Stephen Frost <sfrost@snowman.net>
Cc: Andres Freund <andres@anarazel.de>
Cc: Christoph Berg <myon@debian.org>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.)
Date: Thu, 1 Aug 2019 11:09:54 +0200
Message-ID: <CADT4RqBkkWEXr7saiFhwSptuYBAEU_e_XZxRD3o7GCSuk++Y9A@mail.gmail.com> (raw )
In-Reply-To: <3961.1564086915@sss.pgh.pa.us >
References: <24452.1560285699@sss.pgh.pa.us >
<20190614095546.GA15107@msg.df7cb.de >
<26948.1560517875@sss.pgh.pa.us >
<87ef3w3u8a.fsf@news-spur.riddles.org.uk >
<7114.1560539536@sss.pgh.pa.us >
<875zp74zpf.fsf@news-spur.riddles.org.uk >
<871rzv4yes.fsf@news-spur.riddles.org.uk >
<20190617173943.z3ttxqenbcwrlag4@alap3.anarazel.de >
<20190617183458.GG2480@tamriel.snowman.net >
<20190617183828.hj7ci362zbxd4nax@alap3.anarazel.de >
<20190617184053.GI2480@tamriel.snowman.net >
<CA+TgmoYF00U3Pbkh4mXhXr1NN6pKFM278KmXRS35HDuHgNcMFw@mail.gmail.com >
<25314.1560980148@sss.pgh.pa.us >
<27991.1560984458@sss.pgh.pa.us >
<877e9h18df.fsf@news-spur.riddles.org.uk >
<2643.1561508327@sss.pgh.pa.us >
<877e98syi5.fsf@news-spur.riddles.org.uk >
<CA+hUKGLZN3XHqZPN08itV4W-Nu3ndZ9zKJGSvzoWLm6AU9vz-g@mail.gmail.com >
<8736jwsdv2.fsf@news-spur.riddles.org.uk >
<17148.1561568815@sss.pgh.pa.us >
<87y31oq9g6.fsf@news-spur.riddles.org.uk >
<CA+hUKGJniUoFuC8vPJBKbMWNwvZo_wGQ8gVAZFCS068Rei9dzQ@mail.gmail.com >
<3961.1564086915@sss.pgh.pa.us >
> I'm not sure we're any closer to a meeting of the minds on whether
> consulting zone[1970].tab is a good thing to do, but we got an actual
> user complaint[1] about how "localtime" should not be a preferred
> spelling. So I want to go ahead and insert the discussed anti-preference
> against "localtime" and "posixrules", as per 0001 below. If we do do
> something with zone[1970].tab, we'd still need these special rules,
> so I don't think this is blocking anything.
Just want to stress this point from a PostgreSQL driver maintainer
perspective (see here[1] for the full details). Having "localtime" as the
PostgreSQL timezone basically means that the timezone is completely opaque
from a client point of view - there is no way for clients to know what
actual timezone the server is in, and react to that. This is a limiting
factor in client development, I hope a consensus on this specific point can
be reached.
[1]
https://www.postgresql.org/message-id/CADT4RqCCnj6FKLisvT8tTPfTP4azPhhDFJqDF1JfBbOH5w4oyQ@mail.gmail...
view thread (74+ messages) latest in thread
Message-ID: <CADT4RqBkkWEXr7saiFhwSptuYBAEU_e_XZxRD3o7GCSuk++Y9A@mail.gmail.com>
Permalink: ../CADT4RqBkkWEXr7saiFhwSptuYBAEU_e_XZxRD3o7GCSuk++Y9A@mail.gmail.com/
Also on: postgresql.org/message-id/CADT4RqBkkWEXr7saiFhwSptuYBAEU_e_XZxRD3o7GCSuk++Y9A@mail.gmail.com
copy link · copy postgr.es
reply 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-committers@postgresql.org
Cc: roji@roji.org, tgl@sss.pgh.pa.us, thomas.munro@gmail.com, andrew@tao11.riddles.org.uk, robertmhaas@gmail.com, sfrost@snowman.net, andres@anarazel.de, myon@debian.org, pgsql-hackers@postgresql.org
Subject: Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.)
In-Reply-To: <CADT4RqBkkWEXr7saiFhwSptuYBAEU_e_XZxRD3o7GCSuk++Y9A@mail.gmail.com>
* 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