public inbox for [email protected]
help / color / mirror / Atom feedFrom: Dave Cramer <[email protected]>
To: [email protected]
To: [email protected]
Subject: Re: SELECT last_value FROM sequence_name;
Date: Mon, 12 Apr 2021 05:10:53 -0400
Message-ID: <CADK3HHJ1Y45Ka9bJ3_bo3GuM8ea=xK9gkodwmhCZ5hc7evoBAg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
On Mon, 12 Apr 2021 at 04:50, PG Doc comments form <[email protected]>
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-inse...
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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: SELECT last_value FROM sequence_name;
In-Reply-To: <CADK3HHJ1Y45Ka9bJ3_bo3GuM8ea=xK9gkodwmhCZ5hc7evoBAg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox