콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
1 회신
6905 화면

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
5091
0
1월 23
94
1
10월 22
4344
0
4월 22
2888
2
3월 25
2967