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 1kts1b-0002Zu-Dd for pgsql-bugs@arkaria.postgresql.org; Mon, 28 Dec 2020 12:53:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kts1a-00089q-Bs for pgsql-bugs@arkaria.postgresql.org; Mon, 28 Dec 2020 12:53:22 +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 1ktryT-0007yS-EO for pgsql-bugs@lists.postgresql.org; Mon, 28 Dec 2020 12:50:09 +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 1ktryR-0006lL-A6 for pgsql-bugs@lists.postgresql.org; Mon, 28 Dec 2020 12:50:08 +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=QnfZn/rRw988eJumfD7c0SSs9kSOt2SgMqyihas8B1c=; b=Q5AP4Uwa25BTYxZC96+sFjYkDS KNGrhJzt2mnhnZFnl0hU7yNGsCWsdJX/r7vqPJNyPWuFYVqcxa9xv1Pk8DAo0izcP2WqccpsuUldj TYjP8Tq7S9UEgShm69pn2Yoo5Iy6VrVEhkortSM8n7f6liw3p/pcnFGJvCTl2ueY1vZ0GPaDzESSo 6u1GOfH5Rc6l3K4nRr3W2qRX1vfU00YHpeTKyBP6III3qolkOrJVm9sH1WXQH/DqeTvsOQXcpEfc4 HqkA5WH+LY98mkiucAdo1T3N2DKrV885z0/2GY9uM62xF8TUb10MdmsPT9Rh0bJjviR15jp69N40f 4QLjvJ4w==; 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 1ktryQ-0001Vb-8N for pgsql-bugs@lists.postgresql.org; Mon, 28 Dec 2020 12:50:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ktryM-000502-Oa for pgsql-bugs@lists.postgresql.org; Mon, 28 Dec 2020 12:50:02 +0000 Content-Type: multipart/mixed; boundary="===============1410008703509620262==" MIME-Version: 1.0 Subject: BUG #16794: BEFORE UPDATE FOR EACH ROW triggers on partitioned tables can break tuple moving UPDATEs To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: pg@pmenke.de Reply-To: pg@pmenke.de, pgsql-bugs@lists.postgresql.org Date: Mon, 28 Dec 2020 12:49:43 +0000 Message-ID: <16794-350a655580fbb9ae@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1410008703509620262== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjc5NApMb2dnZWQgYnk6ICAgICAgICAgIFBoaWxpcHAgTWVua2UKRW1h aWwgYWRkcmVzczogICAgICBwZ0BwbWVua2UuZGUKUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMy4xCk9w ZXJhdGluZyBzeXN0ZW06ICAgTGludXgKRGVzY3JpcHRpb246ICAgICAgICAKCkhpIHRoZXJlLA0K DQppIHdhcyB0ZXN0aW5nIHRoZSBQRzEzIGVuaGFuY2VtZW50IHRoYXQgc2hvdWxkIGFsbG93IEJF Rk9SRSBST1cgdHJpZ2dlcnMgb24KcGFydGl0aW9uZWQgdGFibGVzLCBhcyBsb25nIGFzIHRoZXkg ZG9uJ3QgbW92ZSB0aGUgdHVwbGUgdG8gYSBkaWZmZXJlbnQKcGFydGl0aW9uIChvcmlnaW5hbCB0 aHJlYWQ6Cmh0dHBzOi8vcG9zdGdyLmVzL20vMjAyMDAyMjcxNjUxNTguR0EyMDcxQGFsdmhlcnJl LnBnc3FsKS4gVGhlIGFjdHVhbApyZXN0cmljdGlvbiBvbiAibm90IHRvIG1vdmUgdGhlIHR1cGxl IHRvIGEgZGlmZmVyZW50IHBhcnRpdGlvbiIgc2VlbXMgdG8gYmUKYSBiaXQgc3Ryb25nZXIgdGhv dWdoLCBhcyB0aGUgdHJpZ2dlciBmYWlscywgZXZlbiB0aG91Z2ggbm90IGl0c2VsZiwgYnV0IHRo ZQpvdmVyYXJjaGluZyBVUERBVEUgY29tbWFuZCwgZGlkIG1vdmUgdGhlIHR1cGxlLiBNYXliZSB0 aGlzIGlzIGJlc3Qgc2hvd24gYnkKYW4gZXhhbXBsZToNCg0KYGBgDQpDUkVBVEUgVEFCTEUgcGFy dGVkICgNCiAgICBwYXJ0X2tleSBJTlQsDQogICAgY2hhbmdlZF9hdCBUSU1FU1RBTVBUWiBERUZB VUxUIG5vdygpDQopIFBBUlRJVElPTiBCWSBSQU5HRShwYXJ0X2tleSk7DQoNCkNSRUFURSBUQUJM RSBwYXJ0ZWRfcDBfOSBQQVJUSVRJT04gT0YgcGFydGVkIEZPUiBWQUxVRVMgRlJPTSAoMCkgVE8g KDkpOw0KQ1JFQVRFIFRBQkxFIHBhcnRlZF9wMTBfMTkgUEFSVElUSU9OIE9GIHBhcnRlZCBGT1Ig VkFMVUVTIEZST00gKDEwKSBUTwooMTkpOw0KDQpDUkVBVEUgRlVOQ1RJT04gcGFydGVkX2F1ZGl0 X3RyaWcoKSBSRVRVUk5TIFRSSUdHRVIgTEFOR1VBR0UgcGxwZ3NxbCBBUyAkJA0KQkVHSU4NCiAg ICBORVcuY2hhbmdlZF9hdCA9IG5vdygpOw0KICAgIFJFVFVSTiBORVc7DQpFTkQ7DQokJDsNCg0K Q1JFQVRFIFRSSUdHRVIgYTAxX2F1ZGl0X3RyaWcgQkVGT1JFIFVQREFURSBPTiBwYXJ0ZWQgRk9S IEVBQ0ggUk9XIEVYRUNVVEUKUFJPQ0VEVVJFIHBhcnRlZF9hdWRpdF90cmlnKCk7DQoNCklOU0VS VCBJTlRPIHBhcnRlZChwYXJ0X2tleSkgVkFMVUVTICgxKTsNCg0KVVBEQVRFIHBhcnRlZCBTRVQg cGFydF9rZXkgPSAxMSBXSEVSRSBwYXJ0X2tleSA9IDE7DQpgYGANCg0KVGhlIGZpbmFsIFVQREFU RSBzdGF0ZW1lbnQgZmFpbHMgd2l0aDoNCmBgYA0KWzBBMDAwXSBFUlJPUjogbW92aW5nIHJvdyB0 byBhbm90aGVyIHBhcnRpdGlvbiBkdXJpbmcgYSBCRUZPUkUgdHJpZ2dlciBpcwpub3Qgc3VwcG9y dGVkDQpEZXRhaWw6IEJlZm9yZSBleGVjdXRpbmcgdHJpZ2dlciAiYTAxX2F1ZGl0X3RyaWciLCB0 aGUgcm93IHdhcyB0byBiZSBpbgpwYXJ0aXRpb24gInB1YmxpYy5wYXJ0ZWRfcDBfOSIuDQpgYGAN Cg0KQXQgbGVhc3QgYWNjb3JkaW5nIHRvIHRoZSBkb2N1bWVudGF0aW9uCihodHRwczovL3d3dy5w b3N0Z3Jlc3FsLm9yZy9kb2NzLzEzL2RkbC1wYXJ0aXRpb25pbmcuaHRtbCA1LjExLjIuMy4KTGlt aXRhdGlvbnMpIGkgd291bGQgaGF2ZSBleHBlY3RlZCB0aGF0IHRoZSBVUERBVEUgc3VjY2VlZHMg YW5kIG1vdmVzIHRoZQp0dXBsZSB0byBwYXJ0ZWRfcDEwXzE5Lg0KDQpJbnRlcmVzdGluZ2x5IHRo ZSBlcnJvciBzZWVtcyB0byBvbmx5IG9jY3VyIGlmIHRoZSB0cmlnZ2VyIGZ1bmN0aW9uIGFjdHVh bGx5CmFzc2lnbnMgYSB2YWx1ZSB0byBhbnkgZmllbGQgaW4gTkVXIC0gZXZlbiBpZiBpdCBpcyB0 aGUgc2FtZSB2YWx1ZSAoYXMgaW4KYE5FVy5jaGFuZ2VkX2F0ID0gTkVXLmNoYW5nZWRfYXQ7YCku IElmIHRoZSB0cmlnZ2VyIGZ1bmN0aW9uIGRvZXMgbm90aGluZyAvCnBlcmZvcm1zIGNoZWNrcyBl dGMuIGJ1dCBkb2Vzbid0IGFzc2lnbiBhbnkgZmllbGQgaW4gTkVXLCB0aGUgc3RhdGVtZW50CmNv bXBsZXRlcyBzdWNjZXNzZnVsbHkuDQoNClRoYW5rcyBhbmQgS2luZCBSZWdhcmRzLA0KUGhpbGlw cAoK --===============1410008703509620262==--