Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tASVz-00Fqz5-MP for pgsql-general@arkaria.postgresql.org; Mon, 11 Nov 2024 11:23:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tASVv-00DX5w-Ij for pgsql-general@arkaria.postgresql.org; Mon, 11 Nov 2024 11:23:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tASVu-00DX1a-U8 for pgsql-general@lists.postgresql.org; Mon, 11 Nov 2024 11:23:23 +0000 Received: from mail-db8eur05olkn2052.outbound.protection.outlook.com ([40.92.89.52] helo=EUR05-DB8-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tASVo-001Ig1-Ox for pgsql-general@lists.postgresql.org; Mon, 11 Nov 2024 11:23:22 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=nsT1yLqWYmWKRCodb2CI5EJx4Dr2MNQM2UmkP0swlfNXidMX+9HCBndNKRihVGyU1v0KByWPM+7k3tUzOhRMJA58t50zh04m4gb0+SN4ZcHdDVTWWIULscdnxkoxCZNP3xk9dKdK4/j33bHEenXTIU+QlwmAoGiOSM80l502T1HHEOmsj1C1psgzoYS18TlUGjJPGL4DeYZDoBS2DsS6ltA1wyNUjwNUfE5E+wLIBKUB0ODMPuNyD8O2rPFsaz2NHoFkNLJtIQ3Dnj70YBgwgSiJXXQOIU6vKGBP4aJZXYkMpO7geAsjYEFbl/KEZGiHx6H9oBSOCdMPBiFcAia8ZA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=lwW4ahSse3S7bu3s3cWaiSoPcslnuNtpsuPf/4qo/b4=; b=Tqc5LNypanzO6fr5nntpd3kifPhrZJK6T54NVkddr4E4qexmow/Ey3lOpNp3wKb6NTOAZSXZVd0brYzdQDkZMRRuLcu5eUSMW9oq9cDh8Tx106WcxiebicQwi9ogDVkVypXm6YWWcaAjH8U+xChzhZSDsyaqDNby18Odyj91HN1VgEGbYzddm3FaQP5eMv46F6Iby3Qi2L7r+chBE6GOBbIHL0k6xnfxvqujbE0A+aHj23eOYEu8NaOjfC4z6R0t925rbSv+bh3f6ngAgw7TC1PMV1yOQjrXURtXPF3kru++fSHSQ1i63snYivt40ny1jRiBdw1w6fHTAnNTtPSD4w== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=HOTMAIL.CO.UK; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=lwW4ahSse3S7bu3s3cWaiSoPcslnuNtpsuPf/4qo/b4=; b=qLmlhmf6+Fa0hiod0Lx1KitveoZIoAbRY2jbMNdy0/mPZoN/8CMLEg0TQFROhp/TO2lH+FQuwG+bfUb0lslusCoG/HnddHEUT0kffx0BBLQ/x88zKfLwlNQtNOU9CqaM2vT/pqoBW4bjmgdbF8AFC4DrXRPLEYN2WlTsHxoGncLBQO4olehYYY5BCrfONUd58+SGIgi/tEFL5zbXRifp9KCJCEN3HdZTNqVpqb6Fi1Y/bvXaZzO6c8Nu1BWaZ7t0OrhhhGEM2XItqQuU5asTdC2oN9V0suGAkUZLODUr6vBxVxS3pVUXeJ3abiuM5wZngRVtKWQB+mNVlqEDcsWztA== Received: from DB9P194MB1825.EURP194.PROD.OUTLOOK.COM (2603:10a6:10:394::11) by DB8P194MB0728.EURP194.PROD.OUTLOOK.COM (2603:10a6:10:160::23) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8137.27; Mon, 11 Nov 2024 11:23:11 +0000 Received: from DB9P194MB1825.EURP194.PROD.OUTLOOK.COM ([fe80::18fe:e46a:6e92:f66d]) by DB9P194MB1825.EURP194.PROD.OUTLOOK.COM ([fe80::18fe:e46a:6e92:f66d%4]) with mapi id 15.20.8137.019; Mon, 11 Nov 2024 11:23:10 +0000 From: David Lynam To: "pgsql-general@lists.postgresql.org" Subject: Question About Native Support for SQL:2011 Temporal Tables in PostgreSQL Thread-Topic: Question About Native Support for SQL:2011 Temporal Tables in PostgreSQL Thread-Index: AQHbNCeg1zmUmFekY0aRiBM+Y6lpWQ== Date: Mon, 11 Nov 2024 11:23:10 +0000 Message-ID: Accept-Language: en-IE, en-US Content-Language: en-IE X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DB9P194MB1825:EE_|DB8P194MB0728:EE_ x-ms-office365-filtering-correlation-id: 6f5e0789-6005-4373-409c-08dd0243397a x-microsoft-antispam: BCL:0;ARA:14566002|8060799006|15080799006|7092599003|15030799003|9400799024|8062599003|19110799003|12050799009|461199028|1602099012|10035399004|102099032|4302099013|3412199025|440099028; x-microsoft-antispam-message-info: =?Windows-1252?Q?Q0VIS7CDMYhxCsRGK/r/CDPZkLmgtP6eE73EM30o2ozuxTe8Cw9bg0Uc?= =?Windows-1252?Q?Rst+aKBbp77d8z78nuRTw7gcdCvmm1yxYM+ViKZepTBdcK2YbU2lNjGV?= =?Windows-1252?Q?LLtEx2+zGgbuhDkoxKmsOYtJBtYKoN3UbRaBQvwZfQrMSUh18u2m25+e?= =?Windows-1252?Q?d1MO8fdA56p5D8f6RIU6qcHoyVlgDx73Ra/1SHB/T9t6to1oQ+QUuRzX?= =?Windows-1252?Q?FzGNoh1nVW/UhTeVkNHPBpr9h2jPCL0nOuH4VKD4UOedRu4YtlulAk3I?= =?Windows-1252?Q?886B+3XdyjKxytDcGhdzeY+mmnPBmohwxetIP7c9Q5kLJ/gooSuJ4lrQ?= =?Windows-1252?Q?N0WG20TV44aqiKNQ3NxAYCtcpn+O0dqKyFYl8RqgI/fqxKe5UeSB+YUb?= =?Windows-1252?Q?nDiBGMcSXmNWBl5Bvzd/ETQkT3n6eBFhrqJqFidcSQske2uJkrulLr5t?= =?Windows-1252?Q?NRIxUAqTP7bkztc0HUgbL5b5BWB+VIPwkBNX6lngZZ/QBgzAx0zhJ1yS?= =?Windows-1252?Q?QqozSScmYETc38nafT/N/xix7pvPA/GVPE3YRG6IzgSApIk3VEHdHkHp?= =?Windows-1252?Q?dZKbOqc6Zmmz6UyhS7Zi17pzDVSlErd8/O8zvIpE4IRABLF0xkUVTxFy?= =?Windows-1252?Q?PUDKZ4z9EU6fVeRaJZSBpkrwOi5HftLUDU+jqfMsMgDnlpdPKLyDCnSQ?= =?Windows-1252?Q?b0Rit+k/5eIFfWnmzPfoVrNImyzSXAj7PgMMwiRKS5waJHY6SVzOKSvL?= =?Windows-1252?Q?ZLDNiAAmtsy4Nn9Jv+/Z00KoXSbsx/jvPRS+yAmH1Nk9R2Q9dkBpmU9Q?= =?Windows-1252?Q?GWC0qLdVvArkTEKEND3FbliwuHu1gHvuhMjr1u2jP9VvpTPQpbtBKZpi?= =?Windows-1252?Q?cAFQnhXyKtlRnU28IxLUd97Fqo+Ngu9qFm6txH9gJVDV9ZzYYCxGitJP?= =?Windows-1252?Q?Fe4Ndyg94/xNrGPucjIK8sXFTwBGWZ/ynPq+MR9z8oLytcXKWeTJds1X?= =?Windows-1252?Q?adLdd6I0Zwn8cibjpygU/6yTN+46Ga4W6fDgJdJ8tWf+UGQpOp3KmvYJ?= =?Windows-1252?Q?ej1J761SeWW4ifdENx9drNy89tipMceCPJ1ykFoRXQgr6MVlWzvAtG+h?= =?Windows-1252?Q?BOrKVrpXrr9wVIbjT4iKCpUk02GC7UC+dgfof70l2sP9kbQJ5CtcrUTr?= =?Windows-1252?Q?1ItwuxSXjWNrIfApdYw8FITOyrkU2NUJiHthHgH64TiJyP8p2f3kDtqx?= =?Windows-1252?Q?OZIAvTIZWm6iGULpA4FUjOZC4Wohv0S2I9jSF2ALVHQXIhlfvXBn48IT?= =?Windows-1252?Q?zh6m7UcdV8LbNBaS/DoQwAXogruc93hBTQd+dDOmdQ2xh8hv?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?Windows-1252?Q?33Ai6pV1ydpUAHtGSFMMh6YGB+VSWzR4sTMLvB00DjDjMHc3pm51BRwh?= =?Windows-1252?Q?yan3nczXTujzldxEqeRs+YBRmW09sRwwAsTSCxyX/pgl+Ym9TCIVxf3Q?= =?Windows-1252?Q?NOiwFv77NyNwsBQG21IltRMZEb3FOa29525Vea7B56lVwoat0Oqo74JT?= =?Windows-1252?Q?hV7nxUshKdxsXA/SHatZD5h00wMWMXVP96MdBNGz9sLqatHuPbKwkdhA?= =?Windows-1252?Q?DV77k9VtTMfZeyKi5uFTqeD+HsFzdnRS7vn+KRdtLELaju1IAREHtHeQ?= =?Windows-1252?Q?zkEg7qnFO+JubcR1SvER3z27B+V+rvnmWyEhWI96bYQ1HpRtLdXiFesw?= =?Windows-1252?Q?nvYPNM11DFN3IcocUoR33UbEFeS26YVKcb0vGz3H33lb/aWrJU42nI1w?= =?Windows-1252?Q?frccWdmE9ceUlMexwmELKpBItUoYmksRhoLK3WQwHUHkNDFY7V0YrjDi?= =?Windows-1252?Q?OcqElbY5GlC+fVT8DO8shjQhVeqZivbePuIIRp1LuWX9aQYbsaw1Ed00?= =?Windows-1252?Q?G2ksT77C94qOKi8EXP62DPXXVhW8z/ZYM+2vO4uy25zXziAGBUCHJGOj?= =?Windows-1252?Q?LalO/AWHePRSF6N3lYderPyWMyEofgsFT8BAOP5KDNNjH4Ser0Gf5e0G?= =?Windows-1252?Q?vjbmRoRXcmBf6ycMX96Bnu5dhPlc0n0NZzC13M5cNAWvirwdVzYVggcH?= =?Windows-1252?Q?0qD6d99vpnsJqBcG960jSB6/23mEY3iqeKfJetJQxaQL76ZwMLO/lmPC?= =?Windows-1252?Q?8etImVxibeeewIPv99Ox6F4qWHeKyWOpUu7265PRe8oLjk1l9xQNNfXh?= =?Windows-1252?Q?AENPn3UPSnEvJDYzL0F2oZknLK3IxhzU6qC3f8nEGaDmhZQ/SNGlZJrV?= =?Windows-1252?Q?HKMZNaZ1jUbzEwP5UZge5wyEAa0uXdwrHo8PCLmLyAXVYmw9lx5S6bUR?= =?Windows-1252?Q?2xF3d7P4B+mT2cfaLxo50rteYescT6DwuO6WX7sSVSbSMsDkkobx0aqf?= =?Windows-1252?Q?3aJQKT3DGnCuiSYOrbDrKwzpdLy1EZgYQS6bRyo8L2VeOOgIZ3FHCsz6?= =?Windows-1252?Q?XlUXR+7yTbOdm2qR2qw9+4Kay1VilMZNRAS+TZH74w3ksgNIy3Gt9LG+?= =?Windows-1252?Q?UAOgXVpm0S07IMTEnMtIOXHTSACC6mRMSXzZWUPYZWMajNWIrz7NtuKc?= =?Windows-1252?Q?lxO7OAnn1ERbzEX0h+6POuLuuTs/VtYobURe2EAL4bAFblkikzKteFAp?= =?Windows-1252?Q?jJInlmXQeEz7JtrnxugPlL9/NnDSGhSnhoTKMbwoxT8zjAInlcOjw6jh?= =?Windows-1252?Q?cTDRvIwjicBRJVT8cX8wVYeRi1M=3D?= Content-Type: multipart/alternative; boundary="_000_DB9P194MB1825E606FD1457EC909D5BD0AA582DB9P194MB1825EURP_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-7719-20-msonline-outlook-43ca8.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DB9P194MB1825.EURP194.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 6f5e0789-6005-4373-409c-08dd0243397a X-MS-Exchange-CrossTenant-originalarrivaltime: 11 Nov 2024 11:23:10.6427 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB8P194MB0728 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DB9P194MB1825E606FD1457EC909D5BD0AA582DB9P194MB1825EURP_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Postgres Community, I wanted to ask about support for temporal tables as defined in the SQL:201= 1 standard. Right now, I know that we can get similar functionality using e= xtensions like pg_temporal, which has been really useful. But for those of = us running PostgreSQL on managed platforms like AWS RDS (where adding custo= m extensions isn=92t an option), it creates a bit of a challenge. Here are a few questions I=92d love your thoughts on: 1. Are there any plans or discussions about adding native support for SQL:2011= temporal tables, so we don=92t need extensions? 2. What are the main reasons behind needing an extension for this feature? Is = it tough to build directly into PostgreSQL=92s core? 3. For those who can=92t use extensions (like on AWS RDS), is it practical to = build temporal table features using only RAW SQL. I'm aware of the Nearform= trigger solution but I'd really love the syntactical sugar "with SYSTEM VE= RISON" gives? If so, are there any best practices or tips for recreating so= me of that extension-like functionality? Having native temporal table support would be a huge help for users needing= built-in tools for audits, historical tracking, and meeting data complianc= e needs. I think adding these features natively could make PostgreSQL even = more powerful and flexible for different use cases. I've been looking into https://github.com/xocolatl/periods but I can't tell= if its an extension or part of the regular deployment. Thanks so much for taking the time to read this and share your insights. Lo= oking forward to hearing what you all think! Dave --_000_DB9P194MB1825E606FD1457EC909D5BD0AA582DB9P194MB1825EURP_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Hi Postgres Community, 

I wanted to ask about support for temporal tables as defined in the SQL:201= 1 standard. Right now, I know that we can get similar functionality using e= xtensions like pg_temporal, which has been really useful. But for those of us= running PostgreSQL on managed platforms like AWS RDS (where adding custom = extensions isn=92t an option), it creates a bit of a challenge.
Here are a few questions I=92d love your thoughts on:
  1. Are there any plans or = discussions about adding native support for SQL:2011 temporal tables, so we= don=92t need extensions?
  2. What are the main reaso= ns behind needing an extension for this feature? Is it tough to build direc= tly into PostgreSQL=92s core?
  3. Having native temporal table support would be a huge help for users needing= built-in tools for audits, historical tracking, and meeting data complianc= e needs. I think adding these features natively could make PostgreSQL even = more powerful and flexible for different use cases.
    I've been looking into https://github.com/xocolatl/periods but I can't tell if its an ext= ension or part of the regular deployment. 
    Thanks so much for taking the time to read this and share your insights. Lo= oking forward to hearing what you all think!

    Dave

    --_000_DB9P194MB1825E606FD1457EC909D5BD0AA582DB9P194MB1825EURP_--