Re: Get block of N numbers from sequence

Boszormenyi Zoltan schrieb:
> Thomas Guettler írta:
>> Hi,
>>
>> how can you get N numbers (without holes) from a sequence?

> # create sequence tmp_seq cache 1000;

Hi,

"alter SEQUENCE ...  cache 100" survives a rollback. That's something I like to avoid:

foo_esg_modw=# select * from foo_isu_isu_id_seq; begin; alter SEQUENCE foo_isu_isu_id_seq  cache 100; rollback; select
*
from foo_isu_isu_id_seq;
     sequence_name      | last_value | increment_by |      max_value      | min_value | cache_value | log_cnt |
is_cycled | is_called

------------------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
 foo_isu_isu_id_seq |   90508740 |            1 | 9223372036854775807 |         1 |           1 |       6 | f         |
t

BEGIN
ALTER SEQUENCE
ROLLBACK
     sequence_name      | last_value | increment_by |      max_value      | min_value | cache_value | log_cnt |
is_cycled | is_called

------------------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
 foo_isu_isu_id_seq |   90508740 |            1 | 9223372036854775807 |         1 |         100 |       6 | f         |
t



--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de