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.96) (envelope-from ) id 1wCIC4-001qAA-2r for pgsql-bugs@arkaria.postgresql.org; Mon, 13 Apr 2026 14:23:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wCIC3-007Kgn-0p for pgsql-bugs@arkaria.postgresql.org; Mon, 13 Apr 2026 14:23:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wCIC3-007Kgf-05 for pgsql-bugs@lists.postgresql.org; Mon, 13 Apr 2026 14:23:15 +0000 Received: from mail-yx1-xb135.google.com ([2607:f8b0:4864:20::b135]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wCIC1-00000000oNC-3hFh for pgsql-bugs@lists.postgresql.org; Mon, 13 Apr 2026 14:23:15 +0000 Received: by mail-yx1-xb135.google.com with SMTP id 956f58d0204a3-6501547d7edso4302277d50.0 for ; Mon, 13 Apr 2026 07:23:14 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776090193; cv=none; d=google.com; s=arc-20240605; b=YFyfcNCItRWEOqPxk7S7q3IbOZKjeoFP3wPmZzUo6MwFcq+mktEnXYgKBPio/7ZjJr tr+e89yBG0bTUmTmSlZX1AhDBolIOpVoQk2mIG+NdGYSFh6Zto9mjkJzvFbp1doc7FeW 1T93S8yBESKxbV4dD2jThAzwDLm9JyYFSNO2lPZ91om5ETrw59b4wE24/7lQ2hK5Xy8y MSAnhQdtNR7zJ8oU8ikWHNoaPrMrDDEG9mlNX/fcEqhCD7jpSwz5yEud1wzed7EtxIjl 6G2SbO4mBzZnpFtYU7KiGJB4QDpqLQQ6R8H6KKkyI+XPZNSpevJJwJhl+H49w/A2iHiw Txlg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:references:in-reply-to:mime-version :dkim-signature; bh=JApsmK/8Gvc8imTkoEFJrBYGXkQcuPPuFA/Wxjjf7u4=; fh=zNJFuktm0hvAKpHaCmQdYo0v7O24lx767hPZ+uOiU4Y=; b=ho5qJUeEH7bIxV9phQtrZPyYTnSsod65zhhFlVm3y57gvzBDpaLzPyVFJ0f7rxYEry LvX6+7i2x0Hw4T/OroxiiCB366zicW6ncG938MJ4PJbVlURt4EDEXeqwZEBGQHYKdBnt qXKHvKWW/sfXMREZlbaoLTneWHczdZC6JNUJZ5DPIuh3yEoAVmfvB18W9lnCvhxtQnWS xzEOpHCuEcycIYzfLkXAL49gwQS2qK8uFDdSaRA+qJA2lLF4gR8wG44Ar3RRuh3J/fYi naHcxpCiY2n63An0a8aCPsaVTCaa5DLggJYlj2nS4ULuQouwJUl3ier1AgmIavYFfNGO 2Xvg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1776090193; x=1776694993; darn=lists.postgresql.org; h=to:subject:message-id:date:from:references:in-reply-to:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=JApsmK/8Gvc8imTkoEFJrBYGXkQcuPPuFA/Wxjjf7u4=; b=lowWbSi2cExcu8xdrFIAVSPMfcnJ67uiX0PnltamT+HsbA/liuuWBFctaP5TFcQ9lk tDeXPmojh7WD72lh72r95dA7LxuyHBbaQYaaaVHl0yBZxfTzq3J3wlnMbqLCK8CcA5LO cPnkkoN8PgalI02WVHvisdxUk+bp1VTuX0XHPUvcWNffWTpGUCJwIu1p1V/Vz4UX5zHz U4YM3DApK738uFaYBdC2+tDQpgaZ9pXEuKy0QM7s3gTURRqfgCr/WaWt2VsP71ZyhY44 O9qExUU3/Gu1Pk0VgNv0K7TimtlgPv3bIL8rqk/8vySZUfmptGOJZkOH20BZn/QkTsUf Q7Rw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776090193; x=1776694993; h=to:subject:message-id:date:from:references:in-reply-to:mime-version :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=JApsmK/8Gvc8imTkoEFJrBYGXkQcuPPuFA/Wxjjf7u4=; b=cEdjDwl2/kwz3dr7daJbr//cPvGIjIpH+ehgcAzIVrKge0BlgV7pRStUIm+zDm37tK vVkmL0EfUkza8/PALkWP/hWvNdGqagT0kYyTxP88Qa5jcACby77Xbax5Tu5U2JOtvwTJ 1h2P7I908Mv78wfEa5t4Uw9EPhyZyo1HvVtjfoqiK11DstXTh71tQBa0DUpjwh/5w0mj R8AzIY0u50ayFoS4PzNzkMIC6uG+HMBX0ALh9yeLybtCDseQ7NJgxWVV8vtKJpuMO2fv qS4rFFv8TDqaw2ipFrF+CogSMEhlxflKzNmYaBM2GfYI/oRJTZIvmDZiW+ZvmaMXfPZ2 wLcw== X-Forwarded-Encrypted: i=1; AFNElJ+v4GWLa3zAitAAXlXsro8c1Ksvn17f7k7adllAxAfAMF4d2pW8BLVF5Ux/cUqExGO459XUKbi2x+oc@lists.postgresql.org X-Gm-Message-State: AOJu0Yw2usBvjatXpTq1cRKu1ObO23StgLvB1WHmBAk/jKjcZGaintgz UtWnnX79L4PCGPMT8bOXxv9OgMI9I0WC094w/O+PPA5ky1HBQGxoY9WZVhgQEw0KNkELQBZ6/JZ Z/H5FMnkZoLkIMs1v509ejC7XD9P54QlsGg== X-Gm-Gg: AeBDievgBz2tSltX5odXt/NlxaRXxuzEwWLwcYJc7WJcNyCHkC/MdCW9mLjvWXK4jmM masZ0RzqBz/rIT5pt7m7eNoPjpemfbntUBbWd0pKkq/GjiMvcm2CiQR1eJjAkk2LZXGRg4zvDRh AqCi6Z2LhPvMAknFQTXfAlPAcR+HnmjeD3zZI+/rtR54CMykfveMxv3TteEz6o5mlW2nZaNhEfk utq//Shd5dYETVgXXd7PV8gVLJDLpYBRB528A+iju0/pV2ALRmM+P9TbcPYQrnHXLUBoqjU1nfl J/2TAIA= X-Received: by 2002:a05:690e:419b:b0:651:ba8b:a950 with SMTP id 956f58d0204a3-651ba8baeeemr6279470d50.60.1776090193310; Mon, 13 Apr 2026 07:23:13 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:7010:5da4:b0:514:8c04:fb49 with HTTP; Mon, 13 Apr 2026 07:23:11 -0700 (PDT) In-Reply-To: <19455-8dabf39f306c3ccc@postgresql.org> References: <19455-8dabf39f306c3ccc@postgresql.org> From: "David G. Johnston" Date: Mon, 13 Apr 2026 07:23:11 -0700 X-Gm-Features: AQROBzBjTziQk8GlGCM2bPkDdj7ksZRfWX7UBPgga5hR6a--wba3C9OoEzBXoKM Message-ID: Subject: Re: BUG #19455: ALTER TABLE RENAME will rename a sequence To: "bsislow@accertify.com" , "pgsql-bugs@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000000fb879064f5839d3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000fb879064f5839d3 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, April 13, 2026, PG Bug reporting form wrote: > The following bug has been logged on the website: > > Bug reference: 19455 > Logged by: Bob Sislow > Email address: bsislow@accertify.com > PostgreSQL version: 15.2 > Operating system: Red Hat Enterprise Linux release 8.7 (Ootpa) > Description: > > Is this expected behavior? ALTER TABLE RENAME will rename a sequence. It=E2=80=99s documented: https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-= DESC-RENAME Arguably it=E2=80=99s better to use alter sequence so the somewhat buried documentation for this seems ok. David J. --0000000000000fb879064f5839d3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, April 13, 2026, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:=C2=A0 =C2=A0 =C2=A0 19455
Logged by:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Bob Sislow
Email address:=C2=A0 =C2=A0 =C2=A0 bsislow@accertify.com
PostgreSQL version: 15.2
Operating system:=C2=A0 =C2=A0Red Hat Enterprise Linux release 8.7 (Ootpa)<= br> Description:=C2=A0 =C2=A0 =C2=A0 =C2=A0

Is this expected behavior? ALTER TABLE RENAME will rename a sequence.

It=E2=80=99s documented:

https://www.postgresql.org/docs/current/sql-alter= table.html#SQL-ALTERTABLE-DESC-RENAME

Argu= ably it=E2=80=99s better to use alter sequence so the somewhat buried docum= entation for this seems ok.

David J.
--0000000000000fb879064f5839d3--