From: Richard Broersma Jr <rabroersma@yahoo.com>
To: Scott Marlowe <smarlowe@g2switchworks.com>
To: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
Cc: pgsql-sql@postgresql.org
Subject: Re: Serial
Date: Tue, 3 Apr 2007 08:24:42 -0700 (PDT)
Message-ID: <407615.82627.qm@web31803.mail.mud.yahoo.com> (raw)
In-Reply-To: <1175609839.22459.3.camel@state.g2switchworks.com>
--- > Yes there is, and you generally shouldn't do it. There are issues with
> race conditions and misreferenced data that can happen when you try to
> reuse sequence numbers.
>
> Sadly, some poorly defined business processes require this.
>
> Are you required to have sequential numbers, or is just something that
> feels good / looks good?
The following link develops the use of a gapless sequence:
http://www.varlena.com/GeneralBits/130.php
Regards,
Richard Broersma Jr.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rabroersma@yahoo.com, smarlowe@g2switchworks.com, shavonne.marietta@studioform.it
Subject: Re: Serial
In-Reply-To: <407615.82627.qm@web31803.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox