Re: Clarify restriction on partitioned tables primary key / unique indexes - Mailing list pgsql-hackers

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 clarify these restrictions more accurately
> based on the current code's restrictions.
> 
> If there's no objections or suggestions for better wording, I'd like
> to commit the attached.

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'


Erik