Обсуждение: SELECT last_value FROM sequence_name;
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
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