Re: [GENERAL] sequences w/o holes

2005-12-19 Thread Guido Neitzer
On 19.12.2005, at 12:14 Uhr, Marian Naghen wrote: Can anyones suggest some readings about implementing sequences w/o holes ? Question: why? I doubt that this is possible without heavy locking, which kills your performance. cug -- PharmaLine Essen, GERMANY and Big Nerd Ranch Europe - Pos

Re: [GENERAL] sequences w/o holes

2005-12-19 Thread Michael Glaesemann
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

Re: [GENERAL] sequences w/o holes

2005-12-19 Thread Tino Wildenhain
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)

[GENERAL] sequences w/o holes

2005-12-19 Thread Marian Naghen
Can anyones suggest some readings about implementing sequences w/o holes ?     thanx in advance.