> Rather, each time you wish to do an insert,
> query the existing data to see what the
> maximum value is existing in the database.
> Add 1 to that and use this as your new value.
> This is guaranteed to not have any holes in
> the sequence.
True, but alas it _doesn't_ guarantee uniqueness, since there's nothing to prohibit 2 or more back ends getting the
samemax() at the
same time...
Thinking off the top of my head, I'm not sure you can apply FOR UPDATE to an aggregate function, so there's probably no
solutionthere, either.
Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com