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 1pYWgd-0004PC-Cn for pgsql-committers@arkaria.postgresql.org; Sat, 04 Mar 2023 18:32:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pYWgc-0004QD-2x for pgsql-committers@arkaria.postgresql.org; Sat, 04 Mar 2023 18:32:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pYWgb-0004Fo-QQ for pgsql-committers@lists.postgresql.org; Sat, 04 Mar 2023 18:32:49 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pYWgY-0002Mc-Ng for pgsql-committers@lists.postgresql.org; Sat, 04 Mar 2023 18:32:49 +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 1pYWgX-0002hp-7d for pgsql-committers@lists.postgresql.org; Sat, 04 Mar 2023 18:32:45 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pYWgW-001tbz-3v for pgsql-committers@lists.postgresql.org; Sat, 04 Mar 2023 18:32:44 +0000 Content-Type: multipart/mixed; boundary="===============5470207445567558933==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid failure when altering state of partitioned foreign-key tri X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 04 Mar 2023 18:32:44 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5470207445567558933== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgZmFpbHVyZSB3aGVuIGFsdGVyaW5nIHN0YXRlIG9mIHBhcnRpdGlvbmVkIGZvcmVpZ24t a2V5IHRyaWdnZXJzLgoKQmVnaW5uaW5nIGluIHYxNSwgaWYgeW91IGFwcGx5IEFMVEVSIFRBQkxF IEVOQUJMRS9ESVNBQkxFIFRSSUdHRVIgdG8KYSBwYXJ0aXRpb25lZCB0YWJsZSwgaXQgYWxzbyBh ZmZlY3RzIHRoZSBwYXJ0aXRpb25zJyBjbG9uZWQgdmVyc2lvbnMKb2YgdGhlIGFmZmVjdGVkIHRy aWdnZXIocykuICBUaGUgaW5pdGlhbCBpbXBsZW1lbnRhdGlvbiBvZiB0aGlzCmxvY2F0ZWQgdGhl IGNsb25lcyBieSBuYW1lLCBidXQgdGhhdCBmYWlscyBvbiBmb3JlaWduLWtleSB0cmlnZ2Vycwp3 aGljaCBoYXZlIG5hbWVzIGluY29ycG9yYXRpbmcgdGhlaXIgb3duIE9JRHMuICBXZSBjYW4gZml4 IHRoYXQsIGFuZAphbHNvIG1ha2UgdGhlIGJlaGF2aW9yIG1vcmUgYnVsbGV0cHJvb2YgaW4gdGhl IGZhY2Ugb2YgdXNlci1pbml0aWF0ZWQKdHJpZ2dlciByZW5hbWVzLCBieSBpZGVudGlmeWluZyB0 aGUgY2xvbmVkIHRyaWdnZXJzIGJ5IHRncGFyZW50aWQuCgpGb2xsb3dpbmcgdGhlIGxlYWQgb2Yg ZWFybGllciBjb21taXRzIGluIHRoaXMgYXJlYSwgSSB0b29rIGNhcmUgbm90CnRvIGJyZWFrIEFC SSBpbiB0aGUgdjE1IGJyYW5jaCwgZXZlbiB0aG91Z2ggSSByYXRoZXIgZG91YnQgdGhlcmUKYXJl IGFueSBleHRlcm5hbCBjYWxsZXJzIG9mIEVuYWJsZURpc2FibGVUcmlnZ2VyLgoKV2hpbGUgaGVy ZSwgdXBkYXRlIHRoZSBkb2N1bWVudGF0aW9uLCB3aGljaCB3YXMgbm90IHRvdWNoZWQgd2hlbgp0 aGUgc2VtYW50aWNzIHdlcmUgY2hhbmdlZC4KClBlciBidWcgIzE3ODE3IGZyb20gQWxhbiBIb2Rn c29uLiAgQmFjay1wYXRjaCB0byB2MTU7IG9sZGVyIHZlcnNpb25zCmRvIG5vdCBoYXZlIHRoaXMg YmVoYXZpb3IuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE3ODE3LTMxZGZiN2My MTAwZDlmM2RAcG9zdGdyZXNxbC5vcmcKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0t LS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi82OTQ5YjkyMWQ1 NDU4MDlhODNmOGE2YmFkNDk0OGY5MDEyYTc2ZmI2CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0t LS0tLQpkb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX3RhYmxlLnNnbWwgICAgICB8IDIzICsrKysrKysr KysrKysrKystLS0tLS0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5jICAgICAgIHwg IDMgKystCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3RyaWdnZXIuYyAgICAgICAgIHwgMTEgKysrKysr KystLS0Kc3JjL2luY2x1ZGUvY29tbWFuZHMvdHJpZ2dlci5oICAgICAgICAgfCAgMiArLQpzcmMv dGVzdC9yZWdyZXNzL2V4cGVjdGVkL3RyaWdnZXJzLm91dCB8IDM0ICsrKysrKysrKysrKysrKysr KysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvdHJpZ2dlcnMuc3FsICAgICAg fCAxNSArKysrKysrKysrKysrKysKNiBmaWxlcyBjaGFuZ2VkLCA3NiBpbnNlcnRpb25zKCspLCAx MiBkZWxldGlvbnMoLSkKCg== --===============5470207445567558933==--