Re: https://www.postgresql.org/docs/current/functions-sequence.html - Mailing list pgsql-docs

From Roger Pack
Subject Re: https://www.postgresql.org/docs/current/functions-sequence.html
Date
Msg-id CADCGFBU=e6=TUp-vuqrtKimzYBy5uGrCO2VWgZwyB59opRmSqw@mail.gmail.com
Whole thread Raw
In response to Re: https://www.postgresql.org/docs/current/functions-sequence.html  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-docs
Okey dokey
Thanks!

On Mon, Oct 19, 2020, 2:53 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Oct 19, 2020 at 1:13 PM PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/functions-sequence.html
Description:

This page:
https://www.postgresql.org/docs/current/functions-sequence.html
doesn't seem to mention that there's a way to get the "cross session"
current value of a sequence:
https://stackoverflow.com/a/12482716/32453


That page says "sequences are single row tables" which means you can query them, it also links to CREATE SEQUENCE where "SELECT * FROM sequence_name" is described explicitly, plus there is the implied existence of catalog entries.  That seems sufficient given that such usage is not all that useful and so less is more when it comes to pointing it out to users who should just stick to the provided functions.

David J.

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: https://www.postgresql.org/docs/current/functions-sequence.html
Next
From: PG Doc comments form
Date:
Subject: Please add best practice concerning user accounts