Thread: 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:
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.