Re: List last value of all sequences - Mailing list pgsql-general

>> The main problem with this approach is that, while you get the
>> "current value", the sequence is incremented by the call. I just want
>> to (strictly) look at the value.
>
> The sequence values do not change: test it for yourself.

I guess nothing beats empirical evidence! I was basing my comments on my
(mis?)understanding of what the documentation says.

>>  IF  l_last_value = 0 THEN
>>    PERFORM setval(l_sequence_name,1, False);
>>  ELSE
>>    PERFORM setval(l_sequence_name,l_last_value);
>>  END IF;
>
> Pretty good idea; just beware of sequences that do not start at 1 :)
>

Good point. I think I can deal with that. Thank you.

~Berend Tober