From: Michael Paquier <michael@paquier.xyz>
To: Ayush Tiwari <ayushtiwari.slg01@gmail.com>
Cc: Alexander Lakhin <exclusion@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org, Alexandre Felipe <o.alexandre.felipe@gmail.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: Peter Eisentraut <peter@eisentraut.org>
Subject: Re: BUG #19687: ALTER SEQUENCE provokes error XX001 could not read blocks
Date: Thu, 24 Sep 2026 10:19:58 +0900
Message-ID: <arR6vutn730-lQ84@paquier.xyz> (raw)
In-Reply-To: <CAJTYsWVv1nixdocNth6W29MbO81J9jfkhh+TrJ5rKDwjrOYYYQ@mail.gmail.com>
References: <19687-dd094472b0c48afb@postgresql.org>
<CAJTYsWWH0N-jJUviz3eviLa_ehGVsmumOmpTGufbRAsuDD2Uiw@mail.gmail.com>
<7ac90032-cf60-4415-a7f9-cf512196db35@gmail.com>
<CAJTYsWVv1nixdocNth6W29MbO81J9jfkhh+TrJ5rKDwjrOYYYQ@mail.gmail.com>
On Thu, Sep 24, 2026 at 01:09:12AM +0530, Ayush Tiwari wrote:
> I don't have much background on the lock levels needed here, but taking
> AccessExclusiveLock upfront seems reasonable given the storage replacement.
> I'm less sure whether it's too strong for cases like OWNED BY.
> [I've sent a diff upthread, can add a patch if that's the right way to go]
>
> Cc'ing Andres, Michael and Peter, who were involved in the original
> sequence locking and transactional changes. Does this approach make
> sense, or am I missing something here?
Where do you mean to add this extra level of locking?
--
Michael
Attachments:
[application/pgp-signature] signature.asc (832B, ../arR6vutn730-lQ84@paquier.xyz/2-signature.asc)
download
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: michael@paquier.xyz, ayushtiwari.slg01@gmail.com, exclusion@gmail.com, o.alexandre.felipe@gmail.com, andres@anarazel.de, peter@eisentraut.org
Subject: Re: BUG #19687: ALTER SEQUENCE provokes error XX001 could not read blocks
In-Reply-To: <arR6vutn730-lQ84@paquier.xyz>
* 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