pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: phil.bayer@gmail.com
Subject: Postgres 11: Table Partitioning and Primary Keys
Date: Fri, 05 Jul 2019 21:20:07 +0000
Message-ID: <156236160709.1192.4498528196556144085@wrigleys.postgresql.org> (raw)

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"


view thread (15+ messages)  latest in thread

Message-ID: <156236160709.1192.4498528196556144085@wrigleys.postgresql.org>
Permalink:  ../156236160709.1192.4498528196556144085@wrigleys.postgresql.org/
Also on:    postgresql.org/message-id/156236160709.1192.4498528196556144085@wrigleys.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, phil.bayer@gmail.com
  Subject: Re: Postgres 11: Table Partitioning and Primary Keys
  In-Reply-To: <156236160709.1192.4498528196556144085@wrigleys.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox