Re: Postgres 11: Table Partitioning and Primary Keys
Bruce Momjian <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.documentation,gmane.comp.db.postgresql.devel.general |
|---|---|
| Message-ID | <[email protected]> |
On Fri, Jul 5, 2019 at 09:20:07PM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/11/ddl-partitioning.html
> Description:
>
> In the documentation for Postgres 11 table partitioning, there is no mention
> of the requirement that the Primary Key of a partitioned table must contain
> the partition key.
> In fact the documentation on primary keys is so light that I am not even
> 100% sure the above is correct. If the following table is not possible in
> Postgres 11, the documentation should find some way to make that clear.
>
> -- Create partitioned table with partition key not in primary key
> create table events (
> id bigint not null default nextval('events_id_seq'),
> created_date timestamp not null,
> constraint events_pk primary key (id)
> ) partition by range (created_date);
> -- end create table
>
> I believe this should be documented in section "5.10.2.3. Limitations"
Can someone comment on this? CC to hackers.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +