MIME-Version: 1.0
References: <ec498c3d-5f2b-48ec-b989-5561c8aa2024@illuminatedcomputing.com>
 <85ac7f0e-d95f-4377-ade0-8941fd328012@eisentraut.org>
 <CA+renyUazgR-hB_6RY60n23L0y-n_h9G1AappZmPENO0k5pL1g@mail.gmail.com>
 <7d63ddfa-c735-4dfe-8c7a-4f1e2a621058@eisentraut.org>
 <CA+renyVXg5pV84wQnGQuK8-=qoKw3BiBgQzesxM_LkcxxWmYjA@mail.gmail.com>
 <e59d218a-ae49-490f-ae6f-86c12f35d3c3@eisentraut.org>
 <CA+renyWKOj5=rMmQmJcbybu-Vdomxdp=eJ93kp76AgmQKYdfiQ@mail.gmail.com>
 <4606deaa-7d65-4f22-8a78-356c3180be9d@eisentraut.org>
 <CA+renyUhuXB2nTVCMREXew9E4DZOnFxQNjME5bcw91+k72Bosg@mail.gmail.com>
 <CA+renyWUCSyTMn3s03kviEN-oaVrJP-QkDQCLNfaY=MHV5QEiQ@mail.gmail.com>
 <CA+renyV4tWU2d=n9_v=XNPHbZfNqqLokzd-Xt78M-zLd+46ubA@mail.gmail.com>
 <53f1c094-3c29-4ef6-a9bd-dc2e7894ceb0@eisentraut.org>
 <CA+renyUSgqXpjj+vV7w+wirPB49VQFrmPjVT_s04JmZSOPNNsQ@mail.gmail.com>
 <b2ecbf9f-797f-433d-953f-3c848cde5a1c@eisentraut.org>
 <CA+renyX-eV+2hFUaZg3BSREqLE7dh+LoWm7ZqhFAiGsirjjtRQ@mail.gmail.com>
 <e2fc32a4-319b-4176-8bd8-1d974e31376f@eisentraut.org>
 <CAHg+QDckLFqthQyox2NDetYRs9sRrjmAiSA-gYRowyg8w_4vgw@mail.gmail.com>
 <CAHg+QDd74fnd4obCRMqVS0AVWf=cSFH=Cv7trTJWgm+_bhTK6w@mail.gmail.com>
In-Reply-To: 
 <CAHg+QDd74fnd4obCRMqVS0AVWf=cSFH=Cv7trTJWgm+_bhTK6w@mail.gmail.com>
From: SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>
Date: Thu, 9 Apr 2026 12:42:23 -0700
Message-ID: 
 <CAHg+QDcVL2d4ih5zs2Mzh63ts41N+jtnMQTdZ2_0be6aF4aqYQ@mail.gmail.com>
Subject: Re: SQL:2011 Application Time Update & Delete
To: Peter Eisentraut <peter@eisentraut.org>
Cc: Paul A Jungwirth <pj@illuminatedcomputing.com>,
 Chao Li <li.evan.chao@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000d6589e064f0c37eb"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHg%2BQDcVL2d4ih5zs2Mzh63ts41N%2BjtnMQTdZ2_0be6aF4aqYQ%40mail.gmail.com>
Precedence: bulk

--000000000000d6589e064f0c37eb
Content-Type: multipart/alternative; boundary="000000000000d6589e064f0c37e9"

--000000000000d6589e064f0c37e9
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Apr 9, 2026 at 12:35=E2=80=AFPM SATYANARAYANA NARLAPURAM <
satyanarlapuram@gmail.com> wrote:

> Hi Paul, Peter,
>
> I found a Server crash when using UPDATE ... FOR PORTION OF or DELETE ...
> FOR PORTION OF on a view that has INSTEAD OF triggers.
>
> Repro:
>
> CREATE TABLE t (id INT, valid_at daterange, val INT);
> INSERT INTO t VALUES (1, '[2026-01-01,2026-12-31)', 100);
> CREATE VIEW v AS SELECT * FROM t;
>
> CREATE FUNCTION v_trig() RETURNS trigger LANGUAGE plpgsql AS $$
> BEGIN
>     UPDATE t SET val =3D NEW.val WHERE id =3D OLD.id;
>     RETURN NEW;
> END;
> $$;
> CREATE TRIGGER trg INSTEAD OF UPDATE ON v
>     FOR EACH ROW EXECUTE FUNCTION v_trig();
>
> -- This crashes the server:
> UPDATE v FOR PORTION OF valid_at FROM '2026-04-01' TO '2026-08-01'
>     SET val =3D 999 WHERE id =3D 1;
>
> I am thinking we should just reject this case. Attached a draft patch to
> fix the issue.
>

Patches attached now.

--000000000000d6589e064f0c37e9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote g=
mail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Apr 9, =
2026 at 12:35=E2=80=AFPM SATYANARAYANA NARLAPURAM &lt;<a href=3D"mailto:sat=
yanarlapuram@gmail.com">satyanarlapuram@gmail.com</a>&gt; wrote:<br></div><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=
=3D"ltr"><div>Hi Paul, Peter,</div><div><br></div><div>I found a Server cra=
sh when using UPDATE ... FOR PORTION OF or DELETE ... FOR PORTION OF on a v=
iew that has INSTEAD OF triggers.<br><br>Repro:</div><div><br>CREATE TABLE =
t (id INT, valid_at daterange, val INT);<br>INSERT INTO t VALUES (1, &#39;[=
2026-01-01,2026-12-31)&#39;, 100);<br>CREATE VIEW v AS SELECT * FROM t;<br>=
<br>CREATE FUNCTION v_trig() RETURNS trigger LANGUAGE plpgsql AS $$<br>BEGI=
N<br>=C2=A0 =C2=A0 UPDATE t SET val =3D NEW.val WHERE id =3D OLD.id;<br>=C2=
=A0 =C2=A0 RETURN NEW;<br>END;<br>$$;<br>CREATE TRIGGER trg INSTEAD OF UPDA=
TE ON v<br>=C2=A0 =C2=A0 FOR EACH ROW EXECUTE FUNCTION v_trig();<br><br>-- =
This crashes the server:<br>UPDATE v FOR PORTION OF valid_at FROM &#39;2026=
-04-01&#39; TO &#39;2026-08-01&#39;<br>=C2=A0 =C2=A0 SET val =3D 999 WHERE =
id =3D 1;<br><br>I am thinking we should just reject this case. Attached a =
draft patch to fix the issue.=C2=A0</div></div></div></blockquote><div><br>=
</div><div>Patches attached now.</div><div>=C2=A0</div></div></div>

--000000000000d6589e064f0c37e9--

--000000000000d6589e064f0c37eb
Content-Type: application/octet-stream;
	name="0008-test-fpo-crash-instead-of-trigger-views.patch"
Content-Disposition: attachment;
	filename="0008-test-fpo-crash-instead-of-trigger-views.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mnrvvefa1>
X-Attachment-Id: f_mnrvvefa1

ZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZm9yX3BvcnRpb25fb2Yub3V0
IGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9mb3JfcG9ydGlvbl9vZi5vdXQKaW5kZXggMzFm
NzcyYzcuLmI4NjJlNWQ0IDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2Zv
cl9wb3J0aW9uX29mLm91dAorKysgYi9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2Zvcl9wb3J0
aW9uX29mLm91dApAQCAtMjA5Nyw0ICsyMDk3LDI2IEBAIFNFTEVDVCAqIEZST00gdGVtcG9yYWxf
cGFydGl0aW9uZWRfNSBPUkRFUiBCWSBpZCwgdmFsaWRfYXQ7CiAoNCByb3dzKQogCiBEUk9QIFRB
QkxFIHRlbXBvcmFsX3BhcnRpdGlvbmVkOworLS0gVGVzdDogRk9SIFBPUlRJT04gT0Ygc2hvdWxk
IGJlIHJlamVjdGVkIG9uIHZpZXdzIHdpdGggSU5TVEVBRCBPRiB0cmlnZ2VycworQ1JFQVRFIFRB
QkxFIGZwb19pbnN0ZWFkX2Jhc2UgKGlkIGludCwgdmFsaWRfYXQgZGF0ZXJhbmdlLCB2YWwgaW50
KTsKK0lOU0VSVCBJTlRPIGZwb19pbnN0ZWFkX2Jhc2UgVkFMVUVTICgxLCAnWzIwMjQtMDEtMDEs
MjAyNC0xMi0zMSknLCAxMDApOworQ1JFQVRFIFZJRVcgZnBvX2luc3RlYWRfdmlldyBBUyBTRUxF
Q1QgKiBGUk9NIGZwb19pbnN0ZWFkX2Jhc2U7CitDUkVBVEUgRlVOQ1RJT04gZnBvX2luc3RlYWRf
dHJpZ19mbigpIFJFVFVSTlMgdHJpZ2dlciBMQU5HVUFHRSBwbHBnc3FsIEFTICQkCitCRUdJTgor
ICAgIFJFVFVSTiBORVc7CitFTkQ7CiskJDsKK0NSRUFURSBUUklHR0VSIGZwb19pbnN0ZWFkX3Ry
aWcgSU5TVEVBRCBPRiBVUERBVEUgT04gZnBvX2luc3RlYWRfdmlldworICAgIEZPUiBFQUNIIFJP
VyBFWEVDVVRFIEZVTkNUSU9OIGZwb19pbnN0ZWFkX3RyaWdfZm4oKTsKK0NSRUFURSBUUklHR0VS
IGZwb19pbnN0ZWFkX2RlbF90cmlnIElOU1RFQUQgT0YgREVMRVRFIE9OIGZwb19pbnN0ZWFkX3Zp
ZXcKKyAgICBGT1IgRUFDSCBST1cgRVhFQ1VURSBGVU5DVElPTiBmcG9faW5zdGVhZF90cmlnX2Zu
KCk7CistLSBUaGVzZSBzaG91bGQgcHJvZHVjZSBjbGVhbiBlcnJvciBtZXNzYWdlcywgbm90IGNy
YXNoIHRoZSBzZXJ2ZXIKK1VQREFURSBmcG9faW5zdGVhZF92aWV3IEZPUiBQT1JUSU9OIE9GIHZh
bGlkX2F0IEZST00gJzIwMjQtMDQtMDEnIFRPICcyMDI0LTA4LTAxJworICAgIFNFVCB2YWwgPSA5
OTkgV0hFUkUgaWQgPSAxOyAgLS0gZXJyb3IKK0VSUk9SOiAgRk9SIFBPUlRJT04gT0YgaXMgbm90
IHN1cHBvcnRlZCBvbiB2aWV3cyB3aXRoIElOU1RFQUQgT0YgdHJpZ2dlcnMKK0RFTEVURSBGUk9N
IGZwb19pbnN0ZWFkX3ZpZXcgRk9SIFBPUlRJT04gT0YgdmFsaWRfYXQgRlJPTSAnMjAyNC0wNC0w
MScgVE8gJzIwMjQtMDgtMDEnCisgICAgV0hFUkUgaWQgPSAxOyAgLS0gZXJyb3IKK0VSUk9SOiAg
Rk9SIFBPUlRJT04gT0YgaXMgbm90IHN1cHBvcnRlZCBvbiB2aWV3cyB3aXRoIElOU1RFQUQgT0Yg
dHJpZ2dlcnMKK0RST1AgVklFVyBmcG9faW5zdGVhZF92aWV3OworRFJPUCBUQUJMRSBmcG9faW5z
dGVhZF9iYXNlOwogUkVTRVQgZGF0ZXN0eWxlOwpkaWZmIC0tZ2l0IGEvc3JjL3Rlc3QvcmVncmVz
cy9zcWwvZm9yX3BvcnRpb25fb2Yuc3FsIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvZm9yX3BvcnRp
b25fb2Yuc3FsCmluZGV4IGQ0MDYyYWNmLi43NzYxMGU1ZiAxMDA2NDQKLS0tIGEvc3JjL3Rlc3Qv
cmVncmVzcy9zcWwvZm9yX3BvcnRpb25fb2Yuc3FsCisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3Fs
L2Zvcl9wb3J0aW9uX29mLnNxbApAQCAtMTM2NSw0ICsxMzY1LDI1IEBAIFNFTEVDVCAqIEZST00g
dGVtcG9yYWxfcGFydGl0aW9uZWRfNSBPUkRFUiBCWSBpZCwgdmFsaWRfYXQ7CiAKIERST1AgVEFC
TEUgdGVtcG9yYWxfcGFydGl0aW9uZWQ7CiAKKy0tIFRlc3Q6IEZPUiBQT1JUSU9OIE9GIHNob3Vs
ZCBiZSByZWplY3RlZCBvbiB2aWV3cyB3aXRoIElOU1RFQUQgT0YgdHJpZ2dlcnMKK0NSRUFURSBU
QUJMRSBmcG9faW5zdGVhZF9iYXNlIChpZCBpbnQsIHZhbGlkX2F0IGRhdGVyYW5nZSwgdmFsIGlu
dCk7CitJTlNFUlQgSU5UTyBmcG9faW5zdGVhZF9iYXNlIFZBTFVFUyAoMSwgJ1syMDI0LTAxLTAx
LDIwMjQtMTItMzEpJywgMTAwKTsKK0NSRUFURSBWSUVXIGZwb19pbnN0ZWFkX3ZpZXcgQVMgU0VM
RUNUICogRlJPTSBmcG9faW5zdGVhZF9iYXNlOworQ1JFQVRFIEZVTkNUSU9OIGZwb19pbnN0ZWFk
X3RyaWdfZm4oKSBSRVRVUk5TIHRyaWdnZXIgTEFOR1VBR0UgcGxwZ3NxbCBBUyAkJAorQkVHSU4K
KyAgICBSRVRVUk4gTkVXOworRU5EOworJCQ7CitDUkVBVEUgVFJJR0dFUiBmcG9faW5zdGVhZF90
cmlnIElOU1RFQUQgT0YgVVBEQVRFIE9OIGZwb19pbnN0ZWFkX3ZpZXcKKyAgICBGT1IgRUFDSCBS
T1cgRVhFQ1VURSBGVU5DVElPTiBmcG9faW5zdGVhZF90cmlnX2ZuKCk7CitDUkVBVEUgVFJJR0dF
UiBmcG9faW5zdGVhZF9kZWxfdHJpZyBJTlNURUFEIE9GIERFTEVURSBPTiBmcG9faW5zdGVhZF92
aWV3CisgICAgRk9SIEVBQ0ggUk9XIEVYRUNVVEUgRlVOQ1RJT04gZnBvX2luc3RlYWRfdHJpZ19m
bigpOworLS0gVGhlc2Ugc2hvdWxkIHByb2R1Y2UgY2xlYW4gZXJyb3IgbWVzc2FnZXMsIG5vdCBj
cmFzaCB0aGUgc2VydmVyCitVUERBVEUgZnBvX2luc3RlYWRfdmlldyBGT1IgUE9SVElPTiBPRiB2
YWxpZF9hdCBGUk9NICcyMDI0LTA0LTAxJyBUTyAnMjAyNC0wOC0wMScKKyAgICBTRVQgdmFsID0g
OTk5IFdIRVJFIGlkID0gMTsgIC0tIGVycm9yCitERUxFVEUgRlJPTSBmcG9faW5zdGVhZF92aWV3
IEZPUiBQT1JUSU9OIE9GIHZhbGlkX2F0IEZST00gJzIwMjQtMDQtMDEnIFRPICcyMDI0LTA4LTAx
JworICAgIFdIRVJFIGlkID0gMTsgIC0tIGVycm9yCitEUk9QIFZJRVcgZnBvX2luc3RlYWRfdmll
dzsKK0RST1AgVEFCTEUgZnBvX2luc3RlYWRfYmFzZTsKKwogUkVTRVQgZGF0ZXN0eWxlOwo=
--000000000000d6589e064f0c37eb
Content-Type: application/octet-stream;
	name="0007-fix-fpo-crash-instead-of-trigger-views.patch"
Content-Disposition: attachment;
	filename="0007-fix-fpo-crash-instead-of-trigger-views.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mnrvveez0>
X-Attachment-Id: f_mnrvveez0

ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3Jld3JpdGUvcmV3cml0ZUhhbmRsZXIuYyBiL3NyYy9i
YWNrZW5kL3Jld3JpdGUvcmV3cml0ZUhhbmRsZXIuYwppbmRleCAwMjFjNzNmMS4uOWE5Y2M4MmMg
MTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL3Jld3JpdGUvcmV3cml0ZUhhbmRsZXIuYworKysgYi9z
cmMvYmFja2VuZC9yZXdyaXRlL3Jld3JpdGVIYW5kbGVyLmMKQEAgLTE3NjksNiArMTc2OSwxOCBA
QCBBcHBseVJldHJpZXZlUnVsZShRdWVyeSAqcGFyc2V0cmVlLAogCQkgKiBBbHNvIG5vdGUgdGhh
dCB0aGVyZSdzIGEgaGFjayBpbiBmaXJlUklScnVsZXMgdG8gYXZvaWQgY2FsbGluZyB0aGlzCiAJ
CSAqIGZ1bmN0aW9uIGFnYWluIHdoZW4gaXQgYXJyaXZlcyBhdCB0aGUgY29waWVkIFJURS4KIAkJ
ICovCisKKwkJLyoKKwkJICogRk9SIFBPUlRJT04gT0YgcmVxdWlyZXMgYWNjZXNzIHRvIHRoZSBw
aHlzaWNhbCByb3cgdG8gY29tcHV0ZSB0ZW1wb3JhbCBsZWZ0b3ZlcnMuCisJCSAqIFZpZXdzIHdp
dGggSU5TVEVBRCBPRiB0cmlnZ2VycyBoYXZlIG5vIHBoeXNpY2FsIHN0b3JhZ2UuCisJCSAqLwor
CQlpZiAocGFyc2V0cmVlLT5mb3JQb3J0aW9uT2YpCisJCQllcmVwb3J0KEVSUk9SLAorCQkJCQko
ZXJyY29kZShFUlJDT0RFX0ZFQVRVUkVfTk9UX1NVUFBPUlRFRCksCisJCQkJCSBlcnJtc2coIkZP
UiBQT1JUSU9OIE9GIGlzIG5vdCBzdXBwb3J0ZWQgb24gdmlld3Mgd2l0aCBJTlNURUFEIE9GIHRy
aWdnZXJzIikpKTsKKwogCQlpZiAocGFyc2V0cmVlLT5jb21tYW5kVHlwZSA9PSBDTURfSU5TRVJU
KQogCQkJcmV0dXJuIHBhcnNldHJlZTsKIAkJZWxzZSBpZiAocGFyc2V0cmVlLT5jb21tYW5kVHlw
ZSA9PSBDTURfVVBEQVRFIHx8Cg==
--000000000000d6589e064f0c37eb--