Re: Postgres 11: Table Partitioning and Primary Keys
| От | David G. Johnston |
|---|---|
| Тема | Re: Postgres 11: Table Partitioning and Primary Keys |
| Дата | |
| Msg-id | CAKFQuwZfzNGTTo4zVn0Q=wfXujfaKdFbn7v5eAp20Eud7r95cA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Postgres 11: Table Partitioning and Primary Keys (Michael Paquier <michael@paquier.xyz>) |
| Ответы |
Re: Postgres 11: Table Partitioning and Primary Keys
Re: Postgres 11: Table Partitioning and Primary Keys |
| Список | pgsql-docs |
On Mon, Jul 8, 2019 at 7:59 PM Michael Paquier <michael@paquier.xyz> wrote:
Attached is an idea of patch for the documentation, using this
wording:
+ <listitem>
+ <para>
+ When defining a primary key on a partitioned table, the primary
+ key column must be included in the partition key.
+ </para>
+ </listitem>
If somebody has any better idea for that paragraph, please feel free.
Reads a bit backward. How about:
"As uniqueness can only be enforced within an individual partition when defining a primary key on a partitioned table all columns present in the partition key must also exist in the primary key."
David J.
В списке pgsql-docs по дате отправления: