Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1he2at-0007to-0J for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Jun 2019 19:19:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1he2ar-000866-Cs for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Jun 2019 19:19:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1he2ar-00085y-4F for pgsql-hackers@lists.postgresql.org; Thu, 20 Jun 2019 19:19:33 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1he2ao-00037r-Te for pgsql-hackers@postgresql.org; Thu, 20 Jun 2019 19:19:32 +0000 Received: from [192.168.127.1] (port=37892 helo=caithnard.riddles.org.uk) by lungold.riddles.org.uk with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.88 (FreeBSD)) (envelope-from ) id 1he2aj-000JJW-Jv; Thu, 20 Jun 2019 19:19:25 +0000 Received: from [127.0.0.1] (port=57595 helo=caithnard.riddles.org.uk) by caithnard.riddles.org.uk with esmtp (Exim 4.89 (FreeBSD)) (envelope-from ) id 1he2ai-000Fyl-PL; Thu, 20 Jun 2019 19:19:24 +0000 From: Andrew Gierth To: Stephen Frost Cc: Robert Haas , Alvaro Herrera , Andres Freund , Tom Lane , Christoph Berg , PostgreSQL Hackers Subject: Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) In-Reply-To: <20190620182406.GD2480@tamriel.snowman.net> (Stephen Frost's message of "Thu, 20 Jun 2019 14:24:07 -0400") Message-ID: <87y31wytdl.fsf@news-spur.riddles.org.uk> References: <20190620161400.6wtuybv64ihnfy6d@alap3.anarazel.de> <20190620172838.GA21945@alvherre.pgsql> <20190620182406.GD2480@tamriel.snowman.net> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix) Date: Thu, 20 Jun 2019 20:19:24 +0100 MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk >>>>> "Stephen" == Stephen Frost writes: Stephen> In the situation that started this discussion, a change had Stephen> already been made and it was only later realized that it Stephen> caused a regression. Just to keep the facts straight: The regression was introduced by importing tzdb 2019a (in late April) into the previous round of point releases; the change in UTC behaviour was not mentioned in the commit and presumably didn't show up on anyone's radar until there were field complaints (which didn't reach our mailing lists until Jun 4 as far as I know). Tom's "fix" of backpatching 23bd3cec6 (which happened on Friday 14th) addressed only a subset of cases, as far as I know working only on Linux (the historical convention has always been for /etc/localtime to be a copy of a zonefile, not a symlink to one). I only decided to write (and if need be commit) my own followup fix after confirming that the bug was unfixed in a default FreeBSD install when set to UTC, and there was a good chance that a number of other less-popular platforms were affected too. Stephen> Piling on to that, the regression was entwined with other Stephen> important changes that we wanted to include in the release. I'm not sure what you're referring to here? -- Andrew (irc:RhodiumToad)