On Tue, Nov 25, 2003 at 18:37:41 -0500, "Burr, Colin" <[EMAIL PROTECTED]> wrote: > > However, even though the new record failed to be inserted into the table, > the sequence generator was still updated. > > The sequence generator should only be updated if the record is successfully > inserted into the table, and should not be updated if the insert fails.
That isn't how sequences work. If you need a sequence of numbers without gaps then you need to use something else. Note that the something else will need to have a way to let only one transaction at a time update the counter which may be a performance problem. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
