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 1pWYWV-0000st-A0 for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Feb 2023 08:06:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pWYWU-0003qu-6d for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Feb 2023 08:06:14 +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 1pWDpB-0007hC-8k for pgsql-bugs@lists.postgresql.org; Sun, 26 Feb 2023 10:00: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 1pWDp8-0007uZ-Bm for pgsql-bugs@lists.postgresql.org; Sun, 26 Feb 2023 10:00: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=u+MH9WWntbRYGbw85PgXu1twXQhQA4WFkqP6/pUOR1k=; b=BCtx+1pkn/TJGTpTvCl5u2SxA1 OP3Oz6MvBqaFe+wSxtnzo2iGUFMdszKrLQxl3FH5Sg04Vc9znQDjW049zCtC9mZqpCqLNelSkc+ps bYFE2XCQVvAMIduDplDY1wuhh+8Cyen33uPTPmzqzLEc0Od+D4C+64EC8rrdLVtY3UmQOm5Aq8+TD onu0nM7d3jk2bc4V6PIUB3d3kAzhaCQpBTd5zVDAo+JmA/+K0kBYrlDWnJNj6fAgFl/p70/2KKMkY 2DSqjcAFGT39jk57e8DrvjoLOLUytXYXzBlSKyZGyPPIXh2361V7i2R30k0QpiIZAkl1bhD4qvQld trNsRFmg==; 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 1pWDp7-0004NJ-DX for pgsql-bugs@lists.postgresql.org; Sun, 26 Feb 2023 10:00:05 +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 1pWDp4-002iyG-7v for pgsql-bugs@lists.postgresql.org; Sun, 26 Feb 2023 10:00:03 +0000 Content-Type: multipart/mixed; boundary="===============4110891269121008739==" MIME-Version: 1.0 Subject: BUG #17809: MERGE ... UPDATE fails with BEFORE ROW UPDATE trigger when target row updated concurrently To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 26 Feb 2023 10:00:00 +0000 Message-ID: <17809-9e6650bef133f0fe@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 --===============4110891269121008739== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzgwOQpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTUuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKV2hlbiBleGVjdXRpbmcgdGhlIGZvbGxvd2luZyBzY3JpcHQ6DQoNCmNhdCA8PCAiRU9G IiB8IHBzcWwNCkNSRUFURSBUQUJMRSB0YXJnZXQgKHRpZCBpbnRlZ2VyLCB2YWwgaW50ZWdlcik7 DQpJTlNFUlQgSU5UTyB0YXJnZXQgVkFMVUVTICgxLCAwKTsNCkNSRUFURSBPUiBSRVBMQUNFIEZV TkNUSU9OIGJydXRfZnVuYygpIFJFVFVSTlMgdHJpZ2dlciBMQU5HVUFHRSBwbHBnc3FsIEFTCidC RUdJTiBSRVRVUk4gTkVXOyBFTkQ7JzsNCkNSRUFURSBUUklHR0VSIGJydXQgQkVGT1JFIFVQREFU RSBPTiB0YXJnZXQgRk9SIEVBQ0ggUk9XIEVYRUNVVEUgUFJPQ0VEVVJFCmJydXRfZnVuYygpOw0K RU9GDQoNCmZvciAoKGk9MTtpPD0xMDtpKyspKTsgZG8NCiAgZWNobyAiaXRlcmF0aW9uICRpIg0K ICBwc3FsIC1jICJVUERBVEUgVEFSR0VUIFNFVCB2YWwgPSAwIiAmDQogIHBzcWwgLWMgIk1FUkdF IElOVE8gdGFyZ2V0IHQxIFVTSU5HIHRhcmdldCB0MiBPTiB0MS50aWQgPSB0Mi50aWQgV0hFTgpN QVRDSEVEIFRIRU4gVVBEQVRFIFNFVCB2YWwgPSAwIiAmDQogIHdhaXQNCiAgbHMgdG1wZGIvY29y ZSogJiYgYnJlYWsNCiAgY29yZWR1bXBjdGwgLS1uby1wYWdlciAmJiBicmVhaw0KZG9uZQ0KDQpJ IGdldCBhIHNlcnZlciBjcmFzaCB3aXRoIHRoZSBmb2xsb3dpbmcgc3RhY2sgdHJhY2U6DQpQcm9n cmFtIHRlcm1pbmF0ZWQgd2l0aCBzaWduYWwgU0lHU0VHViwgU2VnbWVudGF0aW9uIGZhdWx0Lg0K DQp3YXJuaW5nOiBTZWN0aW9uIGAucmVnLXhzdGF0ZS8xODA4MjU4JyBpbiBjb3JlIGZpbGUgdG9v IHNtYWxsLg0KIzAgIDB4MDAwMDU1ZTY2NDkwNDQwZSBpbiBpbnRlcm5hbEdldFVwZGF0ZU5ld1R1 cGxlIChyZWxpbmZvPTB4NTVlNjY1OTVlMDQwLApwbGFuU2xvdD0weDU1ZTY2NTk5ODI4OCwgDQog ICAgb2xkU2xvdD0weDU1ZTY2NTk2OTk3OCwgcmVsYWN0aW9uPTB4MCkgYXQgbm9kZU1vZGlmeVRh YmxlLmM6NzQxDQo3NDEgICAgICAgICAgICAgZWNvbnRleHQgPSBuZXdQcm9qLT5waV9leHByQ29u dGV4dDsNCihnZGIpIGJ0DQojMCAgMHgwMDAwNTVlNjY0OTA0NDBlIGluIGludGVybmFsR2V0VXBk YXRlTmV3VHVwbGUgKHJlbGluZm89MHg1NWU2NjU5NWUwNDAsCnBsYW5TbG90PTB4NTVlNjY1OTk4 Mjg4LCANCiAgICBvbGRTbG90PTB4NTVlNjY1OTY5OTc4LCByZWxhY3Rpb249MHgwKSBhdCBub2Rl TW9kaWZ5VGFibGUuYzo3NDENCiMxICAweDAwMDA1NWU2NjQ5MDQzZTAgaW4gRXhlY0dldFVwZGF0 ZU5ld1R1cGxlIChyZWxpbmZvPTB4NTVlNjY1OTVlMDQwLApwbGFuU2xvdD0weDU1ZTY2NTk5ODI4 OCwgDQogICAgb2xkU2xvdD0weDU1ZTY2NTk2OTk3OCkgYXQgbm9kZU1vZGlmeVRhYmxlLmM6NzI2 DQojMiAgMHgwMDAwNTVlNjY0ODdlODM1IGluIEV4ZWNCUlVwZGF0ZVRyaWdnZXJzIChlc3RhdGU9 MHg1NWU2NjU5NWRiYTAsCmVwcXN0YXRlPTB4NTVlNjY1OTVkZjEwLCANCiAgICByZWxpbmZvPTB4 NTVlNjY1OTVlMDQwLCB0dXBsZWlkPTB4N2ZmZWM5MzM1MDAyLCBmZHdfdHJpZ3R1cGxlPTB4MCwK bmV3c2xvdD0weDU1ZTY2NTk2OTc0OCwgdG1mZD0weDdmZmVjOTMzNTBiMCkNCiAgICBhdCB0cmln Z2VyLmM6MzAzNw0KIzMgIDB4MDAwMDU1ZTY2NDkwNjIyZSBpbiBFeGVjVXBkYXRlUHJvbG9ndWUg KGNvbnRleHQ9MHg3ZmZlYzkzMzUwODAsCnJlc3VsdFJlbEluZm89MHg1NWU2NjU5NWUwNDAsIA0K ICAgIHR1cGxlaWQ9MHg3ZmZlYzkzMzUwMDIsIG9sZHR1cGxlPTB4MCwgc2xvdD0weDU1ZTY2NTk2 OTc0OCkgYXQKbm9kZU1vZGlmeVRhYmxlLmM6MTkxMg0KIzQgIDB4MDAwMDU1ZTY2NDkwNzhiMiBp biBFeGVjTWVyZ2VNYXRjaGVkIChjb250ZXh0PTB4N2ZmZWM5MzM1MDgwLApyZXN1bHRSZWxJbmZv PTB4NTVlNjY1OTVlMDQwLCANCiAgICB0dXBsZWlkPTB4N2ZmZWM5MzM1MDAyLCBjYW5TZXRUYWc9 dHJ1ZSkgYXQgbm9kZU1vZGlmeVRhYmxlLmM6Mjg4NA0KIzUgIDB4MDAwMDU1ZTY2NDkwNzVkYSBp biBFeGVjTWVyZ2UgKGNvbnRleHQ9MHg3ZmZlYzkzMzUwODAsCnJlc3VsdFJlbEluZm89MHg1NWU2 NjU5NWUwNDAsIHR1cGxlaWQ9MHg3ZmZlYzkzMzUwMDIsIA0KICAgIGNhblNldFRhZz10cnVlKSBh dCBub2RlTW9kaWZ5VGFibGUuYzoyNzUwDQojNiAgMHgwMDAwNTVlNjY0OTA5N2YyIGluIEV4ZWNN b2RpZnlUYWJsZSAocHN0YXRlPTB4NTVlNjY1OTVkZTI4KSBhdApub2RlTW9kaWZ5VGFibGUuYzoz ODY2DQojNyAgMHgwMDAwNTVlNjY0OGM2MGQ3IGluIEV4ZWNQcm9jTm9kZUZpcnN0IChub2RlPTB4 NTVlNjY1OTVkZTI4KSBhdApleGVjUHJvY25vZGUuYzo0NjQNCiM4ICAweDAwMDA1NWU2NjQ4Yjkz NTMgaW4gRXhlY1Byb2NOb2RlIChub2RlPTB4NTVlNjY1OTVkZTI4KSBhdAouLi8uLi8uLi9zcmMv aW5jbHVkZS9leGVjdXRvci9leGVjdXRvci5oOjI1OQ0KIzkgIDB4MDAwMDU1ZTY2NDhiYzI1YSBp biBFeGVjdXRlUGxhbiAoZXN0YXRlPTB4NTVlNjY1OTVkYmEwLApwbGFuc3RhdGU9MHg1NWU2NjU5 NWRlMjgsIHVzZV9wYXJhbGxlbF9tb2RlPWZhbHNlLCANCiAgICBvcGVyYXRpb249Q01EX01FUkdF LCBzZW5kVHVwbGVzPWZhbHNlLCBudW1iZXJUdXBsZXM9MCwKZGlyZWN0aW9uPUZvcndhcmRTY2Fu RGlyZWN0aW9uLCBkZXN0PTB4NTVlNjY1OTU1YmY4LCANCiAgICBleGVjdXRlX29uY2U9dHJ1ZSkg YXQgZXhlY01haW4uYzoxNjM2DQojMTAgMHgwMDAwNTVlNjY0OGI5YThhIGluIHN0YW5kYXJkX0V4 ZWN1dG9yUnVuIChxdWVyeURlc2M9MHg1NWU2NjU5NGM5NjAsCmRpcmVjdGlvbj1Gb3J3YXJkU2Nh bkRpcmVjdGlvbiwgY291bnQ9MCwgDQogICAgZXhlY3V0ZV9vbmNlPXRydWUpIGF0IGV4ZWNNYWlu LmM6MzYzDQojMTEgMHgwMDAwNTVlNjY0OGI5ODc1IGluIEV4ZWN1dG9yUnVuIChxdWVyeURlc2M9 MHg1NWU2NjU5NGM5NjAsCmRpcmVjdGlvbj1Gb3J3YXJkU2NhbkRpcmVjdGlvbiwgY291bnQ9MCwg DQogICAgZXhlY3V0ZV9vbmNlPXRydWUpIGF0IGV4ZWNNYWluLmM6MzA3DQojMTIgMHgwMDAwNTVl NjY0YjMxOTUyIGluIFByb2Nlc3NRdWVyeSAocGxhbj0weDU1ZTY2NTk1NWIwOCwgDQogICAgc291 cmNlVGV4dD0weDU1ZTY2NTg1OTNiMCAiTUVSR0UgSU5UTyB0YXJnZXQgdDEgVVNJTkcgdGFyZ2V0 IHQyIE9OCnQxLnRpZCA9IHQyLnRpZCBXSEVOIE1BVENIRUQgVEhFTiBVUERBVEUgU0VUIHZhbCA9 IDAiLCBwYXJhbXM9MHgwLApxdWVyeUVudj0weDAsIGRlc3Q9MHg1NWU2NjU5NTViZjgsIHFjPTB4 N2ZmZWM5MzM1NGUwKSBhdCBwcXVlcnkuYzoxNjANCiMxMyAweDAwMDA1NWU2NjRiMzM1NDUgaW4g UG9ydGFsUnVuTXVsdGkgKHBvcnRhbD0weDU1ZTY2NThkNTE5MCwKaXNUb3BMZXZlbD10cnVlLCBz ZXRIb2xkU25hcHNob3Q9ZmFsc2UsIA0KICAgIGRlc3Q9MHg1NWU2NjU5NTViZjgsIGFsdGRlc3Q9 MHg1NWU2NjU5NTViZjgsIHFjPTB4N2ZmZWM5MzM1NGUwKSBhdApwcXVlcnkuYzoxMjc3DQojMTQg MHgwMDAwNTVlNjY0YjMyYTI4IGluIFBvcnRhbFJ1biAocG9ydGFsPTB4NTVlNjY1OGQ1MTkwLApj b3VudD05MjIzMzcyMDM2ODU0Nzc1ODA3LCBpc1RvcExldmVsPXRydWUsIHJ1bl9vbmNlPXRydWUs IA0KICAgIGRlc3Q9MHg1NWU2NjU5NTViZjgsIGFsdGRlc3Q9MHg1NWU2NjU5NTViZjgsIHFjPTB4 N2ZmZWM5MzM1NGUwKSBhdApwcXVlcnkuYzo3OTENCiMxNSAweDAwMDA1NWU2NjRiMmI4MDMgaW4g ZXhlY19zaW1wbGVfcXVlcnkgKA0KICAgIHF1ZXJ5X3N0cmluZz0weDU1ZTY2NTg1OTNiMCAiTUVS R0UgSU5UTyB0YXJnZXQgdDEgVVNJTkcgdGFyZ2V0IHQyIE9OCnQxLnRpZCA9IHQyLnRpZCBXSEVO IE1BVENIRUQgVEhFTiBVUERBVEUgU0VUIHZhbCA9IDAiKSBhdCBwb3N0Z3Jlcy5jOjEyNTANCiMx NiAweDAwMDA1NWU2NjRiMzA3MjIgaW4gUG9zdGdyZXNNYWluIChkYm5hbWU9MHg1NWU2NjU4ODU5 MzggInJlZ3Jlc3Npb24iLAp1c2VybmFtZT0weDU1ZTY2NTg4NTkxOCAibGF3IikNCiAgICBhdCBw b3N0Z3Jlcy5jOjQ1OTMNCiMxNyAweDAwMDA1NWU2NjRhNTVjMjMgaW4gQmFja2VuZFJ1biAocG9y dD0weDU1ZTY2NTg3ZDQyMCkgYXQKcG9zdG1hc3Rlci5jOjQ1MTENCiMxOCAweDAwMDA1NWU2NjRh NTU0YWEgaW4gQmFja2VuZFN0YXJ0dXAgKHBvcnQ9MHg1NWU2NjU4N2Q0MjApIGF0CnBvc3RtYXN0 ZXIuYzo0MjM5DQojMTkgMHgwMDAwNTVlNjY0YTUxNDM3IGluIFNlcnZlckxvb3AgKCkgYXQgcG9z dG1hc3Rlci5jOjE4MDYNCiMyMCAweDAwMDA1NWU2NjRhNTBiOTQgaW4gUG9zdG1hc3Rlck1haW4g KGFyZ2M9MywgYXJndj0weDU1ZTY2NTg1MzYxMCkgYXQKcG9zdG1hc3Rlci5jOjE0NzgNCiMyMSAw eDAwMDA1NWU2NjQ5NDRhZDUgaW4gbWFpbiAoYXJnYz0zLCBhcmd2PTB4NTVlNjY1ODUzNjEwKSBh dCBtYWluLmM6MjAyDQoNCkF0IGZpcnN0IHNpZ2h0IGl0IGFwcGVhcmVkIGxpa2UgYW5vdGhlciBt YW5pZmVzdGF0aW9uIG9mIGJ1ZyAjMTc3OTgsDQpidXQgaXQgc2VlbXMgdGhhdCB0aGlzIGlzIGEg ZGlzdGluY3QgZGVmZWN0Lg0KDQpBcyBJIGNhbiBzZWUsIEV4ZWNNb2RpZnlUYWJsZSgpIGZvciB0 aGUgImNhc2UgQ01EX01FUkdFIiBjYW4gcGFzcyB0bw0KRXhlY01lcmdlKCkgdGhlIHJlc3VsdFJl bEluZm8gc3RydWN0dXJlIHdpdGggcmlfcHJvamVjdE5ldyA9PSBudWxsDQooYnV0IHJpX3Byb2pl Y3ROZXdJbmZvVmFsaWQgPT0gdHJ1ZSAoc2V0IGluIEV4ZWNJbml0TWVyZ2VUdXBsZVNsb3RzKSku DQpUaGlzIGlzIG5vdCBhbiBpc3N1ZSB0aWxsIEdldFR1cGxlRm9yVHJpZ2dlcigpIGluIEV4ZWNC UlVwZGF0ZVRyaWdnZXJzKCkNCmdldHMgYSB0dXBsZS4gQnV0IHdoZW4gYSBjb25jdXJyZW50IHVw ZGF0ZSBvY2N1cnMsIEdldFR1cGxlRm9yVHJpZ2dlcigpDQpmYWlscyBhbmQgRXhlY0dldFVwZGF0 ZU5ld1R1cGxlKCkgZ2V0cyBjYWxsZWQsIHdoZXJlDQppbnRlcm5hbEdldFVwZGF0ZU5ld1R1cGxl KCkgdHJpZXMgdG8gZ2V0CnJlbGluZm8tPnJpX3Byb2plY3ROZXctPnBpX2V4cHJDb250ZXh0Li4u DQoNClRoZSBpc3N1ZSBhcHBlYXJlZCB3aXRoIHRoZSBNRVJHRSBpbnRyb2R1Y3Rpb24gKDcxMDNl YmI3YSkuCgo= --===============4110891269121008739==--