Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kImrT-00022L-1k for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Sep 2020 05:53:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kImrR-0003Sm-HD for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Sep 2020 05:53:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kImrR-0003Sf-AN for pgsql-hackers@lists.postgresql.org; Thu, 17 Sep 2020 05:53:37 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kImrP-0005xE-49 for pgsql-hackers@postgresql.org; Thu, 17 Sep 2020 05:53:36 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 4CBC2864; Thu, 17 Sep 2020 01:53:33 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Thu, 17 Sep 2020 01:53:33 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=DMm+tvKaULEKprNHDbImQ6S1fAO r7sSTmWapIAt0gbM=; b=VsqUb6cD3VSDquWUfRp97nSdvdRa1FSHANZ4jW3vKew S9ouxBUAfoYSHbXMizGyTyNOZCySS7ZL/BTzSaRDVcsKO/e086TWCTWbsppvnub2 KAJRNKDzckz1tsHiunCjlJUctUXkZU2YMpd+lPIl0nbnk6+8W9Fw/jVuqGW4PMSV Sj6MR/IuMJ0d13D/060IaCLxS1hqa67eFG/zNC05XcLHsOj+VQsx6n1wmgTsRH0/ tY8nA+lcqDHK6g9TiHDqkwQoL9J8H5Hnay6MVrbMxlMmFTHF5N7qJq6ereoCvuOS rXL1bnNX8MU8xwdNZGqGmJQPYeQZ8TF7ft6SbjqXE4g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=DMm+tv KaULEKprNHDbImQ6S1fAOr7sSTmWapIAt0gbM=; b=JizTtz9z+r6Wm/6X6uimli y+UOEpBuUgE42ZHthciy7k9owScRHI9772Zpow2K1KgneL8Lq+ddo2CEOgMbv32m 2zG5vGTiEhS3D37i1rnjBsch6iXVJUvYKnOu9VrdGrcRQhGL/v/BwJ1zViEJNBoz MqqOJTo5HKiKWKEx7O0LSbIO5HEnv/kMNjGhkCFyAp38h+7UbroI+zc11NKVe0GB eu71ExYTkEseXY3iI5lk2mzjnhcMz/QcdmX0nPn3otiVDm7yASxJOBc+QkQy2kxw l9Omd8ml9O1iyeizGkOn2KKV5Hh0TAfSC+zN3rbfzqbQmIrOn6JKBKlEFiq6Zz9A == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrtdefgdellecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepvdegudeuhfdtueeltedtveejheeh ieevueeigeelteegleejleeiueeiheegvefhnecukfhppeduuddurddutddvrddukedtrd dukeehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhep mhhitghhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 58FFA3064610; Thu, 17 Sep 2020 01:53:30 -0400 (EDT) Date: Thu, 17 Sep 2020 14:53:27 +0900 From: Michael Paquier To: Peter Eisentraut Cc: Tom Lane , Pavel Stehule , pgsql-hackers , Thomas Munro , Petr Fedorov Subject: Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Message-ID: <20200917055327.GU2873@paquier.xyz> References: <1c2262e2-6812-7baa-cbdd-63039db12952@phystech.edu> <1551357.1599435992@sss.pgh.pa.us> <097a4242-0748-98e3-06ab-ded1d366cd76@2ndquadrant.com> <1893468.1599658711@sss.pgh.pa.us> <38fc499a-ae52-efb6-aad6-82f812d6782d@2ndquadrant.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Y2illNFYgwJwqOHD" Content-Disposition: inline In-Reply-To: <38fc499a-ae52-efb6-aad6-82f812d6782d@2ndquadrant.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Y2illNFYgwJwqOHD Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Sep 09, 2020 at 08:47:36PM +0200, Peter Eisentraut wrote: > ok done As far as I can see, patches 0001 and 0002 have been already applied, but not 0003. Could you send a rebase to allow the CF bot to run, at least? -- Michael --Y2illNFYgwJwqOHD Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl9i+dcACgkQnvQgOdby QH1Heg/+MuWhYN/6D/DzKqgQfM/0qcgi+DAJKkJn47QRxNcPMVVBvwy4xQzSsRjI Qf4PJ2Ui9mLdgtbKbpoMvSlnVb+u/1/A+oujMOjb7DMXDV4HMtCxFuwYTDMbzqlD Csv03kAwok0DnutpKsowJ7QZ9uJQ6tLYUCmBdRthpIOLAu63XkA400RGvaCTYW34 jgm078n0Q8/3ZxcbQ6hg5lGbxnz735iEMGHbcLgSme760devS2igdaiAv8O5arCw 1DcdTQOPI3Bnlt+30vLIS29/d1FCtMLxd2wZe0jZdPrTOgf405TDi7Mc2E0vqTU1 BkorHWGRZZSrs6gAv13Gv37ChczIMXvF8pGobsnw/nN13Bp9+mgG20nAm694qo4z 7OPtXQPmUBu2bc5YuakgjDYNOQmTysB8o2pSrKd6VdOGVtjkrSAPJdTRD/Rv4Yls +xbSjiRa1Xxc0lMdMWt1sP4dOToH0AePQ/8tcXTpmYzY0ciQa9IPu0RztlXUIHwG PSG3HzavOoqm0zmKe5LE7V3ISYm6sDukVj3kMUqSapTKcjLzxXdW2VaR0Qf3fY7j iaZOqhCksQ/Fhc4abMYy1arnxl9CSmmU0KB1Yo0aYZ4ZQ4luJWrdJoCufieAlUiK 74QWy7K80MioP3QhFzqDj5Qen7WycjgEfK8QZ/jYiWNglF2/eg8= =4dn6 -----END PGP SIGNATURE----- --Y2illNFYgwJwqOHD--