y table but retain access to
     it as a table in its own right:

</p><pre class="programlisting">
ALTER TABLE measurement_y2006m02 NO INHERIT measurement;
</pre><p>
    </p><p>
     To add a new child table to handle new data, create an empty child table
     just as the original children were created above:

</p><pre class="programlisting">
CREATE TABLE measurement_y2008m02 (
    CHECK ( logdate &gt;= DATE '2008-02-01' AND logdate &lt; DATE '2008-03-01' )
) INHERITS (measurement);
</pre><p>

     Alterna