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 1n5dj2-0005sC-A2 for pgsql-bugs@arkaria.postgresql.org; Fri, 07 Jan 2022 01:07:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n5dj1-0008Hl-3v for pgsql-bugs@arkaria.postgresql.org; Fri, 07 Jan 2022 01:07:23 +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 1n5biT-0006cn-QX for pgsql-bugs@lists.postgresql.org; Thu, 06 Jan 2022 22:58:41 +0000 Received: from sonic317-27.consmr.mail.bf2.yahoo.com ([74.6.129.82]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n5biQ-0008Ve-LQ for pgsql-bugs@lists.postgresql.org; Thu, 06 Jan 2022 22:58:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1641509915; bh=C0kyRkOn/8EDT0Ae3+1Vs/PFLZXKLKAV6ABJb9DiFps=; h=Date:From:To:Subject:References:From:Subject:Reply-To; b=HpDpr6+FUZCNvOXepBFOKiLacI3LpJx/nwv2GuiM7U3CAnAw76o1n67HwBoMmtwFzL0I+hBeE0BDQYqYQivjeb0koe88i/DzhvlfCcz4+ieQFsIvNTZrnZCDGMjLsWjSizhOfZhoJWaJOO0COWruoP+tEIVdLQoK4+j4phvrrkXydnHKKvGKKsPDg+bbMvVUCpFqmGwPCMGk70TDJHVn66EavO/YI9ElcESXJCwR71HA+MaV/QUcrueuTzbRDfkdfVD8uHf7dz6a5imtc56c//G4QIGgGc7ujY2WsNqk8tske2iGkfUvMkbBhN5vR1I3hxjFR1tEAWPT7LzOhio6Qw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1641509915; bh=2d5OO4TVsK4X/9/gNfwhfGun2r8R8LXDGvFSha/HqAE=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=aviZ0n12lHpoYHcYa/VfolS4U5SAov4cXQaX92gx78ZmwaFR/vbkOS1WDz7oiUuVWL40fCE0BBmgQyl/KHYta9lhoKx5uZ88sA3giXzttEn98wXrArC10KGXBDCAits/VCnGag2/nY/ojHlv2906WGmzRdl8ok4j95LsWO/d/Ij1UxQtAksDZmurymprFQHJu6dklvxP7o1HaQ5xYQE8xLn1UWBto/8jzC/nKde9A44tpJY/rKSuqkzRalMqHbgMp4uu5BJzK2C1MqkE3AAvfC2qQvA6pwFYatqpDqDnkYELT6AZSTSeg282/zeIaK4lwQ40sQQX9SO6mki2BLbA4A== X-YMail-OSG: trG4mkcVM1kCt9TxjjvY8CiC.Vg2fIxA2EFJuy.kkEP2nL6GpvT7Svu03d8hFv7 QiKC4lmy.14b74m.7D3Ub80a.MEYokYg9ZTTP4LOJln4J.jXPg8mBC.QlWF6KNxJNLEAC75EcigC QQZM0S2pUuCdUcMD.jM82iwMbxjVqcRq13.sC49Qg91mCFujIDJAZMCEMPCiUoozkwTw__rylddg umBPjyOEbrqAA0FQv8TyqhcJr2FbvgvIPQPm45YtBOcZr1Kbzk7wLVm9TZVf0JKUvTbAZWoYTKgZ plH6i.ErhlIFPuRV7fITgd06msgrjqdArIhrhL2gX.WsmNilzYyog_OflhPhRvHxzJ4SW3PepTWT DZ6zKT_CPqcmXpkD1e4Xg4zqhkLD3QkLei64OuiSokjFPh3fVuoc_RDCah8QIRCKHti5ycwhpdVJ yhvT3s5JPiklQzscsHb9tOWhkOIV4B8XDD3jWN86ZmDV05oQ8RgrZYDq6vaQqRRUWeDwaZgyB9Kn kmX2rnNOX0siKyp.bZYN_IAh8GJELPyg5tiBQPsNF.lO.zKZvWlEEMjc5H9Jpttm9tDSsV.ofs.g i6r5YmGjfPUTUxcg1vroGa8giGtTvltMi5bp0U_iZC1IHrGqGs9Je2C8rSMjn0jhIx0mVOLL3pKm Xd4zcREf7dcwlR7Eyw61FXmb0tRoflJv7YB8jMOyvjqmXAG2EEnFO2wpg5dNUME0DczT7PCH7YNY xgCHq.BVbZK_GQQNmvcS..fVn2CTg5M07KWG5aq.BfxiLUwRnna9KHeyQhaiyc_D6Zi.vlTt01G_ LshcIlQWegtqt_F0ho5LeobNe8QCBcbW5.z5kkHlo1Y5953iSyuxDGfd0wUsgHq5A8hJXpOHWKCP xzur5kC6Ohl1feysjEXIIhOTq6jLobmagtdwk0h6vTF8jSUfBfMgCVpASYEHEIuvG9m3nRQXWiQW Kc_S3kOFMBBpiaz0muIll6xJwTp4n2iSTx70LSQuqtQCKbMMNXHEburpkf0piQlPK0dg4QH.ET.i kR1pW7kutO6uBqX4yKemA29B3fuyfJSE5b3RIDPcnCLrkBbsle7z9ksaRUMPA.f3pqet4YbSBplf uLp_JiJwBmu2GkPtSythsu0eDWarnJ84Bt7uoJUlAO1vBUIPYczsak2m25X6TT9y0RZ9oeJe7lcw bcjsFsTUIMHqVuNHf4KT7CTxIRDZmW1orl1pYjlShpoxF2qqwEDJspTFJMYTkWbiA3Be4sdabmHL RPZiqVBaiel8YGo9BtDoJMW3U_RDYWY8IJWtE2O6hkPMPiGPWse6jOFA0yd9i8nC0.MeuJhfGPPw RJYPNT5a9mcYvYmzWn6Fk.WgUpN5WpIeEdG.3FZT96z0hYwXb_2bh7d_54wrhxy7gHs6hYsAajMb QGu.hBifLbCjiTuxyyi1YzUPwk0yutZfC.fWknQuUgptJWUlfwTvtOfSV5kDXGI_.giIF9xH62IH IfAupBUmyA2d96du9pC6tKOJLqtsSq2b_GklXHKfaaoziLwe5ncZlOv68uOgJaFVqvR.ZoUw.um3 n0o3rX_7PobiUK1QmdZjGUIO3mNPclX.RMfCzIYsfIHqN1RyYH9kGLPlJOFyC1T1hie6tE13Ulsc j7E9RDJO.yTcpo06ur1LsGpdRMTaQdEgCx9KbM1H3.St3sW1C3xt.GyA6HFtzxltxfIb2OVGbDZk nNsgMW5YN_XTpupr_eWLJl1iR6TdDbraBe8Eprhf3JGkvCEQSv2kU8porwtFdQOh.wFO4TAcml9Y gJlYAMVigTK75o0JeN_4Qt.eHBkj4oAnh78ZAnzWBJV2C6ykOHXKBU4WQNcDuALd59CV1KZYLlcV KASs6FjkdQbRe.Mz8I22RLr5JNFMlHkgl6cnHOFNo_xeCPGIhoYCqIJjCxLgyOYayLElsTJe9.SR ihScCRLAVunRBOfN9YBXfV_Q9A65jVTXp90nvPTjxoyNX4Ec0Cc2pVqmP5QoOyoFCcYD_g9o_Mt2 PKEVNkw2JA85T0IfcbsYRd.YqlRlAO9ENNW7Okl4quzEUtGK_OCalxpNyTzD3Lf3KH83_t8zdJif CqrFg.gI1jEbaRH5vcQiLTF3FDzpGrauOZnKqOEP40JeTZpcgJwLv_3Z_bx_xTkfQMTGRTUzWlE5 aXq4fA8voLoeCpx.A9WGoYDJKFznBApxVnGuslAiA79HXpAjj_AnwiA-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic317.consmr.mail.bf2.yahoo.com with HTTP; Thu, 6 Jan 2022 22:58:35 +0000 Date: Thu, 6 Jan 2022 22:58:31 +0000 (UTC) From: Milos Musicki To: "pgsql-bugs@lists.postgresql.org" Message-ID: <371600056.1505644.1641509911705@mail.yahoo.com> Subject: Possible bug report MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1505643_1717772100.1641509911704" References: <371600056.1505644.1641509911705.ref@mail.yahoo.com> X-Mailer: WebService/1.1.19551 YMailNorrin Content-Length: 2466 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1505643_1717772100.1641509911704 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hello, Miles Musicki here from Michigan, US.I think I found a bug in PG 13.4, or at least I can't find a reason why it would behave this way. My question, as well as explanation what I did to avoid the behavior, is displayed here. https://stackoverflow.com/questions/70614464/postgresql-insert-into-on-conflict-column-name-is-ambiguous It has to do with INSERT INTO statement when using ON CONFLICT. All the best. Milos Musicki mmusicki@yahoo.com ------=_Part_1505643_1717772100.1641509911704 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello, Miles Musicki here fr= om Michigan, US.
I think I foun= d a bug in PG 13.4, or at least I can't find a reason why it would behave t= his way.

My question, as well as explanation what I did t= o avoid the behavior, is displayed here.


It h= as to do with INSERT INTO statement when using ON CONFLICT.

All the best.=

Milos Musicki
mmusicki@yahoo.com

------=_Part_1505643_1717772100.1641509911704--