title: Changing minvalue of Postgres's sequence
body: <p>I am trying to change minimum value of an existing sequence.</p>
  
  <p>First I tried</p>
  
  <pre><code>ALTER SEQUENCE product_id_seq MINVALUE 10000;
  </code></pre>
  
  <p>and I got <code>ERROR: START value (1) cannot be less than MINVALUE (10000)</code>.</p>
  
  <p>So I tried</p>
  
  <pre><code>ALTER SEQUENCE product_id_seq MINVALUE 10000 RESTART WITH 10000;
  </code></pre>
  
  <p>but got the same error.</p>
  
  <p>Of course I could just drop it and create a new one, but I think there should be a way to do this. I am using Postgres 8.4.7.</p>