On 11/24/13 19:15, Simon Riggs wrote:
> On 18 November 2013 07:36, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:
>> On 14.11.2013 22:10, Simon Riggs wrote:
>>>
>>> Includes test extension which allows sequences without gaps - "gapless".
>>
>> I realize this is just for demonstration purposes, but it's worth noting
>> that it doesn't actually guarantee that when you use the sequence to
>> populate a column in the table, the column would not have gaps. Sequences
>> are not transactional, so rollbacks will still produce gaps. The
>> documentation is misleading on that point. Without a strong guarantee, it's
>> a pretty useless extension.
>
> True.
>
> If I fix that problem, I should change the name to "lockup" sequences,
> since only one transaction at a time could use the nextval.
>
> Should I change the documentation, or just bin the idea?
Just bin it. It would be useful if it could guarantee gaplessness, but I
don't see how to do that.
- Heikki