On Mon Dec 16, 2024 at 8:57 PM CET, Tom Lane wrote:
Andreas Karlsson <andr...@proxel.se> writes:
On 12/13/24 12:33 AM, Tom Lane wrote:
I am not convinced this is an improvement. While this patch removes the
round-trip hazard it also makes it confusing to use the
timezone_abbreviations GUC since it can be overridden by IANA data based
on your current timezone. So you need to know all the, sometimes weird,
names for your current timezone. Seems unnecessarily hard to reason
about and wouldn't most people who use timezone_abbreviations rely on
the current behavior?
Presumably they're not that weird to the locals?
I am not sure what you mean by "people who use
timezone_abbreviations". I think that's about everyone --- it's
not like the default setting doesn't contain any abbreviations.
(If it didn't then we'd not have such a problem...)
Maybe changing the default value of timezone_abbreviations is a better
solution to the problem, or in addition to the proposed patch.
