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 1rnXXU-00Dnk0-DQ for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2024 05:34:00 +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 1rnXXR-000gxL-W6 for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2024 05:33:58 +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 1rnXXR-000gxC-LQ for pgsql-hackers@lists.postgresql.org; Fri, 22 Mar 2024 05:33:58 +0000 Received: from mail-vs1-xe2e.google.com ([2607:f8b0:4864:20::e2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rnXXL-005qh5-6W for pgsql-hackers@lists.postgresql.org; Fri, 22 Mar 2024 05:33:57 +0000 Received: by mail-vs1-xe2e.google.com with SMTP id ada2fe7eead31-4767bcb4ebdso729084137.0 for ; Thu, 21 Mar 2024 22:33:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1711085629; x=1711690429; 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=h72xLLL55XkLhfAjLKo25Skr7pl/SJU8qbZjtM+YSvY=; b=Wp4wSEphqNQd32zAHC3jVtF6jqVEZ1lPZS7fwWD4wQqKeAroo+rVcslA0vr4k2BUD9 gY+v/H5xkR2Uu1MguqbKkjLI9CwDXbAG6vp57CfkvPL5DnSNvUddsqrjM0fM5SzzIdTj rux0fGInJ63g7Rn68AQ/HtOe/XGqSfr/h22OkPEmnXLkoqak4cXOMznm0H0NNSOm/nOR zxqfJaM5Ep/IUJT3WRI8QwvTeJ2gFmS2yTifaUNc4p81iylVOIEHy8/ozkiP6dt7Hbdc O+PK4dHuPPOvhCSE5mj1GOS6Am4b7d5rTr2yOC+HuUBe0MQw8pZg8684cnvGmQsS/AN9 1kCQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1711085629; x=1711690429; 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=h72xLLL55XkLhfAjLKo25Skr7pl/SJU8qbZjtM+YSvY=; b=GlZlX6N4VHQL/RdOilGCy/Gv8cq0uyDAVYDXdr5zfhMja4u3bd4htp8xhnO13m8EY4 rScvZbwBDvO46PPlgm12C9LnELlvhqu/5N6NVArKX3DjquwnwWSGyrf21+ZhN9pzwByR Iv+zWNauupfZ0elphsKoQC9WHpU3YEXe+9MJYptXZbB5KIB2RN6ZaqbKPdMiGzK9a4L0 xpzqHw81Akcx/Hha9vYFntUQDcO9c+azzm8rniREai5MlGD3PwAQhkaUzOma28BWkDCs adYrXA23f7ZqaKRdyWGNM6DbikUjQ60VRqB8J8zaKJQfdOCBZrsq8zvhWWqbWkr8dth5 yuUQ== X-Forwarded-Encrypted: i=1; AJvYcCUjRKZep47LzVpr2BKGgClQqD3N9ClUvE2gMZIPZlXZYId1O3sQ4yrpH/N2e56IaVM/e4BgG/qV/hj0gRAitFiz3whtQ1HBgtEAdEfVbfP3Rqt8 X-Gm-Message-State: AOJu0Yz+tiVRPJbUIZ2eOoj+jRE1gb+7wgP2xrZCxYNeh1bQvoLqSDj6 nxpeWJqCcBp/ab0Ux4WcaPP6tM4LPYODxA+sm66ZXJf04ursI9z5aD4Y+GxefK3ggK2YJO0RIiF xsAY0ieVIYqS47Jsd4AkqsiipdeQ= X-Google-Smtp-Source: AGHT+IGjPER3JWMXdLAGZRFtjUIpPGT/99E6CjfAa8bGhMr97wo4My8n35ebffwuJ/10Z89gx4mtSEGt9AiCEvM5g1Q= X-Received: by 2002:a05:6102:5110:b0:476:cc67:ecc2 with SMTP id bm16-20020a056102511000b00476cc67ecc2mr1884181vsb.30.1711085629134; Thu, 21 Mar 2024 22:33:49 -0700 (PDT) MIME-Version: 1.0 References: <113f5e25-4455-4bdb-98ec-56275705cc4e@illuminatedcomputing.com> <7bd1c8f9-a91a-41a3-990e-0f796ba692ec@eisentraut.org> <6c3edb2c-bc45-4f19-babd-8f4edf39b384@illuminatedcomputing.com> <41b57948-f4d3-455f-8880-e0ce7e61ffc1@illuminatedcomputing.com> <0d977c63-f4a6-43ba-aad0-35c06c55df11@eisentraut.org> <85dd3ad0-fa79-46e8-a08b-c426c76825f3@eisentraut.org> In-Reply-To: From: jian he Date: Fri, 22 Mar 2024 13:33:37 +0800 Message-ID: Subject: Re: SQL:2011 application time To: Paul Jungwirth Cc: Peter Eisentraut , PostgreSQL Hackers Content-Type: multipart/mixed; boundary="0000000000001b7a080614392b75" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001b7a080614392b75 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, Mar 22, 2024 at 8:35=E2=80=AFAM Paul Jungwirth wrote: > > Your patch had a lot of other noisy changes, e.g. > whitespace and reordering lines. If there are other things you intended t= o add to the tests, can you > describe them? i think on update restrict, on delete restrict cannot be deferred, even if you set it DEFERRABLE INITIALLY DEFERRED. based on this idea, I made minor change on v32-0002-Support-multiranges-in-temporal-FKs.patch other than that, v32, 0002 looks good. --0000000000001b7a080614392b75 Content-Type: application/octet-stream; name="v32-0001-minor-refactor-temporal-FKs-with-multiranges-.no-cfbot" Content-Disposition: attachment; filename="v32-0001-minor-refactor-temporal-FKs-with-multiranges-.no-cfbot" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_lu286wj20 RnJvbSBkY2E2ODY1NmQ5MzRjYWIzZTg4YTM5YmI4YjgzNGYwMDI3ZDgwZjI2IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBqaWFuIGhlIDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+ CkRhdGU6IEZyaSwgMjIgTWFyIDIwMjQgMTM6MzA6NTYgKzA4MDAKU3ViamVjdDogW1BBVENIIHYz MiAxLzFdIG1pbm9yIHJlZmFjdG9yIHRlbXBvcmFsIEZLcyB3aXRoIG11bHRpcmFuZ2VzCiByZWdy ZXNzaW9uIHRlc3QKCi0tLQogc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC93aXRob3V0X292ZXJs YXBzLm91dCB8IDEwICsrKysrKysrKysKIHNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3dpdGhvdXRfb3Zl cmxhcHMuc3FsICAgICAgfCAxMSArKysrKysrKysrKwogMiBmaWxlcyBjaGFuZ2VkLCAyMSBpbnNl cnRpb25zKCspCgpkaWZmIC0tZ2l0IGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC93aXRob3V0 X292ZXJsYXBzLm91dCBiL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvd2l0aG91dF9vdmVybGFw cy5vdXQKaW5kZXggY2EyNmFjYjguLjNkYTZkODY5IDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL3dpdGhvdXRfb3ZlcmxhcHMub3V0CisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3Mv ZXhwZWN0ZWQvd2l0aG91dF9vdmVybGFwcy5vdXQKQEAgLTgzNywxMSArODM3LDE2IEBAIElOU0VS VCBJTlRPIHRlbXBvcmFsX3JuZyAoaWQsIHZhbGlkX2F0KSBWQUxVRVMKIElOU0VSVCBJTlRPIHRl bXBvcmFsX2ZrX3JuZzJybmcgKGlkLCB2YWxpZF9hdCwgcGFyZW50X2lkKSBWQUxVRVMgKCdbMyw0 KScsIGRhdGVyYW5nZSgnMjAxOC0wMS0wNScsICcyMDE4LTAxLTEwJyksICdbNSw2KScpOwogVVBE QVRFIHRlbXBvcmFsX3JuZyBTRVQgdmFsaWRfYXQgPSBkYXRlcmFuZ2UoJzIwMTYtMDItMDEnLCAn MjAxNi0wMy0wMScpCiBXSEVSRSBpZCA9ICdbNSw2KScgQU5EIHZhbGlkX2F0ID0gZGF0ZXJhbmdl KCcyMDE4LTAyLTAxJywgJzIwMTgtMDMtMDEnKTsKK2JlZ2luOworCUFMVEVSIFRBQkxFIHRlbXBv cmFsX2ZrX3JuZzJybmcKKwkJQUxURVIgQ09OU1RSQUlOVCB0ZW1wb3JhbF9ma19ybmcycm5nX2Zr CisJCURFRkVSUkFCTEUgSU5JVElBTExZIERFRkVSUkVEOwogLS0gYSBQSyB1cGRhdGUgdGhhdCBm YWlscyBiZWNhdXNlIGJvdGggYXJlIHJlZmVyZW5jZWQ6CiBVUERBVEUgdGVtcG9yYWxfcm5nIFNF VCB2YWxpZF9hdCA9IGRhdGVyYW5nZSgnMjAxNi0wMS0wMScsICcyMDE2LTAyLTAxJykKIFdIRVJF IGlkID0gJ1s1LDYpJyBBTkQgdmFsaWRfYXQgPSBkYXRlcmFuZ2UoJzIwMTgtMDEtMDEnLCAnMjAx OC0wMi0wMScpOwogRVJST1I6ICB1cGRhdGUgb3IgZGVsZXRlIG9uIHRhYmxlICJ0ZW1wb3JhbF9y bmciIHZpb2xhdGVzIGZvcmVpZ24ga2V5IGNvbnN0cmFpbnQgInRlbXBvcmFsX2ZrX3JuZzJybmdf ZmsiIG9uIHRhYmxlICJ0ZW1wb3JhbF9ma19ybmcycm5nIgogREVUQUlMOiAgS2V5IChpZCwgdmFs aWRfYXQpPShbNSw2KSwgWzIwMTgtMDEtMDEsMjAxOC0wMi0wMSkpIGlzIHN0aWxsIHJlZmVyZW5j ZWQgZnJvbSB0YWJsZSAidGVtcG9yYWxfZmtfcm5nMnJuZyIuCityb2xsYmFjazsKIC0tIGNoYW5n aW5nIHRoZSBzY2FsYXIgcGFydCBmYWlsczoKIFVQREFURSB0ZW1wb3JhbF9ybmcgU0VUIGlkID0g J1s3LDgpJwogV0hFUkUgaWQgPSAnWzUsNiknIEFORCB2YWxpZF9hdCA9IGRhdGVyYW5nZSgnMjAx OC0wMS0wMScsICcyMDE4LTAyLTAxJyk7CkBAIC05MDUsMTAgKzkxMCwxNSBAQCBJTlNFUlQgSU5U TyB0ZW1wb3JhbF9ybmcgKGlkLCB2YWxpZF9hdCkgVkFMVUVTCiAgICgnWzUsNiknLCBkYXRlcmFu Z2UoJzIwMTgtMDItMDEnLCAnMjAxOC0wMy0wMScpKTsKIElOU0VSVCBJTlRPIHRlbXBvcmFsX2Zr X3JuZzJybmcgKGlkLCB2YWxpZF9hdCwgcGFyZW50X2lkKSBWQUxVRVMgKCdbMyw0KScsIGRhdGVy YW5nZSgnMjAxOC0wMS0wNScsICcyMDE4LTAxLTEwJyksICdbNSw2KScpOwogREVMRVRFIEZST00g dGVtcG9yYWxfcm5nIFdIRVJFIGlkID0gJ1s1LDYpJyBBTkQgdmFsaWRfYXQgPSBkYXRlcmFuZ2Uo JzIwMTgtMDItMDEnLCAnMjAxOC0wMy0wMScpOworYmVnaW47CisJQUxURVIgVEFCTEUgdGVtcG9y YWxfZmtfcm5nMnJuZworCQlBTFRFUiBDT05TVFJBSU5UIHRlbXBvcmFsX2ZrX3JuZzJybmdfZmsK KwkJREVGRVJSQUJMRSBJTklUSUFMTFkgREVGRVJSRUQ7CiAtLSBhIFBLIGRlbGV0ZSB0aGF0IGZh aWxzIGJlY2F1c2UgYm90aCBhcmUgcmVmZXJlbmNlZDoKIERFTEVURSBGUk9NIHRlbXBvcmFsX3Ju ZyBXSEVSRSBpZCA9ICdbNSw2KScgQU5EIHZhbGlkX2F0ID0gZGF0ZXJhbmdlKCcyMDE4LTAxLTAx JywgJzIwMTgtMDItMDEnKTsKIEVSUk9SOiAgdXBkYXRlIG9yIGRlbGV0ZSBvbiB0YWJsZSAidGVt cG9yYWxfcm5nIiB2aW9sYXRlcyBmb3JlaWduIGtleSBjb25zdHJhaW50ICJ0ZW1wb3JhbF9ma19y bmcycm5nX2ZrIiBvbiB0YWJsZSAidGVtcG9yYWxfZmtfcm5nMnJuZyIKIERFVEFJTDogIEtleSAo aWQsIHZhbGlkX2F0KT0oWzUsNiksIFsyMDE4LTAxLTAxLDIwMTgtMDItMDEpKSBpcyBzdGlsbCBy ZWZlcmVuY2VkIGZyb20gdGFibGUgInRlbXBvcmFsX2ZrX3JuZzJybmciLgorcm9sbGJhY2s7CiAt LSB0aGVuIGRlbGV0ZSB0aGUgb2JqZWN0aW5nIEZLIHJlY29yZCBhbmQgdGhlIHNhbWUgUEsgZGVs ZXRlIHN1Y2NlZWRzOgogREVMRVRFIEZST00gdGVtcG9yYWxfZmtfcm5nMnJuZyBXSEVSRSBpZCA9 ICdbMyw0KSc7CiBERUxFVEUgRlJPTSB0ZW1wb3JhbF9ybmcgV0hFUkUgaWQgPSAnWzUsNiknIEFO RCB2YWxpZF9hdCA9IGRhdGVyYW5nZSgnMjAxOC0wMS0wMScsICcyMDE4LTAyLTAxJyk7CmRpZmYg LS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC93aXRob3V0X292ZXJsYXBzLnNxbCBiL3NyYy90 ZXN0L3JlZ3Jlc3Mvc3FsL3dpdGhvdXRfb3ZlcmxhcHMuc3FsCmluZGV4IGU1ZmVjM2ZjLi5jYjU5 YWM0NyAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9zcWwvd2l0aG91dF9vdmVybGFwcy5z cWwKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvd2l0aG91dF9vdmVybGFwcy5zcWwKQEAgLTY3 NCw5ICs2NzQsMTUgQEAgSU5TRVJUIElOVE8gdGVtcG9yYWxfcm5nIChpZCwgdmFsaWRfYXQpIFZB TFVFUwogSU5TRVJUIElOVE8gdGVtcG9yYWxfZmtfcm5nMnJuZyAoaWQsIHZhbGlkX2F0LCBwYXJl bnRfaWQpIFZBTFVFUyAoJ1szLDQpJywgZGF0ZXJhbmdlKCcyMDE4LTAxLTA1JywgJzIwMTgtMDEt MTAnKSwgJ1s1LDYpJyk7CiBVUERBVEUgdGVtcG9yYWxfcm5nIFNFVCB2YWxpZF9hdCA9IGRhdGVy YW5nZSgnMjAxNi0wMi0wMScsICcyMDE2LTAzLTAxJykKIFdIRVJFIGlkID0gJ1s1LDYpJyBBTkQg dmFsaWRfYXQgPSBkYXRlcmFuZ2UoJzIwMTgtMDItMDEnLCAnMjAxOC0wMy0wMScpOworCitiZWdp bjsKKwlBTFRFUiBUQUJMRSB0ZW1wb3JhbF9ma19ybmcycm5nCisJCUFMVEVSIENPTlNUUkFJTlQg dGVtcG9yYWxfZmtfcm5nMnJuZ19maworCQlERUZFUlJBQkxFIElOSVRJQUxMWSBERUZFUlJFRDsK IC0tIGEgUEsgdXBkYXRlIHRoYXQgZmFpbHMgYmVjYXVzZSBib3RoIGFyZSByZWZlcmVuY2VkOgog VVBEQVRFIHRlbXBvcmFsX3JuZyBTRVQgdmFsaWRfYXQgPSBkYXRlcmFuZ2UoJzIwMTYtMDEtMDEn LCAnMjAxNi0wMi0wMScpCiBXSEVSRSBpZCA9ICdbNSw2KScgQU5EIHZhbGlkX2F0ID0gZGF0ZXJh bmdlKCcyMDE4LTAxLTAxJywgJzIwMTgtMDItMDEnKTsKK3JvbGxiYWNrOwogLS0gY2hhbmdpbmcg dGhlIHNjYWxhciBwYXJ0IGZhaWxzOgogVVBEQVRFIHRlbXBvcmFsX3JuZyBTRVQgaWQgPSAnWzcs OCknCiBXSEVSRSBpZCA9ICdbNSw2KScgQU5EIHZhbGlkX2F0ID0gZGF0ZXJhbmdlKCcyMDE4LTAx LTAxJywgJzIwMTgtMDItMDEnKTsKQEAgLTczOSw4ICs3NDUsMTMgQEAgSU5TRVJUIElOVE8gdGVt cG9yYWxfcm5nIChpZCwgdmFsaWRfYXQpIFZBTFVFUwogICAoJ1s1LDYpJywgZGF0ZXJhbmdlKCcy MDE4LTAyLTAxJywgJzIwMTgtMDMtMDEnKSk7CiBJTlNFUlQgSU5UTyB0ZW1wb3JhbF9ma19ybmcy cm5nIChpZCwgdmFsaWRfYXQsIHBhcmVudF9pZCkgVkFMVUVTICgnWzMsNCknLCBkYXRlcmFuZ2Uo JzIwMTgtMDEtMDUnLCAnMjAxOC0wMS0xMCcpLCAnWzUsNiknKTsKIERFTEVURSBGUk9NIHRlbXBv cmFsX3JuZyBXSEVSRSBpZCA9ICdbNSw2KScgQU5EIHZhbGlkX2F0ID0gZGF0ZXJhbmdlKCcyMDE4 LTAyLTAxJywgJzIwMTgtMDMtMDEnKTsKK2JlZ2luOworCUFMVEVSIFRBQkxFIHRlbXBvcmFsX2Zr X3JuZzJybmcKKwkJQUxURVIgQ09OU1RSQUlOVCB0ZW1wb3JhbF9ma19ybmcycm5nX2ZrCisJCURF RkVSUkFCTEUgSU5JVElBTExZIERFRkVSUkVEOwogLS0gYSBQSyBkZWxldGUgdGhhdCBmYWlscyBi ZWNhdXNlIGJvdGggYXJlIHJlZmVyZW5jZWQ6CiBERUxFVEUgRlJPTSB0ZW1wb3JhbF9ybmcgV0hF UkUgaWQgPSAnWzUsNiknIEFORCB2YWxpZF9hdCA9IGRhdGVyYW5nZSgnMjAxOC0wMS0wMScsICcy MDE4LTAyLTAxJyk7Cityb2xsYmFjazsKIC0tIHRoZW4gZGVsZXRlIHRoZSBvYmplY3RpbmcgRksg cmVjb3JkIGFuZCB0aGUgc2FtZSBQSyBkZWxldGUgc3VjY2VlZHM6CiBERUxFVEUgRlJPTSB0ZW1w b3JhbF9ma19ybmcycm5nIFdIRVJFIGlkID0gJ1szLDQpJzsKIERFTEVURSBGUk9NIHRlbXBvcmFs X3JuZyBXSEVSRSBpZCA9ICdbNSw2KScgQU5EIHZhbGlkX2F0ID0gZGF0ZXJhbmdlKCcyMDE4LTAx LTAxJywgJzIwMTgtMDItMDEnKTsKCmJhc2UtY29tbWl0OiAwODVlNzU5ZTlkYTc3YjdmNWU4NTlk MjNmNzI2NTNmMzYyNzdhMDUzCnByZXJlcXVpc2l0ZS1wYXRjaC1pZDogMzU4OWQ0YzUxYjVmNTJi MDMzMTg3MDViMWMwNzBkN2RiNTU5ODk4YQpwcmVyZXF1aXNpdGUtcGF0Y2gtaWQ6IGYwM2FmZGQz YjAwYWNkNjMxMDI3NmU2NmU0YzNhOWZkMjZiM2Y2MzEKLS0gCjIuMzQuMQoK --0000000000001b7a080614392b75--