Re: Two sequences associated with one identity column - Mailing list pgsql-general

From David G. Johnston
Subject Re: Two sequences associated with one identity column
Date
Msg-id CAKFQuwYcUb=tpK4o-SvBnJ_Q2_Gg2pCS7q6+mosxuH++DEK+bw@mail.gmail.com
Whole thread Raw
In response to Re: Two sequences associated with one identity column  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
On Wednesday, October 29, 2025, Dominique Devienne <ddevienne@gmail.com> wrote:
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


If a reproducer is not offered discussions do tend to focus on fixing the symptoms since that is what is available to consider.  Not too surprised no one volunteers to reverse-engineer a reproducer from scratch, given only the end state.

David J.
 

pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: Two sequences associated with one identity column
Next
From: "Colin 't Hart"
Date:
Subject: Re: Two sequences associated with one identity column