SEO

#1 (**permalink**) 04-09-2008, 07:31 AM

Can anyones suggest some readings about implementing
sequences w/o holes ?

thanx in advance.

#2 (**permalink**) 04-09-2008, 07:31 AM

Marian Naghen schrieb:
> Can anyones suggest some readings about implementing
> sequences w/o holes ?

not w/o a busload of race conditions and/or heavy locking.
Usually you want to avoid this.
So are you really sure you dont just want if for cosmetics?

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

#3 (**permalink**) 04-09-2008, 07:31 AM

On Dec 19, 2005, at 20:14 , Marian Naghen wrote:

> Can anyones suggest some readings about implementing
> sequences w/o holes ?

Check the mailing list archives. In short, if you want to guarantee
no holes, you don't use sequences. IIRC, the process is:
1. Set up another table (foo) that holds the current value.
2. To grab a new value, increment the current value in foo and use
the current value in your insert within a transaction.

If you delete rows from your table, you'll need to do some updating
if you want to maintain having no holes.

Michael Glaesemann
grzm myrealbox com

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode