Re: BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache - Mailing list pgsql-bugs

Hello

In one DB connection:

=> CREATE SEQUENCE resource_surrogate_id_uniquifier_sequence
         AS integer
         START WITH 0
         INCREMENT BY 1
         MINVALUE 0
         MAXVALUE 79999
         CYCLE
         CACHE 5;
CREATE SEQUENCE
=> select nextval('resource_surrogate_id_uniquifier_sequence');
 nextval 
---------
       0
=> select nextval('resource_surrogate_id_uniquifier_sequence');
 nextval 
---------
       1
=> select nextval('resource_surrogate_id_uniquifier_sequence');
 nextval 
---------
       2
=> select nextval('resource_surrogate_id_uniquifier_sequence');
 nextval 
---------
       3

In another connection:

=> select nextval('resource_surrogate_id_uniquifier_sequence');
 nextval 
---------
       5
=> select nextval('resource_surrogate_id_uniquifier_sequence');
 nextval 
---------
       6

All as expected. This is how the sequence cache option works - we preallocate values for further use in current
connection.

regards, Sergei