Re: SELECT last_value FROM sequence_name;

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: SELECT last_value FROM sequence_name;
Дата
Msg-id CADK3HHJ1Y45Ka9bJ3_bo3GuM8ea=xK9gkodwmhCZ5hc7evoBAg@mail.gmail.com
обсуждение исходный текст
Ответ на SELECT last_value FROM sequence_name;  (PG Doc comments form <noreply@postgresql.org>)
Список pgsql-docs


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 по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: SELECT last_value FROM sequence_name;
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: repeated info in sections 4.1.1, 4.1.2.3