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 1mmYaY-0000M1-3g for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Nov 2021 09:47:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mmYaV-00038A-Tg for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Nov 2021 09:47:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mmYaV-000381-KV for pgsql-hackers@lists.postgresql.org; Mon, 15 Nov 2021 09:47:43 +0000 Received: from smtp.outgoing.loopia.se ([93.188.3.37]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mmYaT-0002yp-UX for pgsql-hackers@postgresql.org; Mon, 15 Nov 2021 09:47:43 +0000 Received: from s807.loopia.se (localhost [127.0.0.1]) by s807.loopia.se (Postfix) with ESMTP id 9F9DE2EB8CD4 for ; Mon, 15 Nov 2021 10:47:23 +0100 (CET) Received: from s934.loopia.se (unknown [172.22.191.6]) by s807.loopia.se (Postfix) with ESMTP id 8D60E2E2D6C0; Mon, 15 Nov 2021 10:47:23 +0100 (CET) Received: from s476.loopia.se (unknown [172.22.191.5]) by s934.loopia.se (Postfix) with ESMTP id 854C17DCAA0; Mon, 15 Nov 2021 10:47:23 +0100 (CET) X-Virus-Scanned: amavisd-new at amavis.loopia.se X-Spam-Flag: NO X-Spam-Score: -1 X-Spam-Level: X-Spam-Status: No, score=-1 tagged_above=-999 required=6.2 tests=[ALL_TRUSTED=-1] autolearn=disabled Received: from s934.loopia.se ([172.22.191.5]) by s476.loopia.se (s476.loopia.se [172.22.190.16]) (amavisd-new, port 10024) with LMTP id nmqFEmo_BrrJ; Mon, 15 Nov 2021 10:47:23 +0100 (CET) X-Loopia-Auth: user X-Loopia-User: daniel@yesql.se X-Loopia-Originating-IP: 89.255.232.193 Received: from [192.168.72.144] (customer-89-255-232-193.stosn.net [89.255.232.193]) (Authenticated sender: daniel@yesql.se) by s934.loopia.se (Postfix) with ESMTPSA id DA3B67DC5FC; Mon, 15 Nov 2021 10:47:22 +0100 (CET) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Subject: Re: WIP: System Versioned Temporal Table From: Daniel Gustafsson In-Reply-To: Date: Mon, 15 Nov 2021 10:47:22 +0100 Cc: Corey Huinker , Jaime Casanova , vignesh C , Ibrar Ahmed , Surafel Temesgen , Vik Fearing , =?utf-8?Q?R=C3=A9mi_Lapeyre?= , Ryan Lambert , Masahiko Sawada , Michael Paquier , Eli Marmor , David Steele , PostgreSQL-development , Georgios , Li Japin Content-Transfer-Encoding: 7bit Message-Id: <335B3EDC-ACCD-4312-9783-C2F8FB083D80@yesql.se> References: <7990518c-3dd3-4f30-c5e1-e094f6126e9a@postgresfriends.org> <358FBCC9-F788-4ECE-8104-6825F65D1C56@hotmail.com> <20210910183023.GB5852@ahch-to> To: Simon Riggs X-Mailer: Apple Mail (2.3608.120.23.2.7) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 19 Sep 2021, at 20:32, Simon Riggs wrote: > My preferred approach would be to do this "for free" in the table > access method, but we're a long way from this in terms of actual > implementation. When Corey suggested earlier that we just put the > syntax in there, this was the direction I was thinking. > > After waiting a day since I wrote the above, I think we should go with > (2) as Corey suggests, at least for now, and we can always add (3) > later. This patch no longer applies, are there plans on implementing the approaches discussed above, or should we close this entry and open a new one when a freshly baked pathed is ready? -- Daniel Gustafsson https://vmware.com/