On Thu, Apr 07, 2005 at 07:59:52PM -0400, Matthew Terenzio wrote:
> I'm noticing that a sequence is advancing even if the insertion
> fails. Is this weird or expected?
It's expected. Sequences are guaranteed to generate unique IDs.
These happen to be an increasing sequence of integers, but there is no
attempt to make this a gap-free sequence, and your apps should not
depend on the actual value of said ID.
HTH :)
Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!