Re: Sequences: where do 'unused' numbers go in case of rollback

From: Francisco Piragibe <piragibe_at_iis.com.br>
Date: 1995/10/02
Message-ID: <44ps43$40j_at_news.iis.com.br>#1/1


Sequence numbers are not reusable, that is, they are lost if the transaction gets rolled back.

Sequences are not intended to be used in places where consecutive numbers are required. They have been aimed at the generation of unique ID's. If you really need consecutive numbers, you will have to store the initial numbers in a table and make the updating of that table part of your transactions. Unfortunately, this old problem continue to deserve that old solution...

Best regards Received on Mon Oct 02 1995 - 00:00:00 CET

Original text of this message