Re: Partitioning table - Update on partitioning key - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Partitioning table - Update on partitioning key
Date
Msg-id CANzqJaDCAodT3Fkm3BX=7=KHBxcLuFdKpJeRJpFz3RoKsD541w@mail.gmail.com
Whole thread
In response to Re: Fix missing FORMAT when deparsing JSON_ARRAY(query)  (Chao Li <li.evan.chao@gmail.com>)
Responses Re: Partitioning table - Update on partitioning key
List pgsql-admin
We'll need to see a "reproducer" (aka short bit of code that reproduces your problem), with the output pasted here.

On Thu, May 21, 2026 at 12:12 PM Raj <rajeshkumar.dba09@gmail.com> wrote:
No, updating the partition key (say colum created_at)....when u update the date , say change march to April,  this record is in new partition and we get this error

On Thu, 21 May 2026, 17:12 Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
On Thu, 2026-05-21 at 16:45 +0530, Raj wrote:
> 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?

Could you give us more context, like the exact statement and a description
of the data it is operating on?

If I had to guess, I would suspect that your UPDATE statement tries to modify
the same row more than once.

Yours,
Laurenz Albe


--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: recep gül
Date:
Subject: Ynt: Replica servers hanging after the latest security patch update
Next
From: Ron Johnson
Date:
Subject: Request For Feature: pg_dump