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-00BUjd-2H for pgsql-committers@arkaria.postgresql.org; Tue, 22 Oct 2024 14:28:39 +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-0004zc-E6 for pgsql-committers@arkaria.postgresql.org; Tue, 22 Oct 2024 14:28:37 +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 1t3Fpn-0001oK-9n for pgsql-committers@lists.postgresql.org; Tue, 22 Oct 2024 14:26:07 +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 1t3Fpk-002P4X-Rb for pgsql-committers@lists.postgresql.org; Tue, 22 Oct 2024 14:26:07 +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-006tLi-LH 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-001v1h-Ov for pgsql-committers@lists.postgresql.org; Tue, 22 Oct 2024 14:26:01 +0000 Content-Type: multipart/mixed; boundary="===============8633005063742377017==" 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 --===============8633005063742377017== 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 M0Bwb3N0Z3Jlc3FsLm9yZwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpo dHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzUzYWY5NDkxYTA0Mzk3MjAw OTRhMTFiNzI2MDI5NTJkNzlmNTlhYzcKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNy Yy9iYWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5jICAgICAgICAgIHwgNjc1ICsrKysrKysrKysr KysrKysrKystLS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2ZvcmVpZ25fa2V5 Lm91dCB8ICA5NiArKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9mb3JlaWduX2tleS5zcWwgICAg ICB8ICA1NyArKysKc3JjL3Rvb2xzL3BnaW5kZW50L3R5cGVkZWZzLmxpc3QgICAgICAgICAgfCAg IDEgKwo0IGZpbGVzIGNoYW5nZWQsIDU3NSBpbnNlcnRpb25zKCspLCAyNTQgZGVsZXRpb25zKC0p Cgo= --===============8633005063742377017==--