title: How to modify the value of a primary key?
body: <p>I want to modify the primary key <code>integer</code> of all rows in a table. My goal is to subtract a specific number from the <code>pk</code> and then reset it.</p>
  
  <p>Is that possible? Pseudocode:
  <code>update mytable set id = id-100;</code></p>