title: Cannot resolve table name close to
body: <p>I want to create a references to foreign table. but i'm getting the following error:</p>
  
  <p>query:</p>
  
  <pre><code>CREATE TABLE category_ids (id INT, post_id INT,
                      INDEX par_ind (post_id),
                      FOREIGN KEY (post_id) REFERENCES post(id)
                        ON DELETE CASCADE
  ) ENGINE=INNODB;
  </code></pre>
  
  <p>SHOW ENGINE INNODB STATUS\G:</p>
  
  <pre><code>------------------------
  LATEST FOREIGN KEY ERROR
  ------------------------
  2013-08-23 00:11:06 7f6f49e7b700 Error in foreign key constraint of table fun/category_ids:
  FOREIGN KEY (post_id) REFERENCES post(id)
                        ON DELETE CASCADE
  ) ENGINE=INNODB:
  Cannot resolve table name close to:
  (id)
                        ON DELETE CASCADE
  ) ENGINE=INNODB
  </code></pre>
  
  <p>posts table structure </p>
  
  <pre><code>    mysql&gt; describe post;
      +-------------+-----------------------+------+-----+---------------------+----------------+
      | Field       | Type                  | Null | Key | Default             | Extra          |
      +-------------+-----------------------+------+-----+---------------------+----------------+
      | id          | int(11)               | NO   | PRI | NULL                | auto_increment |
  ...
      +-------------+-----------------------+------+-----+---------------------+----------------+
      22 rows in set (0.00 sec)
  </code></pre>