title: Index behaviour (create and drop) on postgres partitioned tables
body: <p>I have large postgres table, which is partitioned.<br>
  The table is indexed.<br>
  Indexes are created for each partition separately.<br>
  My question is:  </p>
  
  <p>When indexes are created, they also get created on child tables.<br>
  While dropping it is dropping only specified index in drop statement.<br>
  And showing </p>
  
  <pre><code>WARNING:  Only dropped the index "my_index_name"
  HINT:  To drop other indexes on child partitions, drop each one explicitly.
  DROP INDEX
  </code></pre>
  
  <p>How to drop indexes on child paritions, without dropping it one-by-one (as I have 255 child tables)</p>