Thanks. But as I wrote above, trying to alter either of the two sequences and specifying "owned by none" results in the error.
/Colin On Wed, 29 Oct 2025 at 13:02, hubert depesz lubaczewski <[email protected]> wrote: > > On Wed, Oct 29, 2025 at 12:27:44PM +0100, Colin 't Hart wrote: > > One of my clients has a database in which a single identity column > > (called "id" in that table) has two sequences associated with it(!) > > Both sequences display > > Sequence for identity column: <schema>.<table>.id > > when described with \d in psql. > > Trying to drop either sequence results in > > Try: > > ALTER SEQUENCE some_seq_name OWNED BY none; > DROP SEQUENCE some_seq_name; > > Best regards, > > depesz >
