跳至內容
選單
此問題已被標幟
1 回覆
6799 瀏覽次數

Friends,

How to edit the "next number" field in a sequence from,

Settings > Technical > Sequence & Identifiers > Sequence

Now i cant edit & save it..

Thanks

頭像
捨棄
作者

No 1 Know It

Everyone know that

作者

Shut up u Juan

最佳答案

I don't know if it the official solution but you can try this:

  1. Access database with something like psql or pgadmin3
  2. Find the sequence you want to reset
  3. enter query "ALTER SEQUENCE $yoursequence RESTART"

Now it should be reset to 1.

 

More information:

http://www.postgresql.org/docs/9.1/static/sql-altersequence.html

頭像
捨棄
作者

thanks

If this helped you, please mark the answer as correct.

相關帖文 回覆 瀏覽次數 活動
0
2月 23
4895
0
1月 23
94
1
10月 22
4234
0
4月 22
2779
2
3月 25
2824