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 1n5EZe-0006QC-JN for pgsql-committers@arkaria.postgresql.org; Wed, 05 Jan 2022 22:16:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n5EZd-00042N-6g for pgsql-committers@arkaria.postgresql.org; Wed, 05 Jan 2022 22:16:01 +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 1n5EZc-00042E-RX for pgsql-committers@lists.postgresql.org; Wed, 05 Jan 2022 22:16:00 +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 1n5EZa-0004fw-9u for pgsql-committers@lists.postgresql.org; Wed, 05 Jan 2022 22:15:59 +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 1n5EZZ-0005xW-Fe for pgsql-committers@lists.postgresql.org; Wed, 05 Jan 2022 22:15:57 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n5EZY-0004Yx-SX for pgsql-committers@lists.postgresql.org; Wed, 05 Jan 2022 22:15:56 +0000 Content-Type: multipart/mixed; boundary="===============2009724566169437936==" MIME-Version: 1.0 From: Alvaro Herrera To: pgsql-committers@lists.postgresql.org Subject: pgsql: Create foreign key triggers in partitioned tables too X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 05 Jan 2022 22:15:56 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2009724566169437936== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q3JlYXRlIGZvcmVpZ24ga2V5IHRyaWdnZXJzIGluIHBhcnRpdGlvbmVkIHRhYmxlcyB0b28KCldo aWxlIHVzZXItZGVmaW5lZCB0cmlnZ2VycyBkZWZpbmVkIG9uIGEgcGFydGl0aW9uZWQgdGFibGUg aGF2ZQphIGNhdGFsb2cgZGVmaW5pdGlvbiBmb3IgYm90aCBpdCBhbmQgaXRzIHBhcnRpdGlvbnMs IGludGVybmFsCnRyaWdnZXJzIHVzZWQgYnkgZm9yZWlnbiBrZXlzIGRlZmluZWQgb24gcGFydGl0 aW9uZWQgdGFibGVzIG9ubHkKaGF2ZSBhIGNhdGFsb2cgZGVmaW5pdGlvbiBmb3IgaXRzIHBhcnRp dGlvbnMuICBUaGlzIGNvbW1pdCBmaXhlcwp0aGF0IHNvIHRoYXQgcGFydGl0aW9uZWQgdGFibGVz IGdldCB0aGUgZm9yZWlnbiBrZXkgdHJpZ2dlcnMgdG9vLApqdXN0IGxpa2UgdXNlci1kZWZpbmVk IHRyaWdnZXJzLiAgTW9yZW92ZXIsIGxpa2UgdXNlci1kZWZpbmVkCnRyaWdnZXJzLCBwYXJ0aXRp b25zJyBpbnRlcm5hbCB0cmlnZ2VycyB3aWxsIG5vdyBhbHNvIGhhdmUgdGhlaXIKdGdwYXJlbnRp ZCBzZXQgYXBwcm9wcmlhdGVseS4gIFRoaXMgaXMgdG8gYWxsb3cgc3Vic2VxdWVudCBjb21taXQo cykKdG8gbWFrZSB0aGUgZm9yZWlnbiBrZXkgcmVsYXRlZCBldmVudHMgdG8gYmUgZmlyZWQgaW4g c29tZSBjYXNlcwp1c2luZyB0aGUgcGFyZW50IHRhYmxlIHRyaWdnZXJzIGluc3RlYWQgb2YgdGhv c2Ugb2YgcGFydGl0aW9ucycuCgpUaGlzIGFsc28gY2hhbmdlcyB3aGF0IHRnaXNpbnRlcm5hbCBt ZWFucyBpbiBzb21lIGNhc2VzLiAgQ3VycmVudGx5LAppdCBtZWFucyBlaXRoZXIgdGhhdCB0aGUg dHJpZ2dlciBpcyBhbiBpbnRlcm5hbCBpbXBsZW1lbnRhdGlvbiBvYmplY3QKb2YgYSBmb3JlaWdu IGtleSBjb25zdHJhaW50LCBvciBhICJjaGlsZCIgdHJpZ2dlciBvbiBhIHBhcnRpdGlvbgpjbG9u ZWQgZnJvbSB0aGUgdHJpZ2dlciBvbiB0aGUgcGFyZW50LiAgVGhpcyBjb21taXQgY2hhbmdlcyBp dCB0bwpvbmx5IG1lYW4gdGhlIGZvcm1lciB0byBhdm9pZCBjb25mdXNpb24uICBBcyBmb3IgdGhl IGxhdHRlciwgaXQgY2FuCmJlIHRvbGQgYnkgdGdwYXJlbnRpZCBiZWluZyBub256ZXJvLCB3aGlj aCBpcyBub3cgdHJ1ZSBib3RoIGZvciB1c2VyLQpkZWZpbmVkIGFuZCBmb3JlaWduIGtleSdzIGlu dGVybmFsIHRyaWdnZXJzLgoKQXV0aG9yOiBBbWl0IExhbmdvdGUgPGFtaXRsYW5nb3RlMDlAZ21h aWwuY29tPgpSZXZpZXdlZC1ieTogTWFzYWhpa28gU2F3YWRhIDxzYXdhZGEubXNoa0BnbWFpbC5j b20+ClJldmlld2VkLWJ5OiBBcm5lIFJvbGFuZCA8QS5Sb2xhbmRAaW5kZXguZGU+CkRpc2N1c3Np b246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0ErSGl3cUc3TFFTSytuOEJraTh0V3Y3cGlIRD1Qblpy bzJ5NnlzVTItMjhKUzZjZmdRQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv ZjQ1NjYzNDVjZjQwYjA2ODM2OGNiNTYxN2U2MTMxOGRhNjA2NzZlYwoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvdGFibGVjbWRzLmMgICAgICAgfCA0 MTMgKysrKysrKysrKysrKysrKysrKysrKysrKysrLS0tLS0tCnNyYy9iYWNrZW5kL2NvbW1hbmRz L3RyaWdnZXIuYyAgICAgICAgIHwgMTAxICsrKysrKystCnNyYy9iaW4vcGdfZHVtcC9wZ19kdW1w LmMgICAgICAgICAgICAgIHwgIDQ2ICsrKy0Kc3JjL2Jpbi9wZ19kdW1wL3BnX2R1bXAuaCAgICAg ICAgICAgICAgfCAgIDIgKy0Kc3JjL2Jpbi9wc3FsL2Rlc2NyaWJlLmMgICAgICAgICAgICAgICAg fCAgMTAgKy0Kc3JjL2luY2x1ZGUvY29tbWFuZHMvdHJpZ2dlci5oICAgICAgICAgfCAgIDQgKwpz cmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3RyaWdnZXJzLm91dCB8ICAgNCArLQo3IGZpbGVzIGNo YW5nZWQsIDQ5MCBpbnNlcnRpb25zKCspLCA5MCBkZWxldGlvbnMoLSkKCg== --===============2009724566169437936==--