Re: Why sequence jumps?

From: Mungo Henning <mungoh_at_itacs.strath.ac.uk>
Date: Thu, 01 Jul 1999 15:24:19 +0100
Message-ID: <377B7A13.C1D664DF_at_itacs.strath.ac.uk>


Mark G wrote:

> I tbink you mean pre-insert.
>
> M
>
> Muhammad Ismail Thahim wrote in message <377994FA.D707E63C_at_super.net.pk>...
> >use code in the post insert trigger
>

[Quoted] Does the suggestion of assigning the primary key from a sequence via a pre-insert trigger guarantee no gaps in sequence numbers, or does it help cut down on the quantity of gaps? Ultimately, if you cannot tolerate any gaps at all I fail to understand how deferring acquisition of a sequence number to a pre-insert time will stop the wasting of this number should a rollback be done.

I've been wrong before... corrections humbly requested.

Mungo Henning

--
Mungo Henning - it's a daft name but it goes with the face...
mungoh_at_itacs.strath.ac.uk.http://www.itacs.strath.ac.uk/
(since everyone else does it) I speak for me, not my employer.
Received on Thu Jul 01 1999 - 16:24:19 CEST

Original text of this message