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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
