title: Getting sqlalchemy.migrate to rename a column with primary key
body: <p>I am trying to rename a column in a table which has the primary key constraint to an another name and add a new column with a new type becoming the primary key.</p>
  
  <p>So currently I have :</p>
  
  <pre><code>  TABLE (
       `id` VARCHAR(36) PRIMARY_KEY,
    ) table;
  </code></pre>
  
  <p>I want to rename <code>id</code> to <code>uuid</code> and add a new id as a integer which would become the primary key :</p>
  
  <pre><code> TABLE (
     `id` integer PRIMARY_KEY, AUTO_INCRREMENT,
     `uuid` VARCHAR(36)
   ) table;
  </code></pre>
  
  <p>Trying to do that with sqlalchemy.migrate :</p>
  
  <pre><code>table = sqlalchemy.Table('table', meta, autoload=True)
  event.c.id.alter(name='uuid')
  id = sqlalchemy.Column('id', sqlalchemy.Integer(),
                          primary_key=True)
  event_uuid.create(event)
  </code></pre>
  
  <p>result with this error in postgres since the primary key constraint wasn't removed from the old <code>id</code> :</p>
  
  <pre><code>ERROR: Column.create() accepts index_name, primary_key_name and unique_name to generate constraints
  </code></pre>
  
  <p>If somebody have an idea how to do that </p>