Re: SEQUENCE NAME syntax not documented for ALTER TABLE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rene Saarsoo <nene(at)triin(dot)net>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: SEQUENCE NAME syntax not documented for ALTER TABLE
Date: 2025-03-23 15:31:37
Message-ID: 554780.1742743897@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Rene Saarsoo <nene(at)triin(dot)net> writes:
> The documentation for ALTER TABLE [1] doesn't make it clear that the
> following is allowed:
> ...
> It only references the sequence options allowed in CREATE SEQUENCE or ALTER
> SEQUENCE, unlike the CREATE TABLE [2] documentation, which does
> specifically state [3]:

Huh? I see

<varlistentry id="sql-altertable-desc-generated-identity">
<term><literal>ADD GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY</literal></term>
<term><literal>SET GENERATED { ALWAYS | BY DEFAULT }</literal></term>
<term><literal>DROP IDENTITY [ IF EXISTS ]</literal></term>
<listitem>
<para>
These forms change whether a column is an identity column or change the
generation attribute of an existing identity column.
See <link linkend="sql-createtable"><command>CREATE TABLE</command></link> for details.

Where do you see a pointer to CREATE SEQUENCE on that page?

regards, tom lane

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Rene Saarsoo 2025-03-23 16:25:17 Re: SEQUENCE NAME syntax not documented for ALTER TABLE
Previous Message Rene Saarsoo 2025-03-23 09:50:10 SEQUENCE NAME syntax not documented for ALTER TABLE