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 1sgkaO-0078pI-H1 for pgsql-bugs@arkaria.postgresql.org; Wed, 21 Aug 2024 12:37:12 +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 1sgkaM-00AWAo-5N for pgsql-bugs@arkaria.postgresql.org; Wed, 21 Aug 2024 12:37:10 +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 1sgkYN-00AVZE-7O for pgsql-bugs@lists.postgresql.org; Wed, 21 Aug 2024 12:35:07 +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 1sgkYK-000jFD-VI for pgsql-bugs@lists.postgresql.org; Wed, 21 Aug 2024 12:35:06 +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=1qdzDtb+qmuxmZJBGg3JCoMTOAgHPLyky8NsT1L5nx4=; b=g1JMq5OP/7E4e6YSwirmwSNPmW ftxAwRz824mEQjib85mW5em36Mbvpw8svT+KA2jhQRVujs8hXoOeseHveZfYEXazI1WoN6lDqkb1W h4qfuddP7hHFqtYDyYA34zJwzcTk2r7TxroO+xBwQ7kcCgrs1eCBMFmzfHOzXfiJwiJ1QB+ckQJrt 2EDn4nGK9MMOvNh5QO0Px6Dss+NxQDLlp1z/dQWB8AKOnrK0NJxFUXmxXll9ycHkcO5XtVR1urdvC PfH0VJsD90anE6aHZeVcjoWFEXHqK/G95gR9xNbVwk9Ef2AdzQllMbWlHKzVTqWAPQtcV62A8AaDh Ck+DKnIg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sgkYJ-002awg-MA for pgsql-bugs@lists.postgresql.org; Wed, 21 Aug 2024 12:35: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 1sgkYI-004Dwe-Hj for pgsql-bugs@lists.postgresql.org; Wed, 21 Aug 2024 12:35:02 +0000 Content-Type: multipart/mixed; boundary="===============4932869322670600805==" MIME-Version: 1.0 Subject: BUG #18587: PLPGSQL : conflict between variable and ON CONFLICT (a_column) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: remi.cura@gmail.com Reply-To: remi.cura@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 21 Aug 2024 12:34:37 +0000 Message-ID: <18587-c4ee4d43f6a4f8f3@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 --===============4932869322670600805== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODU4NwpMb2dnZWQgYnk6ICAgICAgICAgIFLDqW1pIEN1cmEKRW1haWwg YWRkcmVzczogICAgICByZW1pLmN1cmFAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTYu MwpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpXcml0aW5n IGEgUExQR1NRTCBmdW5jdGlvbiByZXR1cm5pbmcgYSB0YWJsZSB3aXRoIGEgY29sdW1uIG5hbWVk IGlkLCBhbmQKdXNpbmcgdGhlIHNhbWUgY29sdW1uIG5hbWUgaWQgaW4gYSBJTlNFUlQgT04gQ09O RkxJQ1QgKGlkKSBtYWtlcyBwbHBnc3FsCmVycm9yLg0KDQpJIGtub3cgdGhlcmUgaXMgYSBuYW1l IGNvbGxpc2lvbiBoZXJlLCBidXQgUExQR1NRTCBzaG91bGQgbm90IHRyeSB0bwpzdWJzaXR1dGUg YW55IHZhcmlhYmxlIGluIHRoZSBgT04gQ09ORkxJQ1QgKCJzb21ldGhpbmciKWAgaW4gdGhlIGZp cnN0CnBsYWNlLCBhcyBpbiBTUUwgdGhlIG9ubHkgYWxsb3dlZCB2YWx1ZSBmb3IgInNvbWV0aGlu ZyIgYXJlIGNvbHVtbiBuYW1lcwoobm90IHZhcmlhYmxlcywgZXhwcmVzc2lvbnMsIGV0YykuDQpU aGUgb25seSB3b3JrYXJvdW5kIEkgZm91bmQgaXMgdG8gdXNlIGAjdmFyaWFibGVfY29uZmxpY3Qg dXNlX2NvbHVtbmAsIHdoaWNoCmlzIGJhZCBwcmFjdGljZSBhbmQgY29uZnVzaW5nIGltbywgYW5k IG1ha2VzIHRoZSBjb2RlIGxlc3MgcG9ydGFibGUgYW5kCm1haW50YWluYWJsZS4NCg0KSSB3cm90 ZSB0aGlzIHRvIHJlcHJvZHVjZToNCmBgYFNRTA0KDQpDUkVBVEUgVEFCTEUgSUYgTk9UIEVYSVNU UyBwdWJsaWMudGVzdF9wbHBnc3FsX2J1ZygNCiBpZCBiaWdpbnQgUFJJTUFSWSBLRVkgLA0KIHBh eWxvYWQgdGV4dCANCik7IA0KSU5TRVJUIElOVE8gcHVibGljLnRlc3RfcGxwZ3NxbF9idWcgVkFM VUVTICgxLCdwYXlsb2FkIDEnKSwoMiwncGF5bG9hZAoyJyk7DQoNCkNSRUFURSBPUiBSRVBMQUNF IEZVTkNUSU9OIHB1YmxpYy50ZXN0X3BscGdzcWxfYnVnKF9uZXdfaWQgYmlnaW50LApfbmV3X3Bh eWxvYWQgdGV4dCkNClJFVFVSTlMgVEFCTEUgKGlkIGJpZ2ludCwgcGF5bG9hZCB0ZXh0KQ0KTEFO R1VBR0UgUExQR1NRTA0KVk9MQVRJTEUgDQpBUyAkZnVuX3Rlc3QkDQogICAgQkVHSU4NCiAgICAg ICAgUkVUVVJOIFFVRVJZDQogICAgICAgIFdJVEggaW5zZXJ0aW5nIGFTICgNCiAgICAgICAgICAg IElOU0VSVCBJTlRPIHB1YmxpYy50ZXN0X3BscGdzcWxfYnVnIGFzIHQgKCBpZCwgcGF5bG9hZCkN CiAgICAgICAgICAgIFNFTEVDVCBfbmV3X2lkLCBfbmV3X3BheWxvYWQNCiAgICAgICAgICAgIE9O IENPTkZMSUNUIChpZCkNCiAgICAgICAgICAgIERPIFVQREFURSBTRVQgcGF5bG9hZD1FWENMVURF RC5wYXlsb2FkIA0KICAgICAgICAgICAgUkVUVVJOSU5HIHQuaWQsIHQucGF5bG9hZA0KICAgICAg ICApICAgICAgICANCiAgICAgICAgU0VMRUNUIGkuaWQsIGkucGF5bG9hZA0KICAgICAgICBGUk9N IGluc2VydGluZyBpIDsgDQogICAgRU5EIDsgDQokZnVuX3Rlc3QkOyANCg0KLS0gcnVubmluZyB0 aGUgZnVuY3Rpb24gY3JlYXRlcyBhbiBlcnJvcg0KU0VMRUNUICogDQpGUk9NIHB1YmxpYy50ZXN0 X3BscGdzcWxfYnVnKF9uZXdfaWQgOj0gMSwgX25ld19wYXlsb2FkIDo9ICduZXcgcGF5bG9hZCAx ICcpCjsNCiAgICAtLVNRTCBFcnJvciBbNDI3MDJdOiBFUlJPUjogY29sdW1uIHJlZmVyZW5jZSAi aWQiIGlzIGFtYmlndW91cw0KICAgIC0tICBEZXRhaWw6IEl0IGNvdWxkIHJlZmVyIHRvIGVpdGhl ciBhIFBML3BnU1FMIHZhcmlhYmxlIG9yIGEgdGFibGUKY29sdW1uLg0KDQotLSBjbGVhbg0KRFJP UCBUQUJMRSBJRiBFWElTVFMgcHVibGljLnRlc3RfcGxwZ3NxbF9idWc7ICANCkRST1AgRlVOQ1RJ T04gSUYgRVhJU1RTIHB1YmxpYy50ZXN0X3BscGdzcWxfYnVnIDsgDQpgYGANCg0KSSBkb24ndCB0 aGluayB0aGUgcGcgdmVyc2lvbiBpcyByZWxldmFudCBoZXJlLCBidXQgaGVyZSBpdCBpcyBpbiBm dWxsOg0KUG9zdGdyZVNRTCAxNi4zIG9uIGFhcmNoNjQtdW5rbm93bi1saW51eC1nbnUsIGNvbXBp bGVkIGJ5IGdjYyAoR0NDKSA3LjMuMQoyMDE4MDcxMiAoUmVkIEhhdCA3LjMuMS02KSwgNjQtYml0 DQoNClRoYW5rIHlvdSB2ZXJ5IG11Y2ggZGVhciBjb21tdW5pdHkhDQpSZW1pCgo= --===============4932869322670600805==--