Horton
Menu

Re: Two sequences associated with one identity column

Dominique Devienne <ddevienne@gmail.com>

View thread
From: Dominique Devienne <ddevienne@gmail.com>
To: "kurt thepw.com" <kurt@thepw.com>
Cc: "Colin 't Hart" <colinthart@gmail.com>, PostgreSQL General <pgsql-general@lists.postgresql.org>
Date: 2025-10-29T13:29:46Z
Lists: pgsql-general 
On Wed, Oct 29, 2025 at 2:17 PM kurt thepw.com <kurt@thepw.com> wrote:
>    If this is a development database, perhaps you can do a schema-only pg_dump of it in plain text format, manually edit out the offending second sequence from  the resulting SQL file, and restore it into a new database.

I'm surprised the conversation is not more about preventing this from
ever happening in the first place. Since one cannot get out of it,
apparently. --DD