On Wed, Dec 7, 2016 at 1:30 PM, Robert Haas <robertmh...@gmail.com> wrote:
> On Wed, Dec 7, 2016 at 1:20 PM, Robert Haas <rh...@postgresql.org> wrote: > > Implement table partitioning. > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > Being that table partitioning is something I'm slightly interested in, figured I'd give it a whirl. This example in the docs has an extraneous comma after the second column CREATE TABLE cities ( name text not null, population int, ) PARTITION BY LIST (initcap(name)); And the WITH OPTIONS clause does not appear to be working using another example from the docs. Not seeing any obvious typos. keith@keith=# CREATE TABLE measurement_y2016m07 keith-# PARTITION OF measurement ( keith(# unitsales WITH OPTIONS DEFAULT 0 keith(# ) FOR VALUES FROM ('2016-07-01') TO ('2016-08-01'); 2016-12-09 12:51:48.728 EST [11711] ERROR: syntax error at or near "WITH" at character 80 2016-12-09 12:51:48.728 EST [11711] STATEMENT: CREATE TABLE measurement_y2016m07 PARTITION OF measurement ( unitsales WITH OPTIONS DEFAULT 0 ) FOR VALUES FROM ('2016-07-01') TO ('2016-08-01'); ERROR: syntax error at or near "WITH" LINE 3: unitsales WITH OPTIONS DEFAULT 0 ^ Time: 0.184 ms Removing the unit_sales default allows it to work fine keith@keith=# CREATE TABLE measurement_y2016m07 PARTITION OF measurement FOR VALUES FROM ('2016-07-01') TO ('2016-08-01'); CREATE TABLE Time: 5.001 ms
