public inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: Ron Johnson <ronljohnsonjr@gmail.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Partitioning table - Update on partitioning key
Date: Thu, 21 May 2026 13:50:21 -0400
Message-ID: <CANzqJaDCAodT3Fkm3BX=7=KHBxcLuFdKpJeRJpFz3RoKsD541w@mail.gmail.com> (raw)
In-Reply-To: <CAJk5AtYo4hUFwpKwZGpSzPG3ruTgRPLaKXyVOYn=JGoN29u+Qw@mail.gmail.com>
References: <CAJk5AtZH+P1m39F4R2XLtzqgne7Za4qmMTgtBDbU8snXQBrZXQ@mail.gmail.com>
	<dd7389df31fe3ac9c1eac94d5ddcb2d51f453f90.camel@cybertec.at>
	<CAJk5AtYo4hUFwpKwZGpSzPG3ruTgRPLaKXyVOYn=JGoN29u+Qw@mail.gmail.com>

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!

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Partitioning table - Update on partitioning key
  In-Reply-To: <CANzqJaDCAodT3Fkm3BX=7=KHBxcLuFdKpJeRJpFz3RoKsD541w@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox