Partitioning table - Update on partitioning key

From: Raj <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Partitioning table - Update on partitioning key
Date: 2026-05-21 11:15:37
Message-ID: CAJk5AtZH+P1m39F4R2XLtzqgne7Za4qmMTgtBDbU8snXQBrZXQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2026-05-21 11:42:55 Re: Partitioning table - Update on partitioning key
Previous Message Pratik Pandit 2026-05-21 05:56:38 Re: Looking for a native MongoDB document extension for PostgreSQL (similar to pgvector like extension)