pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Noah Misch <noah@leadboat.com>
To: Robins Tharakan <tharakan@gmail.com>
Cc: Richard Guo <guofenglinux@gmail.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: ERROR: tuple to be updated was already modified by an operation triggered by the current command
Date: Sun, 20 Apr 2025 21:06:05 -0700
Message-ID: <20250421040605.f4.nmisch@google.com> (raw)
In-Reply-To: <20250411144133.d5.nmisch@google.com>
References: <CAMbWs4-XwMKMKJ_GT=p3_-_=j9rQSEs1FbDFUnW9zHuKPsPNEQ@mail.gmail.com>
	<CAEP4nAy1BT52u=yf+GKGgbDMAR3re6mM992DXaaoaZq1XQ5a1Q@mail.gmail.com>
	<20250411144133.d5.nmisch@google.com>

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





view thread (4+ messages)

Message-ID: <20250421040605.f4.nmisch@google.com>
Permalink:  ../20250421040605.f4.nmisch@google.com/
Also on:    postgresql.org/message-id/20250421040605.f4.nmisch@google.com

 · 

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-bugs@postgresql.org
  Cc: noah@leadboat.com, tharakan@gmail.com, guofenglinux@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: ERROR: tuple to be updated was already modified by an operation triggered by the current command
  In-Reply-To: <20250421040605.f4.nmisch@google.com>

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

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