Greenplum management Sequence

Greenplum management sequence does not support currval and lastval. It only supports nextval and cannot be used in update and delete statements. If sorting is enabled, the sequence cannot be used in the update or delete statements. Gtlions = # create sequence sq1 start 1; CREATE SEQUENCEgtlions = # select * from sq1; sequence_name | last_value | percent | max_value | min_value | cache_value | log_cnt | percent + ------------ + percent + ----------- + percent + --------- + ------------- + ----------- sq1 | 1 | 9223372036854775807 | 1 | 1 | 1 | f (1 row) gtlions = # select nextval ('sq1'); nextval --------- 1 (1 row) gtlions = # insert into t1 values (nextval ('sq1'), 'A', 19, date ('1970-01-01 '); INSERT 0 1 gtlions = # insert into t1 values (nextval ('sq1'), 'A', 19, date ('1970-01-01 '); INSERT 0 1 gtlions = # alter sequence sq1 restart with 1; ALTER SEQUENCEgtlions = # select * from sq1; sequence_name | last_value | percent | max_value | min_value | cache_value | log_cnt | percent + ------------ + percent + ----------- + percent + --------- + ------------- + ----------- sq1 | 1 | 9223372036854775807 | 1 | 1 | 1 | f (1 row) -EOF-