Re: [GENERAL] Continue sequence

2007-01-05 Thread Jorge Godoy
Wilton <[EMAIL PROTECTED]> writes: > Hi, > > Which is the correct way to obtain a continue sequence without fail (hole/gap) > for a composite-id ? http://www.google.com.br/search?q=gapless+sequence+postgresql Since the first hits -- at Varlena -- aren't accessible you can use google's cache: ht

Re: [GENERAL] Continue sequence

2007-01-05 Thread Devrim GUNDUZ
Hi, On Fri, 2007-01-05 at 11:13 -0200, Wilton wrote: > Which is the correct way to obtain a continue sequence without fail > (hole/gap) for a composite-id ? http://www.varlena.com/GeneralBits/130.php may help you. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 Post

Re: [GENERAL] Continue sequence

2007-01-05 Thread Bruno Wolff III
On Fri, Jan 05, 2007 at 09:30:46 -0800, Wilton Wonrath <[EMAIL PROTECTED]> wrote: > > I think that I will need to use LOCK TABLE or SELECT FOR UPDATE, but in > both cases if the client terminal shutdown suddenly the tuple/table > stays locked on the server for a indeterminate time. You need t