> > I assume you meant "...right after the column name"? > > I will modify the grammar to allow that way then, so that the following > will work: > > create table p1 partition of p ( > a primary key > ) for values in (1); >
That seems to be non-intuitive as well. The way it's written it looks like "a primary key" is associated with p rather than p1. Is there any column constraint that can not be a table constraint? If no, then we can think of dropping column constraint syntax all together and let the user specify column constraints through table constraint syntax. OR we may drop constraints all-together from the "CREATE TABLE .. PARTITION OF" syntax and let user handle it through ALTER TABLE commands. In a later version, we will introduce constraint syntax in that DDL. -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
