On Wed, Oct 29, 2025 at 01:04:48PM +0100, Colin 't Hart wrote:
> Thanks. But as I wrote above, trying to alter either of the two
> sequences and specifying "owned by none" results in the error.
Sorry, missed that.
Can you please provide pg_dump output from this db, just schema, just
this one table, and both sequences?
Or, how did you arrive at this situation?
Did you try to alter table … alter column … drop identity;
Best regards,
depesz