Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT last_value FROM sequence_name; - Mailing list pgsql-docs

From Dave Cramer
Subject Re: SELECT last_value FROM sequence_name;
Date
Msg-id CADK3HHJ1Y45Ka9bJ3_bo3GuM8ea=xK9gkodwmhCZ5hc7evoBAg@mail.gmail.com
Whole thread Raw
In response to SELECT last_value FROM sequence_name;  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
Tree view


On Mon, 12 Apr 2021 at 04:50, 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:

Please add Note, how to get the (global) last value:
SELECT last_value FROM sequence_name;
https://dba.stackexchange.com/questions/3281/how-do-i-use-currval-in-postgresql-to-get-the-last-inserted-id

The reason this is not added is that it is incorrect to use the sequence this way. How do you know which session incremented it, or if it has been incremented since the last use ? The correct way to use a sequence is to increment it and then use currval or the like


Dave Cramer
www.postgres.rocks 

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: SELECT last_value FROM sequence_name;
Next
From: Bruce Momjian
Date:
Subject: Re: repeated info in sections 4.1.1, 4.1.2.3