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 1kmnsN-0005vE-EE for pgsql-bugs@arkaria.postgresql.org; Wed, 09 Dec 2020 01:02:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kmnsL-0003R7-UA for pgsql-bugs@arkaria.postgresql.org; Wed, 09 Dec 2020 01:02:37 +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 1kmnJ9-0007NB-6W for pgsql-bugs@lists.postgresql.org; Wed, 09 Dec 2020 00:26:15 +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 1kmnJ2-0001W4-30 for pgsql-bugs@lists.postgresql.org; Wed, 09 Dec 2020 00:26:14 +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=cnxmeP4Sh3CfFNeePOu9djc+0vBU+AXx5hUzxQzr/JU=; b=oROMgJZtNGxIl0b7P7jvRMVXJi OIJGgmMGayHFo6HJ6FpFkLJZy+27UFE/l4tBv07A/E4xDH7h+1pTMT1NOtLlncJ+bU89kRJbcdpaN IURpb0sJshOrNDrj6sZXBOYNmuioHgRvXUPivBbH4zQ+Ke0PB+rCdlhJZoudKGnWlWN8RytvP8y/B 27yfSJDatBHasLc5gl506Uj5qw3Xf4L3djVi9heCu4XhK7jm8ismtJIEiwirSdkaXH5LzYkC20KyC wk7jnb1yOI3KC98pbxYMZ+ye9s4QtAwkQuZkohVToKVnpYw5AjPRUT7SW5e0IAq+dpAflro+lvvyJ u9CiO7wQ==; 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 1kmnJ0-0004Re-0x for pgsql-bugs@lists.postgresql.org; Wed, 09 Dec 2020 00:26: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 1kmnIw-0004bW-FC for pgsql-bugs@lists.postgresql.org; Wed, 09 Dec 2020 00:26:02 +0000 Content-Type: multipart/mixed; boundary="===============8378605330288411498==" MIME-Version: 1.0 Subject: BUG #16768: PostgreSQL 12.5 - INSERT ON CONFLICT succeeds on data INSERT but does nothing on UPDATE To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: theqacollective@gmail.com Reply-To: theqacollective@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 09 Dec 2020 00:25:26 +0000 Message-ID: <16768-4e70d7552fe05f17@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 --===============8378605330288411498== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjc2OApMb2dnZWQgYnk6ICAgICAgICAgIEFuZHJldyBICkVtYWlsIGFk ZHJlc3M6ICAgICAgdGhlcWFjb2xsZWN0aXZlQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDEyLjUKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eCBNaW50IDIwIChVbHlhbmEpCkRlc2NyaXB0 aW9uOiAgICAgICAgCgpIZWxsbywNCg0KSSBoYXZlIGhhZCBjb2RlIHJ1bm5pbmcgZm9yIDMgbW9u dGhzIG9yIHNvIHdoaWNoIHVzZXMgdGhlIElOU0VSVCAuLi4gT04KQ09ORkxJQ1QgLi4uIFVQREFU RSBmZWF0dXJlLiAgSW4gdGhlIGxhc3Qgd2VlayBvciBzbywgYSB1c2VyIGhhcyBub3RpY2VkCnRo YXQgZGF0YSBpcyBubyBsb25nZXIgYmVpbmcgdXBkYXRlZCBhcyBleHBlY3RlZC4gIEF0IGZpcnN0 LCBJIHN1c3BlY3RlZCBhbgplcnJvciBpbiBteSBjb2RlLCBvciBwZXJoYXBzIGluIHRoZSBPUk0g SSBhbSB1c2luZyB0byBhY2Nlc3MgUG9zdGdyZVNRTAooUGVlV2VlOiBodHRwOi8vZG9jcy5wZWV3 ZWUtb3JtLmNvbS9lbi9sYXRlc3QvKS4gIEhvd2V2ZXIsIGFmdGVyIGNyZWF0aW5nIGEKbmV3IGRh dGFiYXNlLCBuZXcgc2NoZW1hIGFuZCB0ZXN0IHRhYmxlIGFuZCBydW5uaW5nIElOU0VSVCBTUUwg b24gaXQsIHRoZQpzYW1lIHByb2JsZW0gcGVyc2lzdHMuICBUaGF0IGlzLCBpZiB0aGUgZGF0YWJh c2UgbmVlZHMgdG8gcnVuIGFuIElOU0VSVCAtCnRoYXQgc3VjY2VlZHMgdG8gaW5zZXJ0IGEgcm93 LiAgSG93ZXZlciwgaWYgdGhlIHJvdyBhbHJlYWR5IGV4aXN0cywgdGhlClVQREFURSBkb2Vzbid0 IGhhcHBlbiAtIGFuZCBzaG93cyBubyBzaWduIG9mIGZhaWxpbmcuICBUaGUgcXVlcnkgcmV0dXJu cwpzdWNjZXNzLiAgVGhlcmUgYXJlIG5vIGVycm9ycyBpbiBwb3N0Z3Jlc3FsLTEyLW1haW4ubG9n LiAgSXQgaXMgYSB2ZXJ5CnNpbGVudCBmYWlsdXJlLCB1bmxlc3MgSSdtIG1pc3Npbmcgc29tZXRo aW5nLiAgSSBzdXNwZWN0IGl0IG1heSBoYXZlIGJlZW4KdGhlIHVwZ3JhZGUgdG8gUG9zdGdyZVNR TCAxMi41LCBidXQgSSd2ZSBub3QgeWV0IGhhZCB0aGUgdGltZSBvciBndXRzIHRvCmRvd25ncmFk ZSB0byB0ZXN0IHRoaXMuDQoNCkkgYW0gcnVubmluZzogIlBvc3RncmVTUUwgMTIuNSAoVWJ1bnR1 IDEyLjUtMHVidW50dTAuMjAuMDQuMSkgb24KeDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQg YnkgZ2NjIChVYnVudHUgOS4zLjAtMTd1YnVudHUxfjIwLjA0KSA5LjMuMCwKNjQtYml0Ig0KDQpB Y2NvcmRpbmcgdG8gZHBrZyBsb2dzLCB0aGVzZSB3ZXJlIGluc3RhbGxlZCAxLzEyLzIwMjA6DQpk cGtnLmxvZy4xOjIwMjAtMTItMDEgMTg6MTg6MDcgdXBncmFkZSBwb3N0Z3Jlc3FsLWNsaWVudC0x MjphbWQ2NAoxMi40LTB1YnVudHUwLjIwLjA0LjEgMTIuNS0wdWJ1bnR1MC4yMC4wNC4xDQpkcGtn LmxvZy4xOjIwMjAtMTItMDEgMTg6MTg6MDcgdXBncmFkZSBwb3N0Z3Jlc3FsLTEyOmFtZDY0CjEy LjQtMHVidW50dTAuMjAuMDQuMSAxMi41LTB1YnVudHUwLjIwLjA0LjENCg0KSSBhbHNvIGhhdmUg dGltZXNjYWxlZGItMS43LjQgZXh0ZW5zaW9uIGluc3RhbGxlZCwgYnV0IEkgaGF2ZSB0ZXN0ZWQg dGhpcwpidWcgb24gYW4gZW50aXJlbHkgbmV3IGRhdGFiYXNlIHdpdGhvdXQgdGhhdCBleHRlbnNp b24gZW5hYmxlZC4NCg0KSSBoYXZlIGNoZWNrZWQgL3Zhci9sb2cvcG9zdGdyZXNxbC9wb3N0Z3Jl c3FsLTEyLW1haW4ubG9nIGFuZCB0aGlzIGRvZXNuJ3QKY29udGFpbiBhbnl0aGluZyBzdXNwaWNp b3VzIG9yIGFueXRoaW5nIHRoYXQgZGlyZWN0bHkgcmVsYXRlcyB0byB0aGUgU1FMCmJlbG93Lg0K DQpUaGUgU1FMIGJlbG93IHJlY3JlYXRlcyBteSBpc3N1ZS4gIFRoYXQgaXMsIHRoZSBMQVNUIGlu c2VydCBzdGF0ZW1lbnQgRE9FUwpOT1QgdXBkYXRlIHRoZSBhY2NvdW50aW5mb190ZXN0IHRhYmxl IHZhbHVlIGZvciAnYmFsYW5jZScgdG8gMjAwLjAgLi4uIGl0CnJlbWFpbnMgYXQgdGhlIHByZXZp b3VzIHZhbHVlIG9mIDEwMC4wLg0KDQpDUkVBVEUgREFUQUJBU0UgdGVzdA0KICAgIFdJVEggDQog ICAgT1dORVIgPSBwb3N0Z3Jlcw0KICAgIEVOQ09ESU5HID0gJ1VURjgnDQogICAgTENfQ09MTEFU RSA9ICdlbl9BVS5VVEYtOCcNCiAgICBMQ19DVFlQRSA9ICdlbl9BVS5VVEYtOCcNCiAgICBUQUJM RVNQQUNFID0gcGdfZGVmYXVsdA0KICAgIENPTk5FQ1RJT04gTElNSVQgPSAtMTsNCg0KLS0tLQ0K DQpDUkVBVEUgU0NIRU1BIHRlc3Rfc2NoZW1hDQogICAgQVVUSE9SSVpBVElPTiBwb3N0Z3JlczsN Cg0KLS0tLQ0KDQotLURST1AgVEFCTEUgdGVzdF9zY2hlbWEuYWNjb3VudGluZm9fdGVzdDsNCg0K Q1JFQVRFIFRBQkxFIHRlc3Rfc2NoZW1hLmFjY291bnRpbmZvX3Rlc3QNCigNCiAgICBsb2dpbiBp bnRlZ2VyIE5PVCBOVUxMLA0KICAgIGJhbGFuY2UgcmVhbCBOT1QgTlVMTCwNCiAgICBDT05TVFJB SU5UIGFjY291bnRpbmZvX3Rlc3RfcGtleSBQUklNQVJZIEtFWSAobG9naW4pDQopDQoNClRBQkxF U1BBQ0UgcGdfZGVmYXVsdDsNCg0KQUxURVIgVEFCTEUgdGVzdF9zY2hlbWEuYWNjb3VudGluZm9f dGVzdA0KICAgIE9XTkVSIHRvIGF1dG9fdHJhZGVyOw0KDQpHUkFOVCBBTEwgT04gVEFCTEUgdGVz dF9zY2hlbWEuYWNjb3VudGluZm9fdGVzdCBUTyBhdXRvX3RyYWRlcjsNCg0KR1JBTlQgU0VMRUNU IE9OIFRBQkxFIHRlc3Rfc2NoZW1hLmFjY291bnRpbmZvX3Rlc3QgVE8gdmlld2VyOw0KDQotLS0t DQoNCklOU0VSVCBJTlRPICJ0ZXN0X3NjaGVtYSIuImFjY291bnRpbmZvX3Rlc3QiICgibG9naW4i LCAiYmFsYW5jZSIpIFZBTFVFUwooMjAwMCwgMTAwLjApIE9OIENPTkZMSUNUICgibG9naW4iKSBE TyBVUERBVEUgU0VUICJsb2dpbiIgPQoiYWNjb3VudGluZm9fdGVzdCIuImxvZ2luIiwgImJhbGFu Y2UiID0gImFjY291bnRpbmZvX3Rlc3QiLiJiYWxhbmNlIgpSRVRVUk5JTkcgImFjY291bnRpbmZv X3Rlc3QiLiJsb2dpbiINCg0KLS0tLQ0KDQpJTlNFUlQgSU5UTyAidGVzdF9zY2hlbWEiLiJhY2Nv dW50aW5mb190ZXN0IiAoImxvZ2luIiwgImJhbGFuY2UiKSBWQUxVRVMKKDIwMDAsIDIwMC4wKSBP TiBDT05GTElDVCAoImxvZ2luIikgRE8gVVBEQVRFIFNFVCAibG9naW4iID0KImFjY291bnRpbmZv X3Rlc3QiLiJsb2dpbiIsICJiYWxhbmNlIiA9ICJhY2NvdW50aW5mb190ZXN0Ii4iYmFsYW5jZSIK UkVUVVJOSU5HICJhY2NvdW50aW5mb190ZXN0Ii4ibG9naW4iCgo= --===============8378605330288411498==--