Postgres手动更改顺序 [英] Postgres manually alter sequence

问题描述

我正在尝试将序列设置为特定值.

I'm trying to set a sequence to a specific value.

SELECT setval('payments_id_seq'), 21, true

这给出了一个错误:

ERROR: function setval(unknown) does not exist

使用ALTER SEQUENCE似乎也不起作用?

ALTER SEQUENCE payments_id_seq LASTVALUE 22

这怎么办?

参考: https://www.postgresql.org/docs/current/static/functions-sequence.html

推荐答案

括号放错了位置:

SELECT setval('payments_id_seq', 21, true);  # next value will be 22

否则，您将使用单个参数调用setval，而它需要两个或三个参数.

Otherwise you're calling setval with a single argument, while it requires two or three.

这篇关于Postgres手动更改顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！