Improve documentation about PRIMARY KEY constraints.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: f6c7bfb597a365b6dd2b8e1c2e00582d39b05ba0
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2016-02-07T21:02:44Z
Releases: 9.1.20
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.

Files

PathChange+/−
doc/src/sgml/ddl.sgml modified +31 −27
doc/src/sgml/ref/create_table.sgml modified +13 −13