Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cfofT-0001LI-Gu for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Feb 2017 14:10:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cfofS-0000Wz-VM for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Feb 2017 14:10:19 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cfofR-0000VA-18 for pgsql-hackers@postgresql.org; Mon, 20 Feb 2017 14:10:17 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cfofP-0003S3-6O for pgsql-hackers@postgresql.org; Mon, 20 Feb 2017 14:10:16 +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 v1KEABsk031710; Mon, 20 Feb 2017 09:10:11 -0500 From: Tom Lane To: Petr Jelinek cc: Andres Freund , Robert Haas , "pgsql-hackers@postgresql.org" Subject: Re: Replication vs. float timestamps is a disaster In-reply-to: <3bd3c551-8b23-45c8-27a2-97b5a922b130@2ndquadrant.com> References: <26788.1487455319@sss.pgh.pa.us> <1691.1487519369@sss.pgh.pa.us> <20170220070311.gscn7ppqbwlgdpjq@alap3.anarazel.de> <3bd3c551-8b23-45c8-27a2-97b5a922b130@2ndquadrant.com> Comments: In-reply-to Petr Jelinek message dated "Mon, 20 Feb 2017 11:58:12 +0100" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <31708.1487599811.1@sss.pgh.pa.us> Date: Mon, 20 Feb 2017 09:10:11 -0500 Message-ID: <31709.1487599811@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Petr Jelinek writes: > It's definitely not hard, we already have > IntegerTimestampToTimestampTz() which does the opposite conversion anyway. It's not the functions that are hard, it's making sure that you have used them in the correct places, and declared relevant variables with the appropriate types. Evidence on the ground is that that is very hard; I have little faith that we'll get it right without compiler support. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers