Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3198)Creating anauto increment field in Firebird

[Poul D. <pd...@ta...>]

Btw... of course when a record is deleted, the wasted ID should be re-used. 
We don't want holes in the number series, do we....  Maybe all the 
successing ID's should be decremented to close the gap :)

Poul Dige


----- Original Message ----- 
From: "Paul Vinkenoog" <pa...@vi...>
To: "For discussion among Firebird Developers" 
<fir...@li...>
Sent: Thursday, October 28, 2010 4:53 PM
Subject: Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3198)Creating 
anauto increment field in Firebird


> Ann,
>
>> I have no doubt that you and the other experienced developers have
>> developed techniques to provide audible series that don't annoy
>> application users.
>
> As a user, I get pretty annoyed when my databases start making noises :-)
>
> (Sorry, couldn't resist.)
>
>
> Paul Vinkenoog
>
> ------------------------------------------------------------------------------
> Nokia and AT&T present the 2010 Calling All Innovators-North America 
> contest
> Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in 
> marketing
> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
> http://p.sf.net/sfu/nokia-dev2dev
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
>
>