Re: One sequence per table?

On 19 Aug 2005 01:49:18 -0700, "sim" <jmenker_at_muenster.de> wrote:

>... I try to avoid the usage of sequences anyway because I hate it
>that there a gaps in the IDs when I delete rows and insert new ones.

prerequisite: we rebuild dev databases from scratch periodically

test: I like to change starting value, increment and direction of sequence values from time to time ad then recreate the schema, just to see, if some erratic code relies on any of these

hahaha

--
Marc Blum
mailto:blumXXXSPAMXXX_at_marcblum.de
http://www.marcblum.de