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 1oqg7G-0002jr-Rq for pgsql-committers@arkaria.postgresql.org; Thu, 03 Nov 2022 19:43:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oqg6G-0005qA-44 for pgsql-committers@arkaria.postgresql.org; Thu, 03 Nov 2022 19:42:04 +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 1oqg6F-0005q1-TF for pgsql-committers@lists.postgresql.org; Thu, 03 Nov 2022 19:42:03 +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 1oqg6C-0001C6-OX for pgsql-committers@lists.postgresql.org; Thu, 03 Nov 2022 19:42:02 +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 1oqg6C-0002Fc-6B for pgsql-committers@lists.postgresql.org; Thu, 03 Nov 2022 19:42:00 +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 1oqg6B-000IOG-Gk for pgsql-committers@lists.postgresql.org; Thu, 03 Nov 2022 19:41:59 +0000 Content-Type: multipart/mixed; boundary="===============6293805487138054003==" MIME-Version: 1.0 From: Alvaro Herrera To: pgsql-committers@lists.postgresql.org Subject: pgsql: Create FKs properly when attaching table as partition X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 03 Nov 2022 19:41:59 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6293805487138054003== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q3JlYXRlIEZLcyBwcm9wZXJseSB3aGVuIGF0dGFjaGluZyB0YWJsZSBhcyBwYXJ0aXRpb24KCkNv bW1pdCBmNTZmOGY4ZGE2YWYgYWRkZWQgc29tZSBjb2RlIGluIENsb25lRmtSZWZlcmVuY2luZyB0 aGF0J3Mgd2F5IHRvbwpsYXggYWJvdXQgYSBDb25zdHJhaW50IG5vZGUgaXQgbWFudWZhY3R1cmVz LCBub3QgaW5pdGlhbGl6aW5nIGVub3VnaApzdHJ1Y3QgbWVtYmVycyAtLSBpbml0aWFsbHlfdmFs aWQgaW4gcGFydGljdWxhciB3YXMgZm9yZ290dGVuLiAgVGhpcwpjYXVzZXMgc29tZSBGS3MgaW4g cGFydGl0aW9ucyBhZGRlZCBieSBBTFRFUiBUQUJMRSBBVFRBQ0ggUEFSVElUSU9OIHRvCmJlIG1h cmtlZCBhcyBub3QgdmFsaWRhdGVkLiAgU2V0IGluaXRpYWxseV92YWxpZCB0cnVlLCB3aGljaCBm aXhlcyB0aGUKYnVnLgoKV2hpbGUgYXQgaXQsIG1ha2UgdGhlIHN0cnVjdCBpbml0aWFsaXphdGlv biBtb3JlIGNvbXBsZXRlLiAgVmVyeSBzaW1pbGFyCmNvZGUgd2FzIGFkZGVkIGluIHR3byBvdGhl ciBwbGFjZXMgYnkgdGhlIHNhbWUgY29tbWl0OyBtYWtlIHRoZW0gYWxsCmZvbGxvdyB0aGUgc2Ft ZSBwYXR0ZXJuIGZvciBjb25zaXN0ZW5jeSwgdGhvdWdoIG5vIGJ1Z3MgYXJlIGFwcGFyZW50CnRo ZXJlLgoKVGhpcyBidWcgaGFzIG5ldmVyIGJlZW4gcmVwb3J0ZWQ6IEkgb25seSBoYXBwZW5lZCB0 byBub3RpY2Ugd2hpbGUKd29ya2luZyBvbiBjb21taXQgNjE0YTQwNmI0ZmYxLiAgVGhlIHRlc3Qg Y2FzZSB0aGF0IHdhcyBhZGRlZCB0aGVyZSB3aXRoCnRoZSBpbXByb3BlciByZXN1bHQgaXMgcmVw YWlyZWQuCgpCYWNrcGF0Y2ggdG8gMTIuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9t LzIwMjIxMDA1MTA1NTIzLmJodWhrZHg0b2xhamJvb2ZAYWx2aGVycmUucGdzcWwKCkJyYW5jaAot LS0tLS0KUkVMXzEyX1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVz cWwub3JnL3BnL2NvbW1pdGRpZmYvYWI3MGIzYTUyZmRlNmYwNTE5ZmM3NGYxYWFlMWQ3YWQ4OGNi MTZkZAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvY29tbWFuZHMv dGFibGVjbWRzLmMgICAgICAgICAgfCA0MyArKysrKysrKysrKysrKysrKysrKysrKysrLS0tLS0t CnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZm9yZWlnbl9rZXkub3V0IHwgIDQgKy0tCjIgZmls ZXMgY2hhbmdlZCwgMzcgaW5zZXJ0aW9ucygrKSwgMTAgZGVsZXRpb25zKC0pCgo= --===============6293805487138054003==--