Re: Clarify restriction on partitioned tables primary key / unique indexes

2022-09-04 Thread David Rowley
On Fri, 2 Sept 2022 at 22:06, David Rowley wrote: > Thanks. I ended up adjusting it to: > > "To create a unique or primary key constraint on a partitioned table," and pushed. Thanks for having a look at this Erik. David

Re: Clarify restriction on partitioned tables primary key / unique indexes

2022-09-02 Thread David Rowley
On Fri, 2 Sept 2022 at 22:01, Erik Rijkers wrote: > Minimal changes: > > 'To create a unique or primary key constraints on partitioned table' > > should be > > 'To create unique or primary key constraints on partitioned tables' Thanks. I ended up adjusting it to: "To create a unique or primary

Re: Clarify restriction on partitioned tables primary key / unique indexes

2022-09-02 Thread Erik Rijkers
Op 02-09-2022 om 11:44 schreef David Rowley: Over on [1], there was a question about why it wasn't possible to create the following table: CREATE TABLE foobar( id BIGINT NOT NULL PRIMARY KEY, baz VARCHAR NULL DEFAULT NULL ) PARTITION BY HASH(my_func(id)); The attached attempts to c

Clarify restriction on partitioned tables primary key / unique indexes

2022-09-02 Thread David Rowley
Over on [1], there was a question about why it wasn't possible to create the following table: CREATE TABLE foobar( id BIGINT NOT NULL PRIMARY KEY, baz VARCHAR NULL DEFAULT NULL ) PARTITION BY HASH(my_func(id)); The above is disallowed by 2 checks in DefineIndex(). 1. If the partitioned k