Again as I wrote above, drop identity complains about more than one sequence.
I have no idea how this customer arrived at this situation or if it affects other environments (this is actually a dev database that we're trying to upgrade as the first step in an upgrade project). I suspect the dump will just show two sequences that need to be imported and it will fail on the second one. I'll make a dump. /Colin On Wed, 29 Oct 2025 at 13:07, hubert depesz lubaczewski <[email protected]> wrote: > > 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 >
