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  (Michael Paquier <michael@paquier.xyz>)
Re: Postgres 11: Table Partitioning and Primary Keys  (Michael Paquier <michael@paquier.xyz>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgres 11: Table Partitioning and Primary Keys
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Ambiguous language in Table 8.13. Special Date/Time Inputs