Re: How to read a sequence without incrementing it?

Just FYI, SELECT last_value FROM my_sequence; is NOT transaction safe,
i.e. other transactions may increment the counter between the time you run
that query and the next that uses the value.

On Sat, 30 Aug 2003, Pierre Couderc wrote:

> Thank you all.
>
> SELECT last_value FROM my_sequence;
>
> is the good solution.
>
> (Currval() does not work as there is no nextval() before in the session)
>
>
> Pierre Couderc
>
>
> Pierre Couderc wrote:
> > I would like to read the current value of a sequence, or a value not too
> > far of the current value (for example, the value it was a few seconds or
> > minutes ago). Is it possible (without any nexrval that should increment
> > it)?
> >
> > Thank you all
> >
> > Pierre Couderc
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>