Serials are a great datatype but when using them you sometimes get
non-consecutive numbers. I understand some of the reasons for this.
Is there a (simple) way to re-sequence a serial column that is the
primary key for a table so that the numbers are all consecutive?
I don't mnind having holes but once in a while I'd like to re-sequence
the table so that the current numbes in use become consecutive.
Just asking ...
Thanks!
Jc