finding highest value used in a postgres sequence
dochawk at gmail.com
Tue Nov 15 22:51:52 CET 2016
The postgres server defines the values used in my unqKy variable, a
In dealing with backups and a glitch already gone wrong, however, I have
found that postgres seems to remember previously used values, even after
ALTER SEQUENCE/RESET--but still assigns this enumbers.
So After I use the MAX(uniqKy)+1 to reset the sequence, a later INSERT
without specifying is throwing an error as it assigns a currently unused
The nextval/lastval/etc functions don't seem to have "maxval()" that I can
use as a new maximum.
I'd appreciate any ideas . . .
Dr. Richard E. Hawkins, Esq.
More information about the use-livecode