MIME-Version: 1.0
From: Raj <rajeshkumar.dba09@gmail.com>
Date: Thu, 21 May 2026 16:45:37 +0530
Message-ID: 
 <CAJk5AtZH+P1m39F4R2XLtzqgne7Za4qmMTgtBDbU8snXQBrZXQ@mail.gmail.com>
Subject: Partitioning table - Update on partitioning key
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000009e51406525209bd"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJk5AtZH%2BP1m39F4R2XLtzqgne7Za4qmMTgtBDbU8snXQBrZXQ%40mail.gmail.com>
Precedence: bulk

--00000000000009e51406525209bd
Content-Type: text/plain; charset="UTF-8"

Hi,

Update happing on partition key.

And we get error 'Tuple to be locked was already moved to another partition
due to concurrent update error..

What's the best solution to handle it?

--00000000000009e51406525209bd
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hi,<div dir=3D"auto"><br></div><div dir=3D"auto">Update h=
apping on partition key.</div><div dir=3D"auto"><br></div><div dir=3D"auto"=
>And we get error &#39;Tuple to be locked was already moved to another part=
ition due to concurrent update error..</div><div dir=3D"auto"><br></div><di=
v dir=3D"auto">What&#39;s the best solution to handle it?</div><div dir=3D"=
auto"><br></div><div dir=3D"auto"><br></div></div>

--00000000000009e51406525209bd--