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 1pYWgc-0004P0-5T for pgsql-committers@arkaria.postgresql.org; Sat, 04 Mar 2023 18:32:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pYWga-0003xs-I5 for pgsql-committers@arkaria.postgresql.org; Sat, 04 Mar 2023 18:32:48 +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 1pYWga-0003xj-Av for pgsql-committers@lists.postgresql.org; Sat, 04 Mar 2023 18:32:48 +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 1pYWgX-0003KX-JX for pgsql-committers@lists.postgresql.org; Sat, 04 Mar 2023 18:32:47 +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-0002hq-7h 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-001tc0-5A for pgsql-committers@lists.postgresql.org; Sat, 04 Mar 2023 18:32:44 +0000 Content-Type: multipart/mixed; boundary="===============1870297933418745979==" 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 --===============1870297933418745979== 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 MTAwZDlmM2RAcG9zdGdyZXNxbC5vcmcKCkJyYW5jaAotLS0tLS0KUkVMXzE1X1NUQUJMRQoKRGV0 YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZjYx ZTYwMTAyZjA4MzA1ZjNjYjllNTVhNzk1OGI4MDM2YTAyZmUzOQoKTW9kaWZpZWQgRmlsZXMKLS0t LS0tLS0tLS0tLS0KZG9jL3NyYy9zZ21sL3JlZi9hbHRlcl90YWJsZS5zZ21sICAgICAgfCAyMyAr KysrKysrKysrKysrLS0tLS0tLQpzcmMvYmFja2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAg ICB8ICA1ICsrKy0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3RyaWdnZXIuYyAgICAgICAgIHwgMzgg KysrKysrKysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLQpzcmMvaW5jbHVkZS9jb21tYW5kcy90 cmlnZ2VyLmggICAgICAgICB8ICAzICsrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3RyaWdn ZXJzLm91dCB8IDM0ICsrKysrKysrKysrKysrKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdy ZXNzL3NxbC90cmlnZ2Vycy5zcWwgICAgICB8IDE1ICsrKysrKysrKysrKysrCjYgZmlsZXMgY2hh bmdlZCwgOTggaW5zZXJ0aW9ucygrKSwgMjAgZGVsZXRpb25zKC0pCgo= --===============1870297933418745979==--