usls_200602_idx;
...
</pre><p>

     This technique can be used with <code class="literal">UNIQUE</code> and
     <code class="literal">PRIMARY KEY</code> constraints too; the indexes are created
     implicitly when the constraint is created.  Example:
</p><pre class="programlisting">
ALTER TABLE ONLY measurement ADD UNIQUE (city_id, logdate);

ALTER TABLE measurement_y2006m02 ADD UNIQUE (city_id, logdate);
ALTER INDEX measurement_city_id_logdate_key
    ATTACH PARTITION measurement_y2006m02_city_id_logdat