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 1wESbj-0042Q8-20 for pgsql-general@arkaria.postgresql.org; Sun, 19 Apr 2026 13:54:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wESbi-00FO9r-2P for pgsql-general@arkaria.postgresql.org; Sun, 19 Apr 2026 13:54:42 +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.96) (envelope-from ) id 1wESbi-00FO9h-1L for pgsql-general@lists.postgresql.org; Sun, 19 Apr 2026 13:54:42 +0000 Received: from mail-yx1-xb130.google.com ([2607:f8b0:4864:20::b130]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wESbg-00000001mOF-1CE9 for pgsql-general@postgresql.org; Sun, 19 Apr 2026 13:54:41 +0000 Received: by mail-yx1-xb130.google.com with SMTP id 956f58d0204a3-651cfaa21e6so2021468d50.0 for ; Sun, 19 Apr 2026 06:54:40 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776606880; cv=none; d=google.com; s=arc-20240605; b=Lck4fwyhVmMmIYk2pK2LT84fZqSn7MAqAIPo+qcAlU3gkVQQyLrCueI4zgtmVUzsH0 PHX4t3/C+HfZGoZhVbfGrvsA9geUq2Zy4pWe++pllekV/eNTqfFoO6/Td8EQgH927OYh zRZ3m8MnWFRS+AQ2UoS33Sgkx7AtuWKBCMP5RIty8nkFfNTqb8sTsJCBAIvYPQUZHs0K ZgIR2+lwHrJvErn9m8oGraAkWtRG6bIf8Df2aoCqqRJ/PSKWe5wX7Zp1Zz99gqXy5fwF JkNR+08Z6c5zV472GTfo+TauxfB7/nXv7RdnLcM675UdRvRArnezFghLJjLiE2ZpOQZl dG6Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :dkim-signature; bh=QYRCDXrMCYUzRRCpu+21lGCaQ6vGFZaGkiJGPodcWJ0=; fh=gWG6JRYg3XLz/Q7nQP7IO8nUifOSh9VzrP/MnrNCo/M=; b=IigZEt56z4Zh6PTpG1lx5LhOY8JUBaNEoh8C3zcDhYtO74tT8mNTsnEcuXbFzwDiEl a+LvkREvEpWfJSs7XkYBaTQ+M3e2OkwIs0ISEDcfOk9kIavUUV7lVwzhk7UShn7gzswH Cl4LknxiLXQhaqnPXeFYpE5PX39VqS9lHOu2yDEvxDxt3As7DdJ+cV9ye5S5JKELYzrl Jw759XfYzhYDb2FYgqEDw8QmYoRfGsvsjd+wivFARQ4pI6D6T8wntzVbGgvd+91RWrtL IXd0k4D3VaRHmcBrn9XCu56Ue50h2msj5NtQ0x1G7/3bfumC3WyJReAGrezFFKYKhUuk f03Q==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1776606880; x=1777211680; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=QYRCDXrMCYUzRRCpu+21lGCaQ6vGFZaGkiJGPodcWJ0=; b=MZ9C0+g7FXBpTGyF35v9Bzfl5rQw9QPyDlYsXSsAkGVgWd0N+PTbUofBwhLFX9/T1n I/se7jdIkdHgdxMgC0JBFmfnWUCwDDwn2ZB/r9r9iil80Cfmr7BhVB2SXJ5zZVJDJAWP MUxMmaZmDwnIRiBmNljowVraMLSAEWGEufqq5J8IkrJKfPG84P5hd8r6GHhsvM/eZu3t Jj/F93wr2BO+7rtce+s9A0lgQes+94C6EkrRJUy74ljQfD3azf+rZNlPP2wtDv7w1aX6 cNdFs5TX859ltj9BjYWitiU75rnMGZlleLzRMhBGksKj6Y/4ZNItKyrFqNbwBirDPUk4 IKYg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776606880; x=1777211680; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=QYRCDXrMCYUzRRCpu+21lGCaQ6vGFZaGkiJGPodcWJ0=; b=eJrBXGa5vXEwJ1M+RT/5/5Vd4e2RUdFZ2Z3KQpF4rOD/B505zdBSQNiFuAry2B/G1U FjECfUeO6Tj/wpcW1JijVgrLQ0wJ7cckwI6RBYNYSyMp8MXp0a3tmZ2W+hepCwWl7A4y IwoqJv3On16mqxQEkLRWw2O95ElqMbNqYza3osJY0wtu+Vk3ICMyX83v0myCIbva4W0u HgKwXY3k0Qq0keC92z2rAofxOoVKtA4ffHRAGnE4NKztHGgaPVZIEURjxDvIlhuNF/mi PUZDnOu2NGUwMau6Qkap81vE1RU6GUF8//9J+2y17ZYW+XHMDua8BtM93KWFxBLD3oh/ +1VQ== X-Forwarded-Encrypted: i=1; AFNElJ9emqckItymkMKnmpmvwmhn+kfhoULhqfRm+Tydw5uu13yNRkgOGXrhcSMoAzzw3i3F5V1ddtkdJbZRPrX3@postgresql.org X-Gm-Message-State: AOJu0YxGwllQGv4z9xC9iIrBAoyPnSeUxe4KsTMJl+oGu80ZtfF7RE2A kY9tZ0Mi6KxTGC28klEYw64SKjK90WQV5xxwh5pnTGI+PXKYXOL9kiHjdyAV7+dDMKDKCpS/a3B G/DVNxtJL8LGmjcc3qrmdqv8wmNQbCuYMvg== X-Gm-Gg: AeBDies/bTwuBTpnmdQ54/6KkQj3s2X1a5fla2i8TEzc5Peh3YFHhViaAi72ffn126/ GpETaIRCaMGIGkwNUEpg5TO0A0LG+L9TOJQbFJVR7vHPBdJfpIATTzClsB5TPIyWRm/J6YJ9Dz6 CqYItV5AtBrb0pLFuLjrDUncWZZsWeh3C9uf1wEXslkT1EEcxqX2Tw3H2+fsZvBB8Z4JOtQbCp+ NIXPBxkkee9LMPkx1t68wbSAacmfBhgB+EB6lDAMudANVBdDALtXdVuv3A/Jrc/3PQ1ohZGDd9w 9yUmaCTeTbSkLIqYzQ== X-Received: by 2002:a53:ac97:0:b0:651:c221:9629 with SMTP id 956f58d0204a3-653115cb495mr7020264d50.0.1776606879812; Sun, 19 Apr 2026 06:54:39 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "David G. Johnston" Date: Sun, 19 Apr 2026 06:54:02 -0700 X-Gm-Features: AQROBzCpVz-sKRwRvU8Kfyq7SDLGpl8J7dC6Op-mKtI7lMlDpDnF2wzEtl1qXwA Message-ID: Subject: Re: unique constraint violation on multiple-rows update To: pgsql-general@lists.postgresql.org, pgsql-general Content-Type: multipart/alternative; boundary="000000000000fa108a064fd0851d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000fa108a064fd0851d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sun, Apr 19, 2026 at 6:44=E2=80=AFAM Karsten Hilbert wrote: > > Running that does violate the (non-deferred) UNIQUE > > constraint on the table column, however. > You know about deferred constraints, you should use them here. This is one of the key use cases motivating their existence. David J. --000000000000fa108a064fd0851d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sun, Apr 19, 2026 at 6:44=E2=80=AFAM Karsten Hilbert &l= t;Karsten.Hilbert@gmx.net>= ; wrote:
> Running that does v= iolate the (non-deferred) UNIQUE
> constraint on the table column, however.

You know about deferred constraints, you should use them here.=C2=A0 T= his is one of the key use cases motivating=C2=A0their existence.
David J.

--000000000000fa108a064fd0851d--