Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1muuB7-0008SI-EF for pgsql-committers@arkaria.postgresql.org; Wed, 08 Dec 2021 10:28:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1muuB6-0006Zz-8g for pgsql-committers@arkaria.postgresql.org; Wed, 08 Dec 2021 10:28:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1muuB6-0006Zq-1O for pgsql-committers@lists.postgresql.org; Wed, 08 Dec 2021 10:28:00 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1muuB3-0003RO-KG for pgsql-committers@lists.postgresql.org; Wed, 08 Dec 2021 10:27:59 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1muuB3-0000DV-8o for pgsql-committers@lists.postgresql.org; Wed, 08 Dec 2021 10:27:57 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1muuB2-0004XM-QE for pgsql-committers@lists.postgresql.org; Wed, 08 Dec 2021 10:27:56 +0000 Content-Type: multipart/mixed; boundary="===============0075302822145888212==" MIME-Version: 1.0 From: Peter Eisentraut To: pgsql-committers@lists.postgresql.org Subject: pgsql: Allow specifying column list for foreign key ON DELETE SET actio X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 08 Dec 2021 10:27:56 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0075302822145888212== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWxsb3cgc3BlY2lmeWluZyBjb2x1bW4gbGlzdCBmb3IgZm9yZWlnbiBrZXkgT04gREVMRVRFIFNF VCBhY3Rpb25zCgpFeHRlbmQgdGhlIGZvcmVpZ24ga2V5IE9OIERFTEVURSBhY3Rpb25zIFNFVCBO VUxMIGFuZCBTRVQgREVGQVVMVCBieQphbGxvd2luZyB0aGUgc3BlY2lmaWNhdGlvbiBvZiBhIGNv bHVtbiBsaXN0LCBsaWtlCgogICAgQ1JFQVRFIFRBQkxFIHBvc3RzICgKICAgICAgICAuLi4KICAg ICAgICBGT1JFSUdOIEtFWSAodGVuYW50X2lkLCBhdXRob3JfaWQpIFJFRkVSRU5DRVMgdXNlcnMg T04gREVMRVRFIFNFVCBOVUxMIChhdXRob3JfaWQpCiAgICApOwoKSWYgYSBjb2x1bW4gbGlzdCBp cyBzcGVjaWZpZWQsIG9ubHkgdGhvc2UgY29sdW1ucyBhcmUgc2V0IHRvCm51bGwvZGVmYXVsdCwg aW5zdGVhZCBvZiBhbGwgdGhlIGNvbHVtbnMgaW4gdGhlIGZvcmVpZ24ta2V5CmNvbnN0cmFpbnQu CgpUaGlzIGlzIHVzZWZ1bCBmb3IgbXVsdGl0ZW5hbnQgb3Igc2hhcmRlZCBzY2hlbWFzLCB3aGVy ZSB0aGUgdGVuYW50IG9yCnNoYXJkIElEIGlzIGluY2x1ZGVkIGluIHRoZSBwcmltYXJ5IGtleSBv ZiBhbGwgdGFibGVzIGJ1dCBzaG91bGRuJ3QgYmUKc2V0IHRvIG51bGwuCgpBdXRob3I6IFBhdWwg TWFydGluZXogPHBhdWxtdHpAZ29vZ2xlLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly93d3cucG9z dGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9mbGF0L0NBQ3FGVkJaUXlNWUpWPW5qYlNNeGYrcmJESHB4 PVc9QjdBRWFNS244ZFduOU9aSlk3d0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0 ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRk aWZmL2Q2Zjk2ZWQ5NGU3MzA1MmY5OWEyZTU0NWVkMTdhOGIyZmRjMWZiOGEKCk1vZGlmaWVkIEZp bGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sICAgICAgICAgICAg ICAgIHwgIDEyICsrKwpkb2Mvc3JjL3NnbWwvZGRsLnNnbWwgICAgICAgICAgICAgICAgICAgICB8 ICAzMyArKysrKysrLQpkb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX3RhYmxlLnNnbWwgICAgICAgICB8 ICAgMiArLQpkb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sICAgICAgICB8ICAyNCAr KysrLS0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9oZWFwLmMgICAgICAgICAgICAgICAgfCAgIDIgKwpz cmMvYmFja2VuZC9jYXRhbG9nL2luZGV4LmMgICAgICAgICAgICAgICB8ICAgMiArCnNyYy9iYWNr ZW5kL2NhdGFsb2cvcGdfY29uc3RyYWludC5jICAgICAgIHwgIDUzICsrKysrKysrKysrLQpzcmMv YmFja2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAgICAgICB8ICA5NyArKysrKysrKysrKysr KysrKysrLS0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvdHJpZ2dlci5jICAgICAgICAgICAgfCAgIDIg KwpzcmMvYmFja2VuZC9jb21tYW5kcy90eXBlY21kcy5jICAgICAgICAgICB8ICAgMiArCnNyYy9i YWNrZW5kL25vZGVzL2NvcHlmdW5jcy5jICAgICAgICAgICAgIHwgICAxICsKc3JjL2JhY2tlbmQv bm9kZXMvZXF1YWxmdW5jcy5jICAgICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9ub2Rlcy9v dXRmdW5jcy5jICAgICAgICAgICAgICB8ICAgMSArCnNyYy9iYWNrZW5kL3BhcnNlci9ncmFtLnkg ICAgICAgICAgICAgICAgIHwgMTM0ICsrKysrKysrKysrKysrKysrKysrKysrKystLS0tLQpzcmMv YmFja2VuZC91dGlscy9hZHQvcmlfdHJpZ2dlcnMuYyAgICAgICB8IDExNSArKysrKysrKysrKysr KysrKystLS0tLS0tCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9ydWxldXRpbHMuYyAgICAgICAgIHwg IDEwICsrKwpzcmMvYmFja2VuZC91dGlscy9jYWNoZS9yZWxjYWNoZS5jICAgICAgICB8ICAgMiAr LQpzcmMvaW5jbHVkZS9jYXRhbG9nL2NhdHZlcnNpb24uaCAgICAgICAgICB8ICAgMiArLQpzcmMv aW5jbHVkZS9jYXRhbG9nL3BnX2NvbnN0cmFpbnQuaCAgICAgICB8ICAxMSArKy0Kc3JjL2luY2x1 ZGUvbm9kZXMvcGFyc2Vub2Rlcy5oICAgICAgICAgICAgfCAgIDEgKwpzcmMvdGVzdC9yZWdyZXNz L2V4cGVjdGVkL2ZvcmVpZ25fa2V5Lm91dCB8ICA3MSArKysrKysrKysrKysrKysrCnNyYy90ZXN0 L3JlZ3Jlc3Mvc3FsL2ZvcmVpZ25fa2V5LnNxbCAgICAgIHwgIDUxICsrKysrKysrKysrKwoyMiBm aWxlcyBjaGFuZ2VkLCA1NTcgaW5zZXJ0aW9ucygrKSwgNzIgZGVsZXRpb25zKC0pCgo= --===============0075302822145888212==--