This page in other versions: 0.9 / 1.0 / 1.0.3

10.5. Global sequence limitations

A few limitations and caveats apply to global sequences at time of writing, in addition to those discussed in when to use global sequences:

Only an INCREMENT of 1 (the default) is supported. Client applications that expect a different increment must be configured to handle increment 1. An extended variant of nextval that takes the number of values to obtain as an argument and returns a set of values is planned as an extension to aid in porting.

MINVALUE and MAXVALUE are locked at their defaults and may not be changed.

The CACHE directive is not supported.

nextval calls may fail with an ERROR on a global sequence, either when newly created or when there are connectivity problems between nodes. This is not possible for normal PostgreSQL sequences. See Global Sequence Voting for details. This limitation may be lifted in a later BDR release by allowing global sequence allocations to wait until ready instead of producing an error.