Horton

Re: BUG #19365: postgres 18 pg_dump fails whan drop sequence concurrently

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pavel.tyslacki@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Date: 2025-12-29T17:28:07Z
Lists: pgsql-bugs 
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