title: SQLite increment Integer Primary Key and Unique Constraint conflict
body: <p>I have a SQLite database.
  When writing move rows function, which moves rows from one table to another I need to have a query for incrementing column with name "row" which is INTEGER PRIMARY KEY, but there is an error. It is critical to have indexing with row in my task. The condition in example is <code>WHERE row &gt;= 2</code> because i am inserting rows from other table into position 2.</p>
  
  <p><code>"UPDATE '4' SET row = row + 1 WHERE row &gt;= 2"</code></p>
  
  <p><code>Error("19", "Unable to fetch row", "UNIQUE constraint failed: 4.row")</code></p>
  
  <p>The problem's origin <code>WHERE row &gt;= 2"</code> part. How to overcome this problem?</p>