title: Can't rename table in RedShift
body: <p>I run the following command through python3.3 psycopg2 package:</p>
  
  <pre><code>ALTER TABLE my_schema.tbl_old RENAME TO tbl_new
  </code></pre>
  
  <p>Before the command is run, my python code makes sure tbl_new does not exist.
  However, I get the following error:</p>
  
  <pre><code>relation "tbl_new" already exists
  </code></pre>
  
  <p>Table structure:</p>
  
  <pre><code>bipilot=# select * from PG_TABLE_DEF where tablename='tbl_old';
   schemaname | tablename |    column    |     type      | encoding | distkey | sortkey | notnull
  ------------+-----------+--------------+---------------+----------+---------+---------+---------
   my_schema  | tbl_old   | price        | numeric(10,2) | lzo      | f       |       0 | f
   my_schema  | tbl_old   | price_date   | date          | none     | f       |       1 | f
   my_schema  | tbl_old   | product_id   | smallint      | delta    | f       |       0 | f
  </code></pre>
  
  <p>No indices are defined.</p>
  
  <p>Also, when I run the same RENAME command from psql shell, it works well.</p>
  
  <p>Anyone can explain this strange behavior?</p>
  
  <p>Thanks!!!</p>