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 1tuTaK-008x9E-Ti for pgsql-hackers@arkaria.postgresql.org; Tue, 18 Mar 2025 09:50:08 +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 1tuTaI-00BMY5-Pe for pgsql-hackers@arkaria.postgresql.org; Tue, 18 Mar 2025 09:50:06 +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 1tuTaI-00BMXo-FS for pgsql-hackers@lists.postgresql.org; Tue, 18 Mar 2025 09:50:06 +0000 Received: from mail-yb1-xb32.google.com ([2607:f8b0:4864:20::b32]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tuTaG-003U43-1n for pgsql-hackers@lists.postgresql.org; Tue, 18 Mar 2025 09:50:05 +0000 Received: by mail-yb1-xb32.google.com with SMTP id 3f1490d57ef6-e3978c00a5aso4510238276.1 for ; Tue, 18 Mar 2025 02:50:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742291404; x=1742896204; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=k4VqItEf9KCVV+U+gCPGUbhNp2W25krzG0CYXs1xPJ8=; b=V7FLYeuCnPt02+bZmzj20JHNSdbY0RJmDlQ2MJJI4yMzthDgSS5kXyDjpVHjv/rNef ZlWdPLnPzR5myitEeJx5swusDBLXkZjJXwvEhZKJ17GZQUPLJ2ON8nDQGiG4PISv8Z9i FheKfLeyS7NeK7fwCV2xaCacLg3Y0gV+Ja2pwaf9Ws8cQ3jcizhLSOprRVi2kMON9PsZ SN6UIu2n3lfsKS8d9qZ+UfwR0yNuIJ5wmlKHejG05HkSFN1b/CaYKy2QFzOQjDS7ii2W diTXyiLevttnypoIrH9oiAWw5JHFnEnAPy3ot4Q+V0fpbvqA8vc6nnyD/KHZuuIFuGC1 p3Gw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742291404; x=1742896204; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=k4VqItEf9KCVV+U+gCPGUbhNp2W25krzG0CYXs1xPJ8=; b=SX/Mgcs5g0LUyv4t0p7ReEyzbm0SURZCOXtVzwoChs0gn+Os8OJS5EPRMhRUVw+9hy +wZKoj0rkWRqzl6ot7u8RqysIbYRN+fweJrH4oDjb5QvGQHXeNCuAY1AldWYj9xA+fT8 DrAugJbCuBUfKKcofscS+nJOxzJ8efeZmaZudhFqLJLz4CAjP3IqIfSvKkW5u1X9sEYU N7PKa/Ufo2nVsfzyrZsjUokQtx68fzW+7NO9dcE2EmIcYhDbjrJmut4w0HGC3FOUCG1n Ggw3owK/Z9rA5GsxpfQ+SrkU4CsskYu/KeDX9PlTs/UB8B8dvGbz1GgOR6Olzu5bmoYn kQ+Q== X-Forwarded-Encrypted: i=1; AJvYcCVrqnRa1miLpMpyGOXWT/OCZuDvsXuuNelX9l32SNvjA5Pw7e/PnsaGuKRNOCWfrnDyps6eGCgnw7CUZYGu@lists.postgresql.org X-Gm-Message-State: AOJu0Yz6RU3zIEMsYWWcwplr4VN+n3r2pf7bpgneyweC4EQwWZNGhX70 eyYASCOQJHoVoOWbN15+dEpvCxY5UfN/qFYG4tR6oEf4Ba95lAH375N4s29IHx7RgMamx1B7gG8 j/Exhh5Q6MZvtGB1YA6jK+zWP1Eg= X-Gm-Gg: ASbGncs51njs+P8TWbyC51YQG1AgGkdEk8SvlldMReuNqLenJYbf5Q86/wyepIBHrnn Brn52xKyyyLSIfp/A3GBXGBVgZUt2po0+EGaDiTWoadm/efNZy5n2Ye11kj81DlyUV1fIlPBmtI VLKt/uGjAhoS5kt3EIokWbNXms X-Google-Smtp-Source: AGHT+IGbXEybTvxrq/ETH2Thg+qTYrL9HmKDCNoXeKLc7DBUFAJ7YvR1RGwlyCZaJjHaxgpsZ+3ebTjUAKIz2aUSSHk= X-Received: by 2002:a05:690c:4988:b0:6fe:bf9d:8cca with SMTP id 00721157ae682-6ff45bddba0mr204245557b3.0.1742291403767; Tue, 18 Mar 2025 02:50:03 -0700 (PDT) MIME-Version: 1.0 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> <6ac43c8e-5595-40d9-a039-ede12e7487e1@eisentraut.org> In-Reply-To: <6ac43c8e-5595-40d9-a039-ede12e7487e1@eisentraut.org> From: vignesh C Date: Tue, 18 Mar 2025 15:19:51 +0530 X-Gm-Features: AQ5f1JpmcyD14cO7Th5muTIYistooG6_2Z-HtkJc8TmT7D07m4qX622QZ-vMu4U Message-ID: Subject: Re: SQL:2011 application time To: Peter Eisentraut Cc: Paul Jungwirth , jian he , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 10 Mar 2025 at 16:26, Peter Eisentraut wrote: > > 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. I have marked this commitfest entry as committed based on your suggestion. It is better to start a new thread for the remaining work. Regards, Vignesh