Re: Two sequences associated with one identity column - Mailing list 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
editout 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