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 1rxldO-00Bf9Q-S2 for pgsql-committers@arkaria.postgresql.org; Fri, 19 Apr 2024 10:38:22 +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 1rxldM-0011RZ-Fz for pgsql-committers@arkaria.postgresql.org; Fri, 19 Apr 2024 10:38:20 +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 1rxldM-0011RR-8Z for pgsql-committers@lists.postgresql.org; Fri, 19 Apr 2024 10:38:20 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rxldK-001n9z-9s for pgsql-committers@lists.postgresql.org; Fri, 19 Apr 2024 10:38:19 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rxldI-00960q-4o for pgsql-committers@lists.postgresql.org; Fri, 19 Apr 2024 10:38:16 +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 1rxldH-002pB7-7m for pgsql-committers@lists.postgresql.org; Fri, 19 Apr 2024 10:38:15 +0000 Content-Type: multipart/mixed; boundary="===============4962974413666181122==" MIME-Version: 1.0 From: Alvaro Herrera To: pgsql-committers@lists.postgresql.org Subject: pgsql: Better handle indirect constraint drops X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 19 Apr 2024 10:38:15 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4962974413666181122== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QmV0dGVyIGhhbmRsZSBpbmRpcmVjdCBjb25zdHJhaW50IGRyb3BzCgpJdCBpcyBwb3NzaWJsZSBm b3IgY2VydGFpbiBjYXNlcyB0byByZW1vdmUgbm90LW51bGwgY29uc3RyYWludHMgd2l0aG91dApt YWludGFpbmluZyB0aGUgYXR0bm90bnVsbCBpbiBpdHMgY29ycmVjdCBzdGF0ZTsgZm9yIGV4YW1w bGUgaWYgeW91IGRyb3AKYSBjb2x1bW4gdGhhdCdzIHBhcnQgb2YgdGhlIHByaW1hcnkga2V5LCBh bmQgdGhlIG90aGVyIGNvbHVtbnMgb2YgdGhlIFBLIGRvbid0CmhhdmUgbm90LW51bGwgY29uc3Ry YWludHMsIHRoZW4gd2Ugc2hvdWxkIHJlc2V0IHRoZSBhdHRub3RudWxsIGZsYWdzIGZvcgp0aG9z ZSBvdGhlciBjb2x1bW5zOyB1cCB0byB0aGlzIGNvbW1pdCwgd2UgZGlkbid0LiAgSGFuZGxlIHRo b3NlIGNhc2VzCmJldHRlciBieSBkb2luZyB0aGUgYXR0bm90bnVsbCByZXNldCBpbiBSZW1vdmVD b25zdHJhaW50QnlJZCgpIGluc3RlYWQKb2YgaW4gZHJvcGNvbnN0cmFpbnRfaW50ZXJuYWwoKS4K Ckhvd2V2ZXIsIHRoZXJlIGFyZSBzb21lIGNhc2VzIHdoZXJlIHdlIG11c3Qgbm90IGRvIHNvLiAg Rm9yIGV4YW1wbGUgaWYKdGhvc2Ugb3RoZXIgY29sdW1ucyBhcmUgaW4gcmVwbGljYSBpZGVudGl0 eSBpbmRleGVzIG9yIGFyZSBnZW5lcmF0ZWQKaWRlbnRpdHkgY29sdW1ucywgd2UgbXVzdCBrZWVw IGF0dG5vdG51bGwgc2V0LCBldmVuIHRob3VnaCBpdCByZXN1bHRzIGluCnRoZSBjYXRhbG9nIGlu Y29uc2lzdGVuY3kgdGhhdCBubyBub3QtbnVsbCBjb25zdHJhaW50IHN1cHBvcnRzIHRoYXQuCgpC ZWNhdXNlIHRoZSBhdHRub3RudWxsIHJlc2V0IG5vdyBoYXBwZW5zIGluIG1vcmUgcGxhY2VzIHRo YW4gYmVmb3JlLCBmb3IKaW5zdGFuY2Ugd2hlbiBhIGNvbHVtbiBvZiB0aGUgcHJpbWFyeSBrZXkg Y2hhbmdlcyB0eXBlLCB3ZSBuZWVkIGFuCmFkZGl0aW9uYWwgdHJpY2sgdG8gcmVpbnN0YXRlIGl0 IGFzIG5lY2Vzc2FyeS4gIEludHJvZHVjZSBhIG5ldwphbHRlci10YWJsZSBwYXNzIHRoYXQgZG9l cyB0aGlzLCB3aGljaCBuZWVkcyBzaW1wbHkgcmVzY2hlZHVsZSBzb21lCkFUX1NldEF0dE5vdE51 bGwgc3ViY29tbWFuZHMgdGhhdCB3ZXJlIGFscmVhZHkgYmVpbmcgZ2VuZXJhdGVkIGFuZAppZ25v cmVkLgoKQmVjYXVzZSBvZiB0aGUgZXhjZXB0aW9ucyBpbiB3aGljaCBhdHRub3RudWxsIGlzIG5v dCByZXNldCBub3RlZCBhYm92ZSwKd2UgYWxzbyBpbmNsdWRlIGEgcGdfZHVtcCBoYWNrIHRvIGlu Y2x1ZGUgYSBub3QtbnVsbCBjb25zdHJhaW50IHdoZW4gdGhlCmF0dG5vdG51bGwgZmxhZyBpcyBz ZXQgZXZlbiBpZiBubyBwZ19jb25zdHJhaW50IHJvdyBleGlzdHMuICBUaGlzIHBhcnQKaXMgdW5k ZXNpcmFibGUgYnV0IG5lY2Vzc2FyeSwgYmVjYXVzZSBmYWlsaW5nIHRvIGhhbmRsZSB0aGUgY2Fz ZSBjYW4KcmVzdWx0IGluIHVucmVzdG9yYWJsZSBkdW1wcy4KClJlcG9ydGVkLWJ5OiBUZW5kZXIg V2FuZyA8dG5kcndhbmdAZ21haWwuY29tPgpDby1hdXRob3JlZC1ieTogVGVuZGVyIFdhbmcgPHRu ZHJ3YW5nQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IGppYW4gaGUgPGppYW4udW5pdmVyc2FsaXR5 QGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUhld1hOPWhNYk5h M2Q0M05PUj1PQ2dkZ3BUdDE4Uy0xZm11ZUNvRUdlc3llSzRicXdAbWFpbC5nbWFpbC5jb20KCkJy YW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNx bC5vcmcvcGcvY29tbWl0ZGlmZi8wY2Q3MTEyNzFkNDJiMDg4OGQzNmY4ZWRhNTBlMTA5MmMyZmVk NGIzCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9jYXRhbG9nL3Bn X2NvbnN0cmFpbnQuYyAgICAgICB8IDExNyArKysrKysrKysrKysrKysrKysrKysrKysrLQpzcmMv YmFja2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAgICAgICB8IDEzNSArKysrKysrKysrKysr KystLS0tLS0tLS0tLS0tLS0Kc3JjL2Jpbi9wZ19kdW1wL3BnX2R1bXAuYyAgICAgICAgICAgICAg ICAgfCAgMzAgKysrKystLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NvbnN0cmFpbnRzLm91 dCB8ICA3OCArKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9jb25zdHJhaW50 cy5zcWwgICAgICB8ICAzOSArKysrKysrKysKNSBmaWxlcyBjaGFuZ2VkLCAzMjMgaW5zZXJ0aW9u cygrKSwgNzYgZGVsZXRpb25zKC0pCgo= --===============4962974413666181122==--