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
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
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