Re: Partitioning WIP patch (was: Partitioning: issues/ideas) - Mailing list pgsql-hackers

On 24-02-2015 PM 05:13, Amit Langote wrote:
> -- partitions
> CREATE TABLE parent_monthly_xxxxx_201401 PARTITION OF
> parent_monthly_00100_201401 FOR VALUES BETWEEN (2014, 1) AND (2014, 2);
> 
> CREATE TABLE parent_monthly_xxxxx_201402 PARTITION OF
> parent_monthly_00100_201402 FOR VALUES BETWEEN (2014, 2) AND (2014, 3);
> 
> CREATE TABLE parent_monthly_xxxxx_201403 PARTITION OF
> parent_monthly_00100_201403 FOR VALUES BETWEEN (2014, 3) AND (2014, 4);
> 
> <snip>
> 
> CREATE TABLE parent_monthly_xxxxx_yyyymm PARTITION OF
> parent_monthly_00100_yyyymm FOR VALUES BETWEEN (yyyy, mm AND (yyyy, mm);
> 

Oops, hand-edited "PARTITION OF parent_monthly_" wrongly. Supposed to be -

CREATE TABLE parent_monthly_xxxxx_201401 PARTITION OF
parent_monthly_xxxxx FOR VALUES BETWEEN (2014, 1) AND (2014, 2);

and so on.

Thanks,
Amit