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 1qgiHi-00GxmJ-CA for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Sep 2023 09:05:14 +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 1qgiHh-0078Rp-5R for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Sep 2023 09:05:12 +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 1qghxK-006zBo-Gn for pgsql-bugs@lists.postgresql.org; Thu, 14 Sep 2023 08:44:10 +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 1qghxE-004UJk-PN for pgsql-bugs@lists.postgresql.org; Thu, 14 Sep 2023 08:44:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=89Zd/i6beCSuQ/WUJN8fCejKKx1N652LCdWSDa0G7ss=; b=SXbrsQboiQKpaSx7clz2HLiPFy tBBDr5O8lzNTnXJpY8wts2NjkdxC+Ct783VEfajXCQQoqd4qCo/WEAM/buCfmQgzOgR01Pg1LDia0 /hvJan3hiKUYRq1+YbCHOP+1i73WqQL5XPRXaygQfwXTVq4vRUtAeip0Qrdv4zlmzR2lZIdCsfT+Q us8B8VhojImh2NsJsJ73jrB2tDtedOFCkKiYMRJs4iQkwlUzVB+blyVCBRE0hbI9Rqj0oXZXerGWf UWSZRmSG7U/LD4lUGEXGD9cewnsgIQFxLUU573YkQPAHUIKpa6N1Dx7xS3lPqs7Zby6gkYye0dR2q ZJ3xNY9Q==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qghxD-0008E5-Gz for pgsql-bugs@lists.postgresql.org; Thu, 14 Sep 2023 08:44:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qghxB-00EvKa-TR for pgsql-bugs@lists.postgresql.org; Thu, 14 Sep 2023 08:44:02 +0000 Content-Type: multipart/mixed; boundary="===============1171318002714790295==" MIME-Version: 1.0 Subject: BUG #18109: enable_partitionwise_aggregate does not apply when inserting or updating To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: stephen_flav@hotmail.com Reply-To: stephen_flav@hotmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 14 Sep 2023 08:43:23 +0000 Message-ID: <18109-d3ff785fb25ad31e@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1171318002714790295== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODEwOQpMb2dnZWQgYnk6ICAgICAgICAgIFN0ZXBoZW4gRmxhdmluCkVt YWlsIGFkZHJlc3M6ICAgICAgc3RlcGhlbl9mbGF2QGhvdG1haWwuY29tClBvc3RncmVTUUwgdmVy c2lvbjogMTUuMwpPcGVyYXRpbmcgc3lzdGVtOiAgIG1hY09TIFZlbnR1cmEgMTMuNC4xCkRlc2Ny aXB0aW9uOiAgICAgICAgCgpJIGhhdmUgYSBwYXJ0aXRpb25lZCB0YWJsZSB3aGljaCBjb250YWlu cyBzb21lIHJhdyBkYXRhIHRoYXQgSSBuZWVkIHRvCmFnZ3JlZ2F0ZSBhbmQgdXBzZXJ0IGludG8g YW5vdGhlciB0YWJsZSAocGFydGl0aW9uZWQgYnkgdGhlIHNhbWUga2V5KS4NClRoZSBwbGFuIGlz IHRvIGFnZ3JlZ2F0ZSB0aGUgcmF3IHRhYmxlIGF0IGEgcmVndWxhciBpbnRlcnZhbCwgd2hlbgph Z2dyZWdhdGlvbiBydW5zIEkgdXNlIGEgcHJvY2VkdXJlIHRvIHJlbmFtZSB0aGUgZXhpc3Rpbmcg cmF3IHRhYmxlIGFuZApjcmVhdGUgYSBuZXcgb25lLCB0aGlzIHN0b3BzIHdyaXRlcyBhbmQgYWxs b3cgdGhlIGFwcHMgdG8gY29udGludWUgd3JpdGluZwp3aGlsZSB0aGUgYWdncmVnYXRpb24gYW5k IHVwc2VydCBpcyBydW5uaW5nLg0KDQpUaGUgcHJvYmxlbSBJIGhhdmUgaXMgdGhlIHByb2NlZHVy ZSB0byBydW4gdGhlIGFnZ3JlZ2F0ZXMgdGFrZXMgdG9vIGxvbmcgYW5kCmFsbG93cyB0b28gbXVj aCBsYWcgdG8gYnVpbGQgdXAgc28gdGhlIHByb2NlZHVyZSBnZXQncyBzbG93ZXIgYW5kIHNsb3dl cgpvdmVyIHRpbWUuDQoNCkkndmUgYmVlbiBsb29raW5nIGF0IGBlbmFibGVfcGFydGl0aW9ud2lz ZV9hZ2dyZWdhdGVgIHdoaWNoIHNpZ25pZmljYW50bHkKaW5jcmVhc2VzIHRoZSBzcGVlZCBvZiB0 aGUgYWdncmVnYXRpb24gaG93ZXZlciwgaXQgc2VlbXMgdGhhdCB3aGVuIEkgY29tYmluZQp0aGUg c2VsZWN0IHRoYXQgbm9ybWFsbHkgbGF1bmNoZXMgdGhlIHBhcmFsbGVsIGFnZ3JlZ2F0aW9ucyBp dCdzIGZvcmNlZCB0bwpiZSBzZXF1ZW50aWFsIGV2ZW4gaWYgSSB3cmFwIHRoZSBhZ2dyZWdhdGlv biBxdWVyeSBpbiBhIG1hdGVyaWFsaXNlZCBjdGUuDQoNCnJlcGxpY2F0aW9uIHN0ZXBzOg0KYGBg DQpjcmVhdGUgdW5sb2dnZWQgdGFibGUgZGF0YXBvaW50cyAoaWQgYmlnaW50LCB0YWcgdGV4dCwg ZGF5IGRhdGUsIGNvdW50CmJpZ2ludCkgcGFydGl0aW9uIGJ5IGhhc2ggKGlkKTsNCmNyZWF0ZSB1 bmxvZ2dlZCB0YWJsZSBhZ2dyZWdhdGVkX2RhdGFwb2ludHMgKGxpa2UgZGF0YXBvaW50cywgcHJp bWFyeSBrZXkKKGlkLCB0YWcsIGRheSkpIHBhcnRpdGlvbiBieSBoYXNoIChpZCk7DQoNCi0tIGdl bmVyYXRlIHBhcnRpdGlvbnMNCmRvDQokZG8kDQogICAgZGVjbGFyZQ0KICAgICAgICBpIHNtYWxs aW50Ow0KICAgIGJlZ2luDQogICAgICAgIGZvciBpIGluIHNlbGVjdCBnZW5lcmF0ZV9zZXJpZXMo MCwgMTUpDQogICAgICAgICAgICBsb29wDQogICAgICAgICAgICAgICAgZXhlY3V0ZSAkJA0KICAg ICAgICAgICAgICAgICAgY3JlYXRlIHVubG9nZ2VkIHRhYmxlIGRhdGFwb2ludHNfJCQgfHwgaSB8 fCAkJA0KICAgICAgICAgICAgICAgICAgcGFydGl0aW9uIG9mIGRhdGFwb2ludHMNCiAgICAgICAg ICAgICAgICAgIGZvciB2YWx1ZXMgd2l0aCAobW9kdWx1cyAxNiwgcmVtYWluZGVyICQkIHx8IGkg fHwgJCQpOw0KDQoJCQkJICAgICAgICAgIGNyZWF0ZSB1bmxvZ2dlZCB0YWJsZSBhZ2dyZWdhdGVk X2RhdGFwb2ludHNfJCQgfHwgaSB8fCAkJA0KICAgICAgICAgICAgICAgICAgcGFydGl0aW9uIG9m IGFnZ3JlZ2F0ZWRfZGF0YXBvaW50cw0KICAgICAgICAgICAgICAgICAgZm9yIHZhbHVlcyB3aXRo IChtb2R1bHVzIDE2LCByZW1haW5kZXIgJCQgfHwgaSB8fCAkJCk7DQogICAgICAgICAgICAkJDsN CiAgICAgICAgICAgIGVuZCBsb29wOw0KICAgIGVuZA0KJGRvJDsNCg0Kc2V0IHdvcmtfbWVtID0g JzEyOE1CJzsNCnNldCBmb3JjZV9wYXJhbGxlbF9tb2RlID0gJ29uJzsNCnNldCBtYXhfcGFyYWxs ZWxfd29ya2VycyA9IDE2Ow0KLS0gbWF4X3dvcmtlcl9wcm9jZXNzZXMgPSAxNiAoc2V0IGluIHBv c3RncmVzcWwuY29uZiBhbmQgcmVzdGFydGVkKQ0Kc2V0IG1heF9wYXJhbGxlbF93b3JrZXJzX3Bl cl9nYXRoZXIgPSAxNjsNClNFVCBwYXJhbGxlbF9sZWFkZXJfcGFydGljaXBhdGlvbiA9ICdvZmYn Ow0Kc2V0IGVuYWJsZV9wYXJ0aXRpb253aXNlX2FnZ3JlZ2F0ZSA9ICdvbic7DQoNCmJlZ2luOw0K LS0gc2VlZCBkYXRhDQppbnNlcnQgaW50byBkYXRhcG9pbnRzDQpzZWxlY3QgDQogIChyYW5kb20o KSooMTYqMTApKTo6aW50LA0KCSgocmFuZG9tKCkqKDE2KjEwKSk6OmludCk6OnRleHQsDQoJdG9f dGltZXN0YW1wKChyYW5kb20oKSoxNik6OmludCk6OmRhdGUsDQoJKHJhbmRvbSgpKjEwMCk6Omlu dCANCmZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsIDEwMDAwMDAgKiAxNik7IC0tIDFNIHBlciBwYXJ0 aXRpb24NCi0tIElOU0VSVCAwIDE2MDAwMDAwDQotLSBUaW1lOiA3Mzk1LjI2OSBtcyAoMDA6MDcu Mzk1KQ0KDQpleHBsYWluIGFuYWx5c2Ugc2VsZWN0DQogIGlkLA0KICB0YWcsDQogIGRheSwNCiAg c3VtKGNvdW50KQ0KZnJvbSBkYXRhcG9pbnRzDQpncm91cCBieSBpZCwgdGFnLCBkYXk7DQotLSAg R2F0aGVyICAoY29zdD0yNDIxNi40OC4uMTcyNjI0LjkzIHJvd3M9MTAzOTU3MCB3aWR0aD03Nikg KGFjdHVhbAp0aW1lPTI1MC43MTguLjYwNy4xNDEgcm93cz0yNTkyMSBsb29wcz0xKQ0KLS0gICAg V29ya2VycyBQbGFubmVkOiA1DQotLSAgICBXb3JrZXJzIExhdW5jaGVkOiA1DQotLSAgICAtPiAg UGFyYWxsZWwgQXBwZW5kICAoY29zdD0yMzIxNi40OC4uNjc2NjcuOTMgcm93cz0yMDc5MTQgd2lk dGg9NzYpCihhY3R1YWwgdGltZT0yNTguOTYxLi41NzEuMTM5IHJvd3M9NTE4NCBsb29wcz01KQ0K LS0gIFBsYW5uaW5nIFRpbWU6IDEuNjUxIG1zDQotLSAgRXhlY3V0aW9uIFRpbWU6IDYyMy41NTQg bXMNCg0Kcm9sbGJhY2s7IC0tIHRvIGVuc3VyZSB0aGVyZSdzIG5vIGNhY2hpbmcgZ29pbmcgb24N Cg0KYmVnaW47DQotLSBzZWVkIGRhdGENCmluc2VydCBpbnRvIGRhdGFwb2ludHMNCnNlbGVjdCAN CiAgKHJhbmRvbSgpKigxNioxMCkpOjppbnQsDQoJKChyYW5kb20oKSooMTYqMTApKTo6aW50KTo6 dGV4dCwNCgl0b190aW1lc3RhbXAoKHJhbmRvbSgpKjE2KTo6aW50KTo6ZGF0ZSwNCgkocmFuZG9t KCkqMTAwKTo6aW50IA0KZnJvbSBnZW5lcmF0ZV9zZXJpZXMoMSwgMTAwMDAwMCAqIDE2KTsgLS0g MU0gcGVyIHBhcnRpdGlvbg0KLS0gSU5TRVJUIDAgMTYwMDAwMDANCi0tIFRpbWU6IDczOTUuMjY5 IG1zICgwMDowNy4zOTUpDQoNCmV4cGxhaW4gYW5hbHlzZSBpbnNlcnQgaW50byBhZ2dyZWdhdGVk X2RhdGFwb2ludHMNCnNlbGVjdA0KICBpZCwNCiAgdGFnLA0KICBkYXksDQogIHN1bShjb3VudCkN CmZyb20gZGF0YXBvaW50cw0KZ3JvdXAgYnkgaWQsIHRhZywgZGF5Ow0KLS0gIEluc2VydCBvbiBh Z2dyZWdhdGVkX2RhdGFwb2ludHMgIChjb3N0PTEyMDkzLjAxLi4zMTQzMzcuNjUgcm93cz0wCndp ZHRoPTApIChhY3R1YWwgdGltZT02OTczLjM1My4uNjk3My4zNjEgcm93cz0wIGxvb3BzPTEpDQot LSAgICAtPiAgU3VicXVlcnkgU2NhbiBvbiAiKlNFTEVDVCoiICAoY29zdD0xMjA5My4wMS4uMzE0 MzM3LjY1IHJvd3M9NTE2NzM0CndpZHRoPTUyKSAoYWN0dWFsIHRpbWU9Mzc5LjExMS4uNjkzOS43 MjIgcm93cz0yNTkyMSBsb29wcz0xKQ0KLS0gICAgICAgICAgLT4gIEFwcGVuZCAgKGNvc3Q9MTIw OTMuMDEuLjMwNzg3OC40OCByb3dzPTUxNjczNCB3aWR0aD03NikKKGFjdHVhbCB0aW1lPTM3OS4x MTAuLjY5MzcuOTMyIHJvd3M9MjU5MjEgbG9vcHM9MSkNCi0tICBQbGFubmluZyBUaW1lOiAwLjE2 NiBtcw0KLS0gIEV4ZWN1dGlvbiBUaW1lOiA3MDAxLjcyNSBtcw0Kcm9sbGJhY2s7DQpgYGANCnR3 byBzaWRlIHF1ZXN0aW9ucyBoZXJlOg0KIDEuIEkgY2FuJ3Qgc2VlbSB0byBnZXQgdGhlIHBhcmFs bGVsIGFnZ3JlZ2F0aW9uIHRvIHVzZSBhbGwgMTYgYXZhaWxhYmxlCndvcmtlcnMsIGlzIHRoZXJl IHNvbWUgYWRkaXRpb25hbCBjb25maWcgSSBuZWVkIHRvIGJ1bXAgaG93IG1hbnkgd29ya2Vycwp3 b3VsZCBiZSBwbGFubmVkPw0KIDIuIFRoZSBiZXN0IHNjZW5hcmlvIHdvdWxkIGJlIHRoYXQgdGhl IGluc2VydCBpdHNlbGYgd291bGQgYmUgcGFydGl0aW9ud2lzZQpzaW5jZSBib3RoIHRoZSByYXcg YW5kIGFnZ3JlZ2F0ZWQgdGFibGVzIHdpbGwgaGF2ZSB0aGUgc2FtZSBrZXlzIGluIGVhY2gKcGFy dGl0aW9uIGJ1dCBJJ20gbm90IHN1cmUgaWYgdGhhdCdzIHBvc3NpYmxlIHdpdGhvdXQgcnVubmlu ZyB0aGUgaW5zZXJ0cyBpbgpwYXJhbGxlbCBtYW51YWxseSBvbiBlYWNoIHBhcnRpdGlvbmVkIHRh YmxlPwoK --===============1171318002714790295==--