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 1trans-005xau-K5 for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Mar 2025 10:56:12 +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 1tranq-0092Yu-S0 for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Mar 2025 10:56:10 +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 1tranp-0092Ym-Sq for pgsql-hackers@lists.postgresql.org; Mon, 10 Mar 2025 10:56:10 +0000 Received: from fout-b4-smtp.messagingengine.com ([202.12.124.147]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1trank-0020no-2U for pgsql-hackers@lists.postgresql.org; Mon, 10 Mar 2025 10:56:08 +0000 Received: from phl-compute-08.internal (phl-compute-08.phl.internal [10.202.2.48]) by mailfout.stl.internal (Postfix) with ESMTP id 496C81140164; Mon, 10 Mar 2025 06:56:03 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-08.internal (MEProxy); Mon, 10 Mar 2025 06:56:03 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:subject:subject:to:to; s=fm3; t=1741604163; x=1741690563; bh=UtXTJE7oN9s1C1IrMMYWUUzIvWpFrRQT YqanuNDfUaE=; b=N8Z1ECIyDFWgU1rsvC9W0HMEDTVOHye3HNq3fDrSTgM9gF8i czPeUsk9o7c01ZU6mI3h9zFe6Xkw59vZ7PDKCjB3L/1pR2NBz7LFF/abbo+I4qX8 TBLXX7Mgwo6fS68JdaHVW3jEK77LCmv9utlL8EKiBejbJ6yJ9WJhOLYAs0TL4fE7 NypnbuRXn458rJKhdizcVAr7HmhNQCzEN4CWe9REmYXL9RivaRMNcyt4LI/2k6bV GV+1gLNOFQCRYelD231210pGRWORgKfsbblroDY34oXdeSZws9WqJyJ4BrfrcOrn x3imZNmqHxJpUKJatq4WartBQ5vSXZ1Dzu+61g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1741604163; x= 1741690563; bh=UtXTJE7oN9s1C1IrMMYWUUzIvWpFrRQTYqanuNDfUaE=; b=b zXOn3TQ7Fcv7QQNZQ4uXOTL5Z8hYlj8/wGvO0G+qLt+rJB0IzVHkoPfCaV2xoCd5 Grs9ugjfKHXfCqQ7T2H+CcW5/bItY9YX/d+drrAciysjqY6AeOvWcrLrLblQWAjS 4Z+gGfP+rocG97QigKf8npysBON+pLZ7CER8W2Ii1DCrb3GAHl7+onemcDp8nfid wBX6TZw7fychuyT3T4+UnNQ5VSMFMNZRQ7ayG/BdBYZUel5u64UCboG3jVPkXP7/ pC2EquJyE8T8CWPMjDDXekbeXCEAAvqKoQXVIaFGnqhwahjZYFlWy0lx0TbYIfaz 7Psc8DT+S9Pe5dfgUjIng== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdduudeludeiucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddt vdejnecuhfhrohhmpefrvghtvghrucfgihhsvghnthhrrghuthcuoehpvghtvghrsegvih hsvghnthhrrghuthdrohhrgheqnecuggftrfgrthhtvghrnhepleejtddugffgffefhfei teefheetudekjeeutdelhfeggfffudejheeufeduffeknecuffhomhgrihhnpehpohhsth hgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgr ihhlfhhrohhmpehpvghtvghrsegvihhsvghnthhrrghuthdrohhrghdpnhgspghrtghpth htohepgedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepphhjsehilhhluhhmihhn rghtvggutghomhhpuhhtihhnghdrtghomhdprhgtphhtthhopehjihgrnhdruhhnihhvvg hrshgrlhhithihsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqhhgrtghk vghrsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpthhtohepvhhigh hnvghshhdvudesghhmrghilhdrtghomh X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 10 Mar 2025 06:56:01 -0400 (EDT) Message-ID: <6ac43c8e-5595-40d9-a039-ede12e7487e1@eisentraut.org> Date: Mon, 10 Mar 2025 11:56:00 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: SQL:2011 application time To: Paul Jungwirth Cc: jian he , PostgreSQL Hackers , vignesh C References: <66e47fc0-77b7-4763-9b70-5c0b7ff15f21@eisentraut.org> <333d3886-b737-45c3-93f4-594c96bb405d@eisentraut.org> <6a2247d9-461d-4b0a-b692-f0f3c0fab27f@eisentraut.org> <8f995a4c-64e3-40cd-bfed-06b54a280d36@illuminatedcomputing.com> <0832f18d-523f-4c15-acb0-338a785150c5@illuminatedcomputing.com> <5f0c25de-2c13-4fb5-a4df-a1e03c43cd14@illuminatedcomputing.com> <1b45f81d-4e99-4813-a2c6-72bf5fd80980@eisentraut.org> <3e061027-781d-42c1-b6e8-bafbf3b51033@eisentraut.org> <3b33690e-0d67-47a5-8424-93ac1fed4c26@eisentraut.org> <1085d8a3-17a7-4639-afd2-bd6dfa09713d@illuminatedcomputing.com> Content-Language: en-US From: Peter Eisentraut In-Reply-To: <1085d8a3-17a7-4639-afd2-bd6dfa09713d@illuminatedcomputing.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 26.02.25 06:15, Paul Jungwirth wrote: > > ON DELETE RESTRICT must be specified when PERIOD BUSINESS_TIME is > also specified. > > Here are some patches removing support for RESTRICT I have committed this. I think this is about as much as we can hope to get done from this patch series for PG18. I don't think the subsequent patches are ready enough. As an example, the FOR PORTION OF still has the problem I mentioned at , and a few similar structural problems. Also, I see that you have recently changed some things to make use of SPI, which seems problematic. This needs much further analysis. My suggestions is to close the commitfest entry as "committed" and start new threads and new entries for the subsequent features.