Re: SEQUENCE NAME syntax not documented for ALTER TABLE

On Sun, 23 Mar 2025 at 17:31, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

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

Sorry, my mistake. The page only points to ALTER SEQUENCE.

Now I also see that separate section about ADD GENERATED etc,
which I completely missed earlier. I was searching for a definition of
*sequence_options* which is nowhere to be found on that page.
So I searched for the next best thing sequence_option (in singular)
and found the SET sequence_option section. I expected the definition
of sequence_options to just be the plural of sequence_option.
But confusingly it's not.

I personally would really prefer if this information was part of the main
syntax diagram, not somewhere deep inside the text. But I might be
an odd user of the documentation as I'm trying to write a parser for
PostgreSQL.

Regards,
Rene Saarsoo