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.96) (envelope-from ) id 1wESpw-0042pN-1F for pgsql-general@arkaria.postgresql.org; Sun, 19 Apr 2026 14:09:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wESpu-00FRDS-1G for pgsql-general@arkaria.postgresql.org; Sun, 19 Apr 2026 14:09:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wESpu-00FRDK-06 for pgsql-general@lists.postgresql.org; Sun, 19 Apr 2026 14:09:22 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wESpr-00000001yzZ-3q2b for pgsql-general@postgresql.org; Sun, 19 Apr 2026 14:09:21 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1776607759; x=1777212559; i=karsten.hilbert@gmx.net; bh=ERdFConl2QqbaPsx07rWNF0wxetMviXOFdxBNroIVTQ=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:References: MIME-Version:Content-Type:In-Reply-To:Content-Transfer-Encoding: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=MOzsytOemVC23OHlSUflWj6NqssZB8ctukCwCl57D8vWN1NRmogJ3tkP1OgsG0I6 vf2TgYM1RkJG4MdU7Hf51dYYyCf7lZsGABUP4W+ZQX/yVUJq1lQA2Pz8A7TtbL2qg ycPGVipYWZR1UslfGKtlcMpeoWIZOqMIV6YKDftALBo7CXbZt100s3v06txlC0HL/ yNsulKB0y5kFd96D7wONWcGryevGMi933Ne0H0F4Uq8+LmmyHexx25koILRKX3MWC ptRIse3mZ6FjC7td6FY5UBQ1nqG6okVgf3Ct4FBVhlGYvvUO0l5KwZnke5g7ZzTbf YmoL1dSXkPj+Ytca2Q== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MVN6t-1vngvB2ML9-00PU2s; Sun, 19 Apr 2026 16:09:18 +0200 Received: from ncq by hermes with local (Exim 4.98.2) (envelope-from ) id 1wESpq-000000000gQ-0LM3; Sun, 19 Apr 2026 16:09:18 +0200 Date: Sun, 19 Apr 2026 16:09:18 +0200 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org, pgsql-general Subject: Re: unique constraint violation on multiple-rows update Message-ID: Mail-Followup-To: pgsql-general@lists.postgresql.org, pgsql-general References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:ji/jmCXJ07top1LHjsF7aYKZNLtR0gPs4+MVE+p//4Bz35mi0Nn CLg54nXY8cyCRhDdRrODfWf8AF4Q/VeFywBXlGMszLjCCJQE2EJS8mFrtuMYUAZ9+jbrzBL +KILnVljW3DqOjSHyVbtmyxQrLYir0ncIMVeOLAo1KnHn4SVuKmqnhidBfedrx3u+rbOJ0x EL6kaquGFusqGFJR8EkKw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:dTi2kZQdN5M=;vBLlvBXkFqKu7iqMAEtZ7H8a1F1 Oxt0QlrHZO1sFvzl0SGAdR5FWqaTnXWK+Nyxqe05mFvd1H1GP33k1YrQAutS+oRc8lILhip9N bmI1pB1pfXc3t4zjNfMLsTC7IZOLlreTpvRbBLmAob1IH73lhRsWTjtEQz7nfgwMnhSuPRrMG Shs4W6HbZu7u+ChVX9ujbgOW8RqfkwlyEMw2CfPcly5NFW/jXX6rvGekXMFCBaU1COZSV5/Ia 9W9IU+PHVGR9l3noJwSVACWnXNTumQCSvM8K3pBpRImpjYWNdAmmSyb6OiC1NcCi9tiTXG1Gy 1gAPavReIYOBLe0NY1d1dczkeEPbgRq9nj5IF6QeCrlPo4MV7oas24eNxOVthnY/UxlKoWeOS /fe7vnQMzuJ7vI2vv7TzmE0B9WKLUUAs2iEX8dKtXBl7mgMphR74M+ybV5mGPEkYma1W2jPkw Tn1aFG2r0lqhrzDdqluLC2PzFoYn5yAMOST+kyR1/9tqw8hfYOmnbgUvuLLDuo7sknP3oSbFl cNSTlfmN8fnZEyAjj6/Q+6N3NfbA392jcB/vhZIjYfc+iPgbegU5zpZcg308qn01VP4ZfecRc L3245iURBC3WqOOpTrLXpJxsLqLjHNld1J1Gvsr8yl9O+c0sz6bDs5O4ZXX6MyElKnweRLzW/ GkvBHxXdWJ7GfPXTsFFYv5hIPzWWKYz/8IB4e85GJNIU4ybeMTo/J3JSuyWsJECcdAcj2inGD T5KrRvj+u6rKLJMr5nBziw3XsV/PASwEq0Jb+sm5QgDo5Egi4xjMMLzUlpPJnxbLt4kZlVqv5 Mw1Do3MJdFIZnh9hXEAxXin2477woTJeGxBfSAse4yXW67Jq7ZNL+6n/ziAneFfbsmIF7ZOwa OxdnNkcx7BeS04hMB1cXLEAkMiDa+/GsqDx1JNzpU5xvHvWBGVRy0DHvzGOeD1AfV15OI04PE kNJA6zDtlmjvaT/PzDVimL0SaSCjAmhy7TFhnQMbLsKxMFWEfluXMsB+ZFqsPpDmIfhvCbJxe MjvCOQODWM0+5T1eOgELlKG/G7dZwrmfh+NoPVJq6tfbB/J6/nzQ/xme6V3Rszbu3mv7IPYAU gG5q9PGlAednwkwk2n5ocNJ2J9kuWZ23/Ei5oamBfnrgMEzJT/9hKExJvnRtt97JqwvTF3p5H 0NUAPRH15a/Kzr8UJMniKQnEWyZb2S6zIIi4Z4p7Y5eX/FTSvlhY3Ut5Q90PcP77xaM36XVxM WbRtzXhetXKNhF7IDhS+t+Cjg9UxZjWOPGTCwqS9EmbOSSfzEX8F69esGBcRemsR691OK4aKU uS4eCjy9cDnzsQDlsWtgx1N616E4rG8Xz2+obDhhXHd7PWb2qy9NuQucoIaZ2uoeWv9JQ+lIy UDqvdkiMyfNOK+yhxZ+5noOdKbIbAk4Qa4KaymqFLxP1kOlYX6MrZ5V5W48Ukvh+ifBZstYn4 hJvtXFqEkIteHfcjlq03vyBZVXBWmXOAbtI4XUrJdAzD85K26WI9fIix9S7RTINDEvAL0aWiq 0YW/SvQn1hD/vJuGPyY4mQVWD2OA17X33iK5F2pKBRDUrF9eypkkRwKNAKU0bVpeg5B6nLNRL +GIGALCkwC9KIOgCl4oBAq4RRsipvce9mydg2QTx2Jt+GEXLkYyHOn7AqC42rYLmPtD6/G/Pu O59rNdoeG2j5lciNf8XgVG3AJ0DvZKMH2u7Z7dj0nkguP/155yHW1vruYBgXtM8td4X3/1uF6 2PHo8Ce2kb+2yZ7ocx52lDf2pmYcnFKtHSe+LAKLiSV6L1ft9UEosbICL8BrXbr2GF5/NoGFe UmADTQZWmQqBCXN8E+2qLwF5lBu9W/gunqt7DWL4m2M2L2PE6sowOX0A8H16RqlUj0i9g2RZ3 an+gxIBaACh0wxRvrUJsAYweBHhMJtXKc0CBi1Gkaz3glyRIlFiW3q3qFJVnWT3eUBmZ/WaS9 zv41WRJ1KZP0n4GMDvHQGw3WN1ls7ljGXHtjckHVyPOyvyYOtUw1lFihl6znJZIldmCI82kYO Dgl79lGTSBjdKH3Md+X7SOVPrlDZXPQivdMV1t02CEm98UUWrkCH+SWv5AdXjKl/rC1IG+vsG aROmLbFTlMV06x6k854kxy8lAKE+tP1OS3EbhJ8KSKijh6i82od9vRPnZ/0WCdWjL1z2fFsFL XCD+BsZD8jxI1OovnBmUiL5IOtqTTkc4BEWxrdN5VdLWVMtElzAk2QBV8UGIuFL8AIpzJVrJl VgUZ0C8nnwYo2k6UR/YaR1TN3Re/jzpoWw7m6B2jolFdv/MkajkkIq6WNd2QQNsGhijrN0Ys9 SO9aoV7cZjXGncrbDpwRUjkT/vB6FIFy+ntrjx+buAYqZERJwW+O3JOtw+miO7g2YCfqnVVLW ONutKzwg6iRrzT5DO6lTSrCnk6zCDevtVjnCvKv2AwAfi1s/SKvbR0Pw/4EssGutFEE2JHbpW AyYMG/+N01tb7p12KGPyRSn5gADNTU2eB2LgDgLt5EaxM/Gf/UOvsviKdY7wQiHuzNDLdq79i Cb1GrzW3JkL4OQkm0JnGOS0d9Mgk788sMGMCf9u6WKj7Ni9CD5DkRRAXIClg7XOT1ihfQ6Nh+ pvmS4OV3NSWGDpKlig0KfbqDVgatozEXQvEqe+npcB5pJiV8k+v06YFN5Y3dVMKMGlz4d8Gof 9I9URE6zkr3LSeRKBOKsFXcgKn8G7h9DoTKD0pI8BceM4E6el0LQNHD/E1QvQu775sS8SS8VP l1R4eja7Chh6mK/PTtHub6eqYHSSeFFViSy0P54BTfwKXjwXv9hI6Frg+ykpf5cdOdAhMcBJ6 C2F2aR+5TWlAIp6CFqcY45/npnacM1F0Ko0FwlOX25ePc50z4QKIFnpjylipUi0LlKvnJkLIP +tm4k4MHCJJTJCq+fyMnIoK4iKV5fIx+EMaM+zqUfTiy/ryoGBnbq1OMRAt+hP1aCU9vsJbQU naaghEutX8KDRlHYB22xxdXcyfNzBdz297O1JEedkThASSVBdnWysceTt2AtKQKIo/2JfKRCg Mw3MaSKutCwns2a5hpkroGhnva+5d/iynj96zxuDSbTCqTneMcWqRW/TGBkqohzJ51xNTnv0L uAJGJy8uiSuObCP0S/lx6ngiURYp4lP8EluTVVKUqMothEM42YYTbuHgwjtOPKm5aXe3PQgFR nG6LOFaBgzgFQVUrbCd8WHTS5MJi2/7Rf/fauQO42uJYnBWUSJjKW+7F+e2z98heOhry1WQEJ azQD+hjOgNx+El8BzeuC8ESXhZ6qGWHkqCovqX9EkUv5WblJ4eTOI6gHRRYzYznq54WYq+4l+ P9RZESdDYHf9jmnxJeGz800CFXe4eqoFhYZe6t42VLHBiwtV0yLJe67mgVCusReaXtTnOPI9a nzySHp/+bBoML3KZt2jEyuAKbUDfQ07sncc+t37zeDGBM3er5dnS5psrkhw4F93IgVlBwEsTQ +Jt369QWZpG3cAffqjH0/y6Z0418HmPvWnc6/OYIt06A816m5ap9F2Jr4jP2ITNI1mA1HDjTE TV7piMie35g56cGnC4Ybr+oGLsG234LS8APoFJfcW0fK9bPSMagixFGRFD2z75ZitoVDe/qX6 qg3FHUNlYNlhl7g3/kdi2eWPhOl6uaymSrE0KN2xwclLYBY10xSgfzCCJNiemxiMMADAsw0ND N7LwJ9XfCJxUznr06MrTCAQBESCGVS247cSMTHOyBmbIPu+HqvMvosnHbYCxSgwovImtEftat uZa8+AUHkos3QcOkx5SehnVvXa4gHHKKuwqCpZzrMRfD1/3JW3VVRIDT/rppLyHswMBsnIRN0 8lF3Z5/7Zfj5B4G4s6R4VnYf1+gXVQIh6w69UJbO+MMInyXCpSCen99wW2nGBrzJfZ2BnGO4w pXXsfws7o9PkZQoIcpdEbO25lKhppsP0agdssMfUrqIN9G0Z/BxOq65OIUZF+rsxuoiy/FHWI NKJ86DrMlyfv70sW7VD8vn5BUXAQ0pChcurIVDWbVMg5i/fmacgv91K8XVbNB4hVjhU2vzb6T kyUUREodjY2KXulvo50DdNBGWoZVG6NT8AGT2cv8mPZ7mg/yzz4d5wZXNHN/HIMv87WhQb/+i VVRrDE4UR66z0QxtHeQBNJsWPnQSCHvbgcjbAiKkzA82G6bZK3v4sYg1m4HQ4PtfNtosIIWRY xtVC+BJWRg2oae6OyoDCYNPT4aFLSsIuI80j0KPkP4fQY8C56Svh9lhYD6tkiNb3Lq2kgDf6/ e5xeeLhSBDUVcv7O/McytdKHwE1ZLjo4gjJgFCQLe6H0n/fbd0ZVnFTEF08E/AcmmN3csm8zM JH7ZypIPRdaefD6EQfwWiIfBuoMQbgCcbxyXm3VS5fvT1lMpTgIUbxP4lZR8ccxXr7tSLm8GJ W+P5Wgbkm/1/UoLz/SvVPztcP+Q3QuUd2mhR8YMBkSp/4ctzCyNP7zvST3AedNQk06VlZwekm jRYkEuoO9V+35LG286DDju/6w108g9AA18sdm76+NDXiyeZNYCsYMLmC34/UrBwNpcex7xnmw I3zOsawsnu+P1kw0t6+p49EGKhUeKmDNGgyMxRuBQYxkf6vql88VHd91hKoJw18bsVzan3DFo QqMnUY96xvtmlpgJRv77LunkHeVl6nLn/hvltmBNTRokSRuUGVcCDr0b6PGFYKegWn/mYfZPN zeSCZDK67xZyMJbmtYiW48nPSqH10E09Q8YXyLMsE73D7sTXxX8SZDR90bOgbNFgshAtiOMKz bEPJpKdAr1XcvWy6JXPyb5F3IY0VaVbPHH/mhJs56UrhOjZPhwqVfeC+fQGKM0UTLtxpXCk9E Ox9TFflkTrzehBVf6a2rFxfTfby9OaRTDV9jUwBJCZuCjGRb3SZkwgUV5w6caRAq6Ggd87L1a jNiihtEgMKxvJHj2HdkeOOefeV9JaIhd3Ga+rSvWac4bvaFH8tzbPCpoU8fkpf5Q5lveafz9J XAfStjzG20kVr6Q/3CH2ksBt9PIyRWlfyfQI6cHi0hPcF4ihH8DLbAvEB/q02DZ9kaVgJjuv7 yx7qmE5H7ErYUOC181ggVv72NwIj7msJAmIW66ZgEYtoNFOgNsNKUwXgZ8xiGk6mT4BSKbS3U YEN2Szc5PA0ScCxf+kNChBtwK+RE7/2cyzywvc0qMf/nghgrneIewC+U2ArwQzPF366fTj3zx LL1Bep4eKPe1kwhfP1u4PlLjPNCieCG0R48NAOPM3BYX+btYQlFxgCWOaNq2qIDjTsB64JWxD uEMlvwAcm/DgLKcAilzqftEa5Fwra5OkRO4BzLLdIHLad0OC7q7IDbbijItpxjBLKBk4ocjhL sVRZ/1cS9lRQjqCSzBb07DNLoHcum3fJKMnqpU53DEG2rGUuV3TY9E= Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Sun, Apr 19, 2026 at 06:54:02AM -0700 schrieb David G. Johnston: > > > Running that does violate the (non-deferred) UNIQUE > > > constraint on the table column, however. >=20 > You know about deferred constraints, you should use them here. This is = one > of the key use cases motivating their existence. Indeed. I was of the mistaken impression that UNIQUE constraints were not deferrable ... :-) Works, thanks, Karsten =2D-=20 GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B