From: Tom Lane <tgl@sss.pgh.pa.us>
To: pavel.tyslacki@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19365: postgres 18 pg_dump fails whan drop sequence concurrently
Date: Mon, 29 Dec 2025 12:28:07 -0500
Message-ID: <2886168.1767029287@sss.pgh.pa.us> (raw)
In-Reply-To: <19365-6245240d8b926327@postgresql.org>
References: <19365-6245240d8b926327@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> In postgres 18, I started getting random errors from `pg_dump`:
> pg_dump: error: query failed: ERROR: could not open relation with OID 16741
> pg_dump: detail: Query was: SELECT seqrelid, format_type(seqtypid, NULL),
> seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle, last_value,
> is_called FROM pg_catalog.pg_sequence, pg_get_sequence_data(seqrelid) ORDER
> BY seqrelid;
Thanks for the report. I posted an analysis here:
https://www.postgresql.org/message-id/2885944.1767029161%40sss.pgh.pa.us
regards, tom lane
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: tgl@sss.pgh.pa.us, pavel.tyslacki@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19365: postgres 18 pg_dump fails whan drop sequence concurrently
In-Reply-To: <2886168.1767029287@sss.pgh.pa.us>
* 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