Re: List last value of all sequences

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



> 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.


>  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 :)


- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200307241520

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE/IDPUvJuQZxSWSsgRAv1MAJ9Ax8EpRTf2ElbdeN/hjMIkWSpPqwCgqAVV
Xgese545H2Qa4Znwt1Y7AlE=
=IkFq
-----END PGP SIGNATURE-----