Re: ERROR: tuple to be updated was already modified by an operation triggered by the current command

Noah Misch <noah@leadboat.com>

From: Noah Misch <noah@leadboat.com>

To: Robins Tharakan <tharakan@gmail.com>

Cc: Richard Guo <guofenglinux@gmail.com>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

Date: 2025-04-21T04:06:05Z

Lists: pgsql-bugs

On Fri, Apr 11, 2025 at 07:41:33AM -0700, Noah Misch wrote:
> On Fri, Apr 11, 2025 at 10:18:04PM +0930, Robins Tharakan wrote:
> > On Thu, 23 Jan 2025 at 19:42, Richard Guo <guofenglinux@gmail.com> wrote:
> 
> > Repro SQL
> > =========
> > CREATE TEMPORARY TABLE a(b boolean , UNIQUE(b)) ON COMMIT DELETE ROWS ;
> > CREATE TEMP TABLE d() INHERITS(a) ON COMMIT DROP ;
> > ANALYSE;

> --- a/src/backend/commands/vacuum.c
> +++ b/src/backend/commands/vacuum.c
> @@ -657,6 +657,8 @@ vacuum(List *relations, VacuumParams *params, BufferAccessStrategy bstrategy,
>  				if (use_own_xacts)
>  				{
>  					PopActiveSnapshot();
> +					/* standard_ProcessUtility() does CCI if !use_own_xacts */
> +					CommandCounterIncrement();
>  					CommitTransactionCommand();

Pushed: postgr.es/c/2d5350c

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Avoid ERROR at ON COMMIT DELETE ROWS after relhassubclass=f.
- d34b671a63e6 13.21 landed
- a61b67cd06c2 14.18 landed
- e0f53e669969 15.13 landed
- d0a049987e5a 17.5 landed
- 5905e9935999 16.9 landed
- 2d5350cfbdc6 18.0 landed
Fix data loss at inplace update after heap_update().
- a07e03fd8fa7 18.0 cited
Don't lose partitioned table reltuples=0 after relhassubclass=f.
- 7102070329d8 18.0 cited