Re: SEQUENCE NAME syntax not documented for ALTER TABLE - Mailing list pgsql-docs

From Tom Lane
Subject Re: SEQUENCE NAME syntax not documented for ALTER TABLE
Date
Msg-id 554780.1742743897@sss.pgh.pa.us
Whole thread Raw
In response to SEQUENCE NAME syntax not documented for ALTER TABLE  (Rene Saarsoo <nene@triin.net>)
Responses Re: SEQUENCE NAME syntax not documented for ALTER TABLE
List pgsql-docs
Rene Saarsoo <nene@triin.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



pgsql-docs by date:

Previous
From: Rene Saarsoo
Date:
Subject: SEQUENCE NAME syntax not documented for ALTER TABLE
Next
From: Rene Saarsoo
Date:
Subject: Re: SEQUENCE NAME syntax not documented for ALTER TABLE