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 1taRuz-001rYs-RJ for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Jan 2025 04:00:42 +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 1taRuy-00B9ZY-Ss for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Jan 2025 04:00:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1taRuy-00B9ZQ-Jw for pgsql-hackers@lists.postgresql.org; Wed, 22 Jan 2025 04:00:40 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1taRuu-000pnm-2u for pgsql-hackers@lists.postgresql.org; Wed, 22 Jan 2025 04:00:39 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 50M40UEt3611541; Tue, 21 Jan 2025 23:00:30 -0500 From: Tom Lane To: Peter Eisentraut cc: Paul Jungwirth , jian he , PostgreSQL Hackers , vignesh C Subject: Re: SQL:2011 application time In-reply-to: <1b45f81d-4e99-4813-a2c6-72bf5fd80980@eisentraut.org> References: <9b7cb814-c78c-489f-85b2-32be4398647f@illuminatedcomputing.com> <95c6d49b-7d60-4ad0-820c-e00ae1b2a3d4@illuminatedcomputing.com> <57ea0668-5205-426e-b934-efc89f2186c2@illuminatedcomputing.com> <6dc196d4-8853-49d7-8dd3-e391058451c1@eisentraut.org> <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@illuminatedcomputin! g.com> <1b45f81d-4e99-4813-a2c6-72bf5fd80980@eisentraut.org> Comments: In-reply-to Peter Eisentraut message dated "Tue, 21 Jan 2025 19:52:30 +0100" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <3611539.1737518430.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Tue, 21 Jan 2025 23:00:30 -0500 Message-ID: <3611540.1737518430@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Peter Eisentraut writes: > I have committed the fix for foreign key NO ACTION (patch 0002, this did= = > not require patch 0001). That commit seems to be causing occasional buildfarm failures: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dindri&dt=3D2025-= 01-22%2001%3A29%3A35 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dmylodon&dt=3D202= 5-01-22%2001%3A17%3A14 Both of these look like --- /Users/buildfarm/bf-data/HEAD/pgsql.build/src/test/regress/expected/wi= thout_overlaps.out 2025-01-21 20:29:36 +++ /Users/buildfarm/bf-data/HEAD/pgsql.build/src/test/regress/results/wit= hout_overlaps.out 2025-01-21 20:43:08 @@ -1792,8 +1792,6 @@ SET valid_at =3D CASE WHEN lower(valid_at) =3D '2018-01-01' THEN datera= nge('2018-01-01', '2018-01-05') WHEN lower(valid_at) =3D '2018-02-01' THEN daterang= e('2018-01-05', '2018-03-01') END WHERE id =3D '[6,7)'; -ERROR: update or delete on table "temporal_rng" violates RESTRICT settin= g of foreign key constraint "temporal_fk_rng2rng_fk" on table "temporal_fk= _rng2rng" -DETAIL: Key (id, valid_at)=3D([6,7), [2018-01-01,2018-02-01)) is referen= ced from table "temporal_fk_rng2rng". -- a PK update that fails because both are referenced (even before commit= ): BEGIN; ALTER TABLE temporal_fk_rng2rng ie, an expected error did not get thrown. regards, tom lane