Re: Two sequences associated with one identity column

From: Dominique Devienne <ddevienne(at)gmail(dot)com>
To: "kurt thepw(dot)com" <kurt(at)thepw(dot)com>
Cc: "Colin 't Hart" <colinthart(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Two sequences associated with one identity column
Date: 2025-10-29 13:29:46
Message-ID: CAFCRh-8gM44R=V_TonSZmGLvZRT9wrtNXYCAXFC-aArSNnsm_w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 29, 2025 at 2:17 PM kurt thepw.com <kurt(at)thepw(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2025-10-29 13:39:19 Re: Two sequences associated with one identity column
Previous Message kurt thepw.com 2025-10-29 13:16:51 Re: Two sequences associated with one identity column