Re: UCT (Re: pgsql: Update time zone data files to tzdata release2019a.) - Mailing list pgsql-hackers

From Andres Freund
Subject Re: UCT (Re: pgsql: Update time zone data files to tzdata release2019a.)
Date
Msg-id 20190604164457.772invck3lgxk75s@alap3.anarazel.de
Whole thread Raw
In response to Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.)  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

On 2019-06-04 17:20:42 +0100, Andrew Gierth wrote:
> fwiw on FreeBSD with no /etc/localtime and no TZ in the environment (and
> hence running on UTC), I get "UCT" on both 11.3 and HEAD.

That makes sense. As far as I can tell the reason that 12 sometimes ends
up with the proper timezone is that we shortcut the search by:

    /*
     * Try to avoid the brute-force search by seeing if we can recognize the
     * system's timezone setting directly.
     *
     * Currently we just check /etc/localtime; there are other conventions for
     * this, but that seems to be the only one used on enough platforms to be
     * worth troubling over.
     */
    if (check_system_link_file("/etc/localtime", &tt, resultbuf))
        return resultbuf;

which is actually a behaviour changing, rather than just an
optimization, when there's a lot of equivalently scoring timezones.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: UCT (Re: pgsql: Update time zone data files to tzdata release2019a.)
Next
From: Stephen Frost
Date:
Subject: Re: Sort support for macaddr8