Re: [SQL] Can I prevent my sequence to increment if an insert isrejected?

Herouth Maoz wrote:
> 
> At 19:54 +0300 on 20/07/1999, Frederic De Leersnijder wrote:
> 
> > Hi,
> >
> > when I try to insert a record and it curses with fields with a unique
> > key on them my sequence I use for my primary key does increment. How can
> > I prevent this from happening?
> 
> You can't. The point of sequences is that they ensure you of unique values,
> but they DO NOT ensure you of gap-free values. This allows sequences to be
> used momentarily, without being locked for the duration of a transaction,
> thus allowing many users to get values with minimal contention.

I missed the original question, but don't you get sequential numbers as
long as cache is 0?

-- 
Chris Bitmead
mailto:chris@tech.com.au
http://www.techphoto.org - Photography News, Stuff that Matters