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 1oqg8b-0002nS-Ot for pgsql-committers@arkaria.postgresql.org; Thu, 03 Nov 2022 19:44:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oqg8a-0000v3-II for pgsql-committers@arkaria.postgresql.org; Thu, 03 Nov 2022 19:44:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oqg6J-0006HH-Gd for pgsql-committers@lists.postgresql.org; Thu, 03 Nov 2022 19:42:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oqg6E-0001Zr-Ac for pgsql-committers@lists.postgresql.org; Thu, 03 Nov 2022 19:42:06 +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-0002Fa-6x 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-000IOA-Fj for pgsql-committers@lists.postgresql.org; Thu, 03 Nov 2022 19:41:59 +0000 Content-Type: multipart/mixed; boundary="===============8431946573558691791==" 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 --===============8431946573558691791== 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 LS0tLS0KUkVMXzE0X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVz cWwub3JnL3BnL2NvbW1pdGRpZmYvMTg4NjVmNGRmOWNhMjM2OWY0MmY5OGQ1M2ZjMGU4MmUzOGI4 YTQxZAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvY29tbWFuZHMv dGFibGVjbWRzLmMgICAgICAgICAgfCA0MyArKysrKysrKysrKysrKysrKysrKysrKysrLS0tLS0t CnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZm9yZWlnbl9rZXkub3V0IHwgIDQgKy0tCjIgZmls ZXMgY2hhbmdlZCwgMzcgaW5zZXJ0aW9ucygrKSwgMTAgZGVsZXRpb25zKC0pCgo= --===============8431946573558691791==--