Horton

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

Erik Rijkers <er@xs4all.nl>

View thread View on postgr.es
From: Erik Rijkers <er@xs4all.nl>
To: David Rowley <dgrowleyml@gmail.com>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2022-09-02T10:01:09Z
Lists: 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

Commits

  1. Doc: clarify partitioned table limitations