title: Redshift psql auto increment on even number
body: <p>I am trying to create a table with an auto-increment column as below. Since Redshift psql doesn't support SERIAL, I had to use <a href="http://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_TABLE_NEW.html" rel="noreferrer">IDENTITY data type</a>: </p>
  
  <blockquote>
    <p>IDENTITY(seed, step)<br>
    Clause that specifies that the column is an IDENTITY column. An IDENTITY column contains unique auto-generated values. These values start with the value specified as seed and increment by the number specified as step. The data type for an IDENTITY column must be either INT or BIGINT.`</p>
  </blockquote>
  
  <p>My create table statement looks like this:</p>
  
  <pre><code>CREATE TABLE my_table(
          id INT IDENTITY(1,1),
          name CHARACTER VARYING(255) NOT NULL,
          PRIMARY KEY( id ) 
  );
  </code></pre>
  
  <p>However, when I tried to insert data into <code>my_table</code>, rows increment only on the even number, like below:</p>
  
  <pre><code> id | name | 
  ----+------+
    2 | anna |
    4 | tom  |
    6 | adam |
    8 | bob  |
   10 | rob  |
  </code></pre>
  
  <p>My insert statements look like below: </p>
  
  <pre><code>INSERT INTO my_table ( name ) 
  VALUES ( 'anna' ), ('tom') , ('adam') , ('bob') , ('rob' );
  </code></pre>
  
  <p>I am also having trouble with bringing the id column back to start with 1. There are solutions for <code>SERIAL</code> data type, but I haven't seen any documentation for <code>IDENTITY</code>.
  Any suggestions would be much appreciated!</p>