pgsql: Improve documentation about PRIMARY KEY constraints. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Improve documentation about PRIMARY KEY constraints.
Date
Msg-id E1aSWU7-0003hv-Fj@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Improve documentation about PRIMARY KEY constraints.

Get rid of the false implication that PRIMARY KEY is exactly equivalent to
UNIQUE + NOT NULL.  That was more-or-less true at one time in our
implementation, but the standard doesn't say that, and we've grown various
features (many of them required by spec) that treat a pkey differently from
less-formal constraints.  Per recent discussion on pgsql-general.

I failed to resist the temptation to do some other wordsmithing in the
same area.

Branch
------
REL9_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/f6c7bfb597a365b6dd2b8e1c2e00582d39b05ba0

Modified Files
--------------
doc/src/sgml/ddl.sgml              | 58 ++++++++++++++++++++------------------
doc/src/sgml/ref/create_table.sgml | 26 ++++++++---------
2 files changed, 44 insertions(+), 40 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix deparsing of ON CONFLICT arbiter WHERE clauses.
Next
From: Tom Lane
Date:
Subject: pgsql: Improve documentation about PRIMARY KEY constraints.