Here's an interesting problem... in a perfect world, the ID sequence for
a primary key in a table should increase (usually) monotonically, and
always be under the control of the DB. However, if for whatever reason,
you have to edit a table or reset the table without manually resetting
the
I don't think that this is something that's even supported by the
database wrt sequences. In any way, doing a:
SELECT max(id) FROM tablename;
Isn't that much of a deal, is it?
On 05 May 2007, at 19:43, David HM Spector wrote:
Here's an interesting problem... in a perfect world, the ID