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 1t3FsF-00BUjb-Rp for pgsql-committers@arkaria.postgresql.org; Tue, 22 Oct 2024 14:28:40 +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 1t3FsD-0004ze-E6 for pgsql-committers@arkaria.postgresql.org; Tue, 22 Oct 2024 14:28:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3Fpp-0001xv-1A for pgsql-committers@lists.postgresql.org; Tue, 22 Oct 2024 14:26:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3Fpk-002ING-0S for pgsql-committers@lists.postgresql.org; Tue, 22 Oct 2024 14:26:08 +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 1t3Fph-006tLl-PV for pgsql-committers@lists.postgresql.org; Tue, 22 Oct 2024 14:26:02 +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 1t3Fph-001v1n-RK for pgsql-committers@lists.postgresql.org; Tue, 22 Oct 2024 14:26:01 +0000 Content-Type: multipart/mixed; boundary="===============2103605342471240026==" MIME-Version: 1.0 From: =?utf-8?q?=C3=81lvaro_Herrera?= To: pgsql-committers@lists.postgresql.org Subject: pgsql: Restructure foreign key handling code for ATTACH/DETACH X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 22 Oct 2024 14:26:01 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2103605342471240026== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVzdHJ1Y3R1cmUgZm9yZWlnbiBrZXkgaGFuZGxpbmcgY29kZSBmb3IgQVRUQUNIL0RFVEFDSAoK Li4uIHRvIGZpeCBidWdzIHdoZW4gdGhlIHJlZmVyZW5jZWQgdGFibGUgaXMgcGFydGl0aW9uZWQu CgpUaGUgY2F0YWxvZyByZXByZXNlbnRhdGlvbiB3ZSBjaG9zZSBmb3IgZm9yZWlnbiBrZXlzIGNv bm5lY3RpbmcKcGFydGl0aW9uZWQgdGFibGVzIChpbiBjb21taXQgZjU2ZjhmOGRhNmFmKSBpcyBp bmNvbnZlbmllbnQsIGluIHRoZQpzZW5zZSB0aGF0IGEgc3RhbmRhbG9uZSB0YWJsZSBoYXMgYSBk aWZmZXJlbnQgd2F5IHRvIHJlcHJlc2VudCB0aGUKY29uc3RyYWludCB3aGVuIHJlZmVyZW5jaW5n IGEgcGFydGl0aW9uZWQgdGFibGUsIHRoYW4gd2hlbiB0aGUgc2FtZQp0YWJsZSBiZWNvbWVzIGEg cGFydGl0aW9uIChhbmQgdmljZSB2ZXJzYSkuICBCZWNhdXNlIG9mIHRoaXMsIHdlIG5lZWQgdG8K Y3JlYXRlIGFkZGl0aW9uYWwgY2F0YWxvZyByb3dzIG9uIGRldGFjaCAocGdfY29uc3RyYWludCBh bmQgcGdfdHJpZ2dlciksCmFuZCByZW1vdmUgdGhlbSBvbiBhdHRhY2guICBXZSB3ZXJlIGRvaW5n IHNvbWUgb2YgdGhvc2UgdGhpbmdzLCBidXQgbm90CmFsbCBvZiB0aGVtLCBsZWFkaW5nIHRvIG1p c3NpbmcgY2F0YWxvZyByb3dzIGluIGNlcnRhaW4gY2FzZXMuCgpUaGUgd29yc3QgcHJvYmxlbSBz ZWVtcyB0byBiZSB0aGF0IHdlIGFyZSBtaXNzaW5nIGFjdGlvbiB0cmlnZ2VycyBhZnRlcgpkZXRh Y2hpbmcgYSBwYXJ0aXRpb24sIHdoaWNoIG1lYW5zIHRoYXQgeW91IGNvdWxkIHVwZGF0ZS9kZWxl dGUgcm93cwpmcm9tIHRoZSByZWZlcmVuY2VkIHBhcnRpdGlvbmVkIHRhYmxlIHRoYXQgc3RpbGwg aGFkIHJlZmVyZW5jaW5nIHJvd3Mgb24KdGhhdCB0YWJsZSwgdGhlIHNlcnZlciBmYWlsaW5nIHRv IHRocm93IHRoZSByZXF1aXJlZCBlcnJvcnMuCgohISEKTm90ZSB0aGF0IHRoaXMgbWVhbnMgZXhp c3RpbmcgZGF0YWJhc2VzIHdpdGggRktzIHRoYXQgcmVmZXJlbmNlCnBhcnRpdGlvbmVkIHRhYmxl cyBtaWdodCBoYXZlIHJvd3MgdGhhdCBicmVhayByZWxhdGlvbmFsIGludGVncml0eSwgb24KdGFi bGVzIHRoYXQgd2VyZSBvbmNlIHBhcnRpdGlvbnMgb24gdGhlIHJlZmVyZW5jaW5nIHNpZGUgb2Yg dGhlIEZLLgoKQW5vdGhlciBwb3NzaWJsZSBwcm9ibGVtIGlzIHRoYXQgdHJ5aW5nIHRvIHJlYXR0 YWNoIGEgdGFibGUKdGhhdCBoYWQgYmVlbiBkZXRhY2hlZCB3b3VsZCBmYWlsIGluZGljYXRpbmcg dGhhdCBpbnRlcm5hbCB0cmlnZ2VycwpjYW5ub3QgYmUgZm91bmQsIHdoaWNoIGZyb20gdGhlIHVz ZXIncyBwb2ludCBvZiB2aWV3IGlzIG5vbnNlbnNpY2FsLgoKSW4gYnJhbmNoZXMgMTUgYW5kIGFi b3ZlLCB3ZSBmaXggdGhpcyBieSBjcmVhdGluZyBhIG5ldyBoZWxwZXIgZnVuY3Rpb24KYWRkRmtD b25zdHJhaW50KCkgd2hpY2ggaXMgaW4gY2hhcmdlIG9mIGNyZWF0aW5nIGEgc3RhbmRhbG9uZQpw Z19jb25zdHJhaW50IHJvdywgYW5kIHJlcHVycG9zaW5nIGFkZEZrUmVjdXJzZVJlZmVyZW5jaW5n KCkgYW5kCmFkZEZrUmVjdXJzZVJlZmVyZW5jZWQoKSBzbyB0aGF0IHRoZXkncmUgb25seSB0aGUg cmVjdXJzaXZlIHJvdXRpbmUgZm9yCmVhY2ggc2lkZSBvZiB0aGUgRkssIGFuZCB0aGV5IGNhbGwg YWRkRmtDb25zdHJhaW50KCkgdG8gY3JlYXRlCnBnX2NvbnN0cmFpbnQgYXQgZWFjaCBwYXJ0aXRp b25pbmcgbGV2ZWwgYW5kIGFkZCB0aGUgbmVjZXNzYXJ5IHRyaWdnZXJzLgpUaGVzZSBuZXcgcm91 dGluZXMgY2FuIGJlIHVzZWQgZHVyaW5nIHBhcnRpdGlvbiBjcmVhdGlvbiwgcGFydGl0aW9uCmF0 dGFjaCBhbmQgZGV0YWNoLCBhbmQgZm9yZWlnbiBrZXkgY3JlYXRpb24uICBUaGlzIHJlZHVjZXMg cmVkdW5kYW50CmNvZGUgYW5kIHNpbXBsaWZpZXMgdGhlIGZsb3cuCgpJbiBicmFuY2hlcyAxNCBh bmQgMTMsIHdlIGhhdmUgYSBtdWNoIHNpbXBsZXIgZml4IHRoYXQgY29uc2lzdHMgb24Kc2ltcGx5 IHJlbW92aW5nIHRoZSBjb25zdHJhaW50IG9uIGRldGFjaC4gIFRoZSByZWFzb24gaXMgdGhhdCB0 aG9zZQpicmFuY2hlcyBhcmUgbWlzc2luZyBjb21taXQgZjQ1NjYzNDVjZjQwLCB3aGljaCByZXdv cmtlZCB0aGUgd2F5IHRoaXMKd29ya3MgaW4gYSB3YXkgdGhhdCB3ZSBkaWRuJ3QgY29uc2lkZXIg YmFjay1wYXRjaGFibGUgYXQgdGhlIHRpbWUuCgpXZSBvcHRlZCB0byBsZWF2ZSBicmFuY2ggMTIg YWxvbmUsIGJlY2F1c2UgaXQncyBkaWZmZXJlbnQgZnJvbSBicmFuY2ggMTMKZW5vdWdoIHRoYXQg dGhlIGZpeCBkb2Vzbid0IGFwcGx5OyBhbmQgYmVjYXVzZSBpdCBpcyBnb2luZyBpbiBFT0wgbW9k ZQp2ZXJ5IHNvb24sIHBhdGNoaW5nIGl0IG5vdyBtaWdodCBiZSB3b3JzZSBzaW5jZSB0aGVyZSdz IG5vIHdheSB0byB1bmRvCnRoZSBkYW1hZ2UgaWYgaXQgZ29lcyB3cm9uZy4KCkV4aXN0aW5nIGRh dGFiYXNlcyBtaWdodCBuZWVkIHRvIGJlIHJlcGFpcmVkLgoKSW4gdGhlIGZ1dHVyZSB3ZSBtaWdo dCB3YW50IHRvIHJldGhpbmsgdGhlIGNhdGFsb2cgcmVwcmVzZW50YXRpb24gdG8KYXZvaWQgdGhp cyBwcm9ibGVtLCBidXQgZm9yIG5vdyB0aGUgY29kZSBzZWVtcyB0byBkbyB3aGF0J3MgcmVxdWly ZWQgdG8KbWFrZSB0aGUgY29uc3RyYWludHMgb3BlcmF0ZSBjb3JyZWN0bHkuCgpDby1hdXRob3Jl ZC1ieTogSmVoYW4tR3VpbGxhdW1lIGRlIFJvcnRoYWlzIDxqZ2RyQGRhbGliby5jb20+CkNvLWF1 dGhvcmVkLWJ5OiBUZW5kZXIgV2FuZyA8dG5kcndhbmdAZ21haWwuY29tPgpDby1hdXRob3JlZC1i eTogQWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQGFsdmgubm8taXAub3JnPgpSZXBvcnRlZC1ieTog R3VpbGxhdW1lIExlbGFyZ2UgPGd1aWxsYXVtZUBsZWxhcmdlLmluZm8+ClJlcG9ydGVkLWJ5OiBK ZWhhbi1HdWlsbGF1bWUgZGUgUm9ydGhhaXMgPGpnZHJAZGFsaWJvLmNvbT4KUmVwb3J0ZWQtYnk6 IFRob21hcyBCYWVobGVyIChTQkIgQ0ZGIEZGUykgPHRob21hcy5iYWVobGVyMkBzYmIuY2g+CkRp c2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMjAyMzA0MjAxNDQzNDQuNDA3NDQxMzBAa2Fy c3QKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8yMDIzMDcwNTIzMzAyOC4yZjU1NGY3 M0BrYXJzdApEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0dWQVAyNzhNQjAyNzg3RTcx MzRGRDY5MTg2MTYzNUE4QkM5MDMyQEdWQVAyNzhNQjAyNzguQ0hFUDI3OC5QUk9ELk9VVExPT0su Q09NCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTg1NDEtNjI4YTYxYmMyNjdjZDJk M0Bwb3N0Z3Jlc3FsLm9yZwoKQnJhbmNoCi0tLS0tLQpSRUxfMTVfU1RBQkxFCgpEZXRhaWxzCi0t LS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi81ZDgzYmFkNmI4 N2QwZDY1ODE4YmE2MzFhMjU0ZjlhNzRmYTIwNjAxCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0t LS0tLQpzcmMvYmFja2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAgICAgICB8IDY2MSArKysr KysrKysrKysrKysrKysrLS0tLS0tLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9mb3Jl aWduX2tleS5vdXQgfCAgOTYgKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvZm9yZWlnbl9rZXku c3FsICAgICAgfCAgNTcgKysrCnNyYy90b29scy9wZ2luZGVudC90eXBlZGVmcy5saXN0ICAgICAg ICAgIHwgICAxICsKNCBmaWxlcyBjaGFuZ2VkLCA1NjUgaW5zZXJ0aW9ucygrKSwgMjUwIGRlbGV0 aW9ucygtKQoK --===============2103605342471240026==--