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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: rogerpack2005(at)gmail(dot)com, Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: https://www.postgresql.org/docs/current/functions-sequence.html
Date: 2020-10-19 20:52:55
Message-ID: CAKFQuwY44aACPxYWp3JoGwTj6-GOhPhJO+Of+RBLnRTrD+Sx8A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Mon, Oct 19, 2020 at 1:13 PM PG Doc comments form <noreply(at)postgresql(dot)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.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Roger Pack 2020-10-20 14:21:27 Re: https://www.postgresql.org/docs/current/functions-sequence.html
Previous Message PG Doc comments form 2020-10-19 19:31:41 https://www.postgresql.org/docs/current/functions-sequence.html