Postgres Pro
Downloads
Home   >   mailing lists

Re: Get block of N numbers from sequence - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Get block of N numbers from sequence
Date
Msg-id b42b73150905200451k5a2e4707pc82f73a312da8dff@mail.gmail.com
Whole thread Raw
In response to Re: Get block of N numbers from sequence  (Thomas Guettler <hv@tbz-pariv.de>)
List pgsql-general
Tree view 
On Wed, May 20, 2009 at 3:00 AM, Thomas Guettler <hv@tbz-pariv.de> wrote:
> Thomas Guettler schrieb:
>> Hi,
>
>> how can you get N numbers (without holes) from a sequence?
>>
>
> If sequences could be locked like tables, it would be easy.

advisory locks are superior for locking sequences in almost every way....

merlin

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Providing an alternative result when there is no result
Next
From: Robert Gravsjö
Date:
Subject: Table partitioning