Re: Should AT TIME ZONE be volatile? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Should AT TIME ZONE be volatile?
Date
Msg-id 1546724.1636642372@sss.pgh.pa.us
Whole thread Raw
In response to Re: Should AT TIME ZONE be volatile?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Should AT TIME ZONE be volatile?
Re: Should AT TIME ZONE be volatile?
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> I'm not really convinced that ICU is better, either. I think it's more
> that it isn't used as much.

Well, at least ICU has a notion of attaching versions to collations.
How mindful they are of bumping the version number when necessary
remains to be seen.  But the POSIX locale APIs don't even offer the
opportunity to get it right.

> I don't have any constructive proposal for what to do about any of
> this. It sure is frustrating, though.

Yup.  If we had reliable ways to detect changes in this sort of
environment-supplied data, maybe we could do something about it
(a la the work that's been happening on attaching collation versions
to indexes).  But personally I can't summon the motivation to work
on that, when ICU is the *only* such infrastructure that offers
readily program-readable versioning.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Should AT TIME ZONE be volatile?
Next
From: "Bossart, Nathan"
Date:
Subject: Re: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display