pg10，pg_suqences和pg_sequence

发布时间：2020-12-13 16:39:44 所属栏目：百科来源：网络整理

导读：Move sequences' metadata fields into a new pg_sequence system catalog (Peter Eisentraut) A sequence relation now stores only the fields that can be modified by nextval() ,that is last_value , log_cnt ,and is_called . Other sequence propert

Move sequences' metadata fields into a newpg_sequencesystem catalog (Peter Eisentraut)

A sequence relation now stores only the fields that can be modified bynextval(),that islast_value,log_cnt,andis_called. Other sequence properties,such as the starting value and increment,are kept in a corresponding row of thepg_sequencecatalog.ALTER SEQUENCEupdates are now fully transactional,implying that the sequence is locked until commit. Thenextval()andsetval()functions remain nontransactional.

The main incompatibility introduced by this change is that selecting from a sequence relation now returns only the three fields named above. To obtain the sequence's other properties,applications must look intopg_sequence. The new system viewpg_sequencescan also be used for this purpose; it provides column names that are more compatible with existing code.

The output ofpsql'sdcommand for a sequence has been redesigned,too.

参考https://www.postgresql.org/docs/10/static/release-10.html

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!