title: How to set auto increment primary key in PostgreSQL?
body: <p>I have a table in PostgreSQL with many columns, and I want to add an auto increment primary key.</p>
  <p>I tried to create a column called <code>id</code> of type <code>BIGSERIAL</code> but pgadmin responded with an error:</p>
  <blockquote>
  <pre><code>ERROR: sequence must have same owner as table it is linked to.
  </code></pre>
  </blockquote>
  <p>Does anyone know how to fix this issue?  How do I add or create an auto-incrementing primary key in PostgreSQL without recreating the table?</p>