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 1hgXjL-0001eq-0w for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Jun 2019 16:58:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hgXjI-0003IH-Gq for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Jun 2019 16:58:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hgXjI-0003IA-52 for pgsql-hackers@lists.postgresql.org; Thu, 27 Jun 2019 16:58:36 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hgXjE-0007Ol-Pu for pgsql-hackers@postgresql.org; Thu, 27 Jun 2019 16:58:33 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x5RGwLpj029937; Thu, 27 Jun 2019 12:58:22 -0400 From: Tom Lane To: Andrew Gierth cc: Thomas Munro , Robert Haas , Stephen Frost , Andres Freund , Christoph Berg , PostgreSQL Hackers Subject: Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) In-reply-to: <87y31oq9g6.fsf@news-spur.riddles.org.uk> 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> <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> <8736jwsdv2.fsf@news-spur.riddles.org.uk> <17148.1561568815@sss.pgh.pa.us> <87y31oq9g6.fsf@news-spur.riddles.org.uk> Comments: In-reply-to Andrew Gierth message dated "Wed, 26 Jun 2019 23:48:16 +0100" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <29935.1561654701.1@sss.pgh.pa.us> Date: Thu, 27 Jun 2019 12:58:21 -0400 Message-ID: <29936.1561654701@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Andrew Gierth writes: > "Tom" == Tom Lane writes: > Tom> In general, the point I'm trying to make is that our policy should > Tom> be "Ties are broken arbitrarily, and if you don't like the choice > Tom> that initdb makes, here's how to fix it". > Yes, you've repeated that point at some length, and I am not convinced. [ shrug... ] You haven't convinced me, either. By my count we each have about 0.5 other votes in favor of our positions, so barring more opinions there's no consensus here for the sort of behavioral change you suggest. However, not to let the perfect be the enemy of the good, it seems like nobody has spoken against the ideas of (a) installing negative preferences for the "localtime" and "posixrules" pseudo-zones, and (b) getting rid of our now-unnecessary special treatment for "Factory". How about we do that much and leave any more-extensive change for another day? regards, tom lane