Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2017

    Unanswered: Sequence value skipped to a increment in lakhs

    This is regarding the problem we faced in PostrgreSql where the sequence value got skipped to a value having a difference in lakhs causing the table to be inaccesiible.This problem occurred in only few of the tables which had sequences only.Can anyone suggest regarding this what could be the problem and how to avoid it?

  2. #2
    Join Date
    Nov 2003
    Provided Answers: 23
    There is no problem. A sequence is expected to skip values. There is nothing wrong with that.

    If you rely on a gapless numbering, then a sequence is the wrong choice.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags:

    Tips for good questions:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts