Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vE6Fa-004tS9-1a for pgsql-general@arkaria.postgresql.org; Wed, 29 Oct 2025 13:30:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vE6FY-001AIs-RK for pgsql-general@arkaria.postgresql.org; Wed, 29 Oct 2025 13:30:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vE6FY-001AHr-GR for pgsql-general@lists.postgresql.org; Wed, 29 Oct 2025 13:30:03 +0000 Received: from mail-oa1-x2c.google.com ([2001:4860:4864:20::2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vE6FV-004tIm-1b for pgsql-general@lists.postgresql.org; Wed, 29 Oct 2025 13:30:03 +0000 Received: by mail-oa1-x2c.google.com with SMTP id 586e51a60fabf-3d2ea93836bso2401458fac.3 for ; Wed, 29 Oct 2025 06:30:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761744599; x=1762349399; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=pGT1Q00IC6LDnjdFWxUOjb5QFrLGOdHjb0pQOx42n/A=; b=RuAeFNR52I4mTygKctZEaXV4xNNfrW9n8uwJ3fdStmta7x0lrzHJSL+JRtUgE4/Oih 8VVmdSkLH7FHgLmogSVCErUsSKC+gkFTrXB4kh0d/vjzmlLFDKN1e9xgLu272PknQ1XL k4OnNFNDaph7Rw4IiM7rJVdiv9xvZtn5CxIVENfELJsA+F59rxhJqNobqH07UVhSMHaj dLpuQI28mZV7kOYQ5SKWmJl6DS7Qw0UaD4F9TFFjUcIN+pwsg85ADSWGP9KAyY2DblBu Tac+T4Z1IZPrRALfF6wttyNZ1yEr9WkdXZB5EubfLeVZrsqBJ8QIy0DbqQTjUOUTr3kC eFhw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761744599; x=1762349399; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=pGT1Q00IC6LDnjdFWxUOjb5QFrLGOdHjb0pQOx42n/A=; b=GZKPVp/a3nCFjWZ25tfItcWrbu+o9mgqr7YaAzGjgGfMXPSc4XBjHI6XpaWoNEIKuB Tej6w7tBynsuSvNdZC1VK+EmzT5nDdh7w39dr1w5mHJIDtFMkYBFdWuxY9rC3NRAH0+o QgTPKgF5r7Bzr9AXYZ6Q2JBH0A3OWe/bSXqFxeD1VNgxKyqkfS2l/OxBsv/hB/LJEXan 6t0A9PygpPRGFX367Icvm07RVp6jFBnn5c8X3TScfdog/JxzHyloX2Ww5hWbUsc6Tb+i pPXlOQkpOI8SEtKJbFAwNkJkHX1bK3GsZAJJSKqL0o5eTFd1JDt1MnjU9QwzKtq/iQbx fUWg== X-Forwarded-Encrypted: i=1; AJvYcCU9SQ+iRjs2ZQ+OOIGkzp3k5wATerZfJRaO/nqtng780BPrl9Q3WJIwATQIvAy/yv+MYkUu5RTym3VomIwz@lists.postgresql.org X-Gm-Message-State: AOJu0YxIZ3yoq4vzuc1ALpFtPyeAPo8bFTgm8p1mbtqEQ8fTHoA+GXup xIb5y/UPPdSNyfYCTe9c6xAyuVf2I6sCNGSAf0TojG38zoIGGFBry3+tXP2r46vfCar3PZ+eAz9 xFaCdU2Rt2tO6DvYs5b4CjX26bBE2JNbq9Q== X-Gm-Gg: ASbGnctrjTVI+eczkTlaRVNCBEYHn+Dv1IKx7J509lEp3xUUrUSafta6SDqppvlAlk2 SrYvnA+JVP4dR6jTSKCir+jFCxwd8J5Dztsf/FzfT0HWi2smVDvncVLT8Ipxh6WIDkJXhodSkFJ lc5KIteb7pnovXhyO12H2gQSIhwTmsu6vaFNR6VAnjnHGbMOCVvDU12h4G5Av9wrw/QvStg1p0w iWU8MVty/Af0xWbr8NiWTcO/W0getSinBci6UYKjf9un1aw7aqd24t58ZDIPrE= X-Google-Smtp-Source: AGHT+IE2nRruamjesCHPTAyPdmja8lkiLoxH9CJOOmgi9HYLUcXRKkS8C5hutGK3qy2vEHQQgrltAGOG5tyvFH1i2cQ= X-Received: by 2002:a05:6808:4fde:b0:438:3b4c:c414 with SMTP id 5614622812f47-44f7a4019d9mr1360609b6e.18.1761744599155; Wed, 29 Oct 2025 06:29:59 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dominique Devienne Date: Wed, 29 Oct 2025 14:29:46 +0100 X-Gm-Features: AWmQ_bl2yD_4RMFWRC7wrOqodbZWasERtDNHxYaiDO_EmbVTY0sEmA5enbqv4QY Message-ID: Subject: Re: Two sequences associated with one identity column To: "kurt thepw.com" Cc: "Colin 't Hart" , PostgreSQL General Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Oct 29, 2025 at 2:17=E2=80=AFPM kurt thepw.com wro= te: > 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 se= quence 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