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