title: PostgreSQL: Why not remove index?
body: <p>I hope to remove index in table, but it occurs not remove index.</p>
  
  <pre><code>CREATE INDEX idx_name ON schema_name.table_name(column1, column2);
  </code></pre>
  
  <p>And, remove index</p>
  
  <pre><code>DROP INDEX idx_name;
  </code></pre>
  
  <p>but, it fail.</p>
  
  <p>error message is</p>
  
  <blockquote>
  <pre><code>ERROR: index "idx_name" does not exist
  </code></pre>
  </blockquote>
  
  <p>How I do it?</p>