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
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 |