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

help / color / mirror / Atom feed

From: Nathan Bossart <nathandbossart@gmail.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Matthias van de Meent <boekewurm+postgres@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Ayush Vatsa <ayushvatsa1810@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch
Date: Thu, 12 Sep 2024 20:42:09 -0500
Message-ID: <ZuOYcb9hYfMNaHRD@nathan> (raw)
In-Reply-To: <ZuON2ERKm9nvkOYo@nathan>
References: <ZtI0O-bN90P02oQO@nathan>
	<CAEze2WiNB=wjrtQGERk2mmkpOZevGCfTT7ei6guJsFG4VRmacA@mail.gmail.com>
	<Ztd0VcV2PQJf5jUJ@nathan>
	<ZuH_PB1S3JuWvNPq@nathan>
	<CAEze2Wh_KkMthGmGiW+v9hFN90L066Vt3VQdEFmwmi03CgFRkA@mail.gmail.com>
	<ZuJPlHWN6HOO9AYD@paquier.xyz>
	<ZuNfgqVMc2O9XQN6@nathan>
	<ZuOKOut5hhDlf_bP@nathan>
	<ZuOLqG5zXKEB9ICg@paquier.xyz>
	<ZuON2ERKm9nvkOYo@nathan>

On Thu, Sep 12, 2024 at 07:56:56PM -0500, Nathan Bossart wrote:
> I see that skimmer is failing with this error:
> 
> 	ERROR:  cannot access temporary tables during a parallel operation
> 
> This makes sense because that machine has
> debug_parallel_query/force_parallel_mode set to "regress", but this test
> file has used a temporary table for a couple of years without issue...

Oh, the answer seems to be commits aeaaf52 and 47a22dc.  In short, we can't
use a temporary sequence in this test for versions older than v15.

-- 
nathan

view thread (29+ messages)  latest in thread

Message-ID: <ZuOYcb9hYfMNaHRD@nathan>
Permalink:  ../ZuOYcb9hYfMNaHRD@nathan/
Also on:    postgresql.org/message-id/ZuOYcb9hYfMNaHRD@nathan

copy link · copy postgr.es

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-hackers@postgresql.org
  Cc: nathandbossart@gmail.com, michael@paquier.xyz, boekewurm+postgres@gmail.com, robertmhaas@gmail.com, ayushvatsa1810@gmail.com
  Subject: Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch
  In-Reply-To: <ZuOYcb9hYfMNaHRD@nathan>

* 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