https://www.postgresql.org/docs/current/functions-sequence.html
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
Cheers!
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.
Okey dokey
Thanks!
On Mon, Oct 19, 2020, 2:53 PM David G. Johnston <david.g.johnston@gmail.com>
wrote:
Show quoted text
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/32453That 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.