Re: Doc patch: Document names of automatically created constraints and indexes

Karl O. Pinc <kop@meme.com>

From: "Karl O. Pinc" <kop@meme.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org
Date: 2012-11-12T17:42:24Z
Lists: pgsql-hackers
On 11/12/2012 10:40:00 AM, Tom Lane wrote:
> "Karl O. Pinc" <kop@meme.com> writes:
> > Attached is a patch (against head) which documents the
> > name of the constraint and index created when using
> > PRIMARY KEY with CREATE TABLE, and the name of the
> > index created when using UNIQUE. 

> Personally I don't think this should be documented, as it's an
> implementation detail that we've changed in the past and may change
> again.

Ok.  

Could ALTER TABLE use an option to drop the
primary key constraint?  I needed to do that,
found it was not obvious, and this lead me to 
try to improve things.


Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein