| From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
|---|---|
| To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Shavonne Marietta Wijesinghe <shavonne(dot)marietta(at)studioform(dot)it> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Serial |
| Date: | 2007-04-03 15:24:42 |
| Message-ID: | 407615.82627.qm@web31803.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
--- > 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2007-04-03 16:16:06 | Re: Update problem. |
| Previous Message | Scott Marlowe | 2007-04-03 14:17:19 | Re: Serial |