Re: Doc patch: Document names of automatically created constraints and indexes - Mailing list pgsql-hackers

From Karl O. Pinc
Subject Re: Doc patch: Document names of automatically created constraints and indexes
Date
Msg-id 1352742144.21373.3@mofo
Whole thread Raw
In response to Re: Doc patch: Document names of automatically created constraints and indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Doc patch: Document names of automatically created constraints and indexes  (Peter Eisentraut <peter_e@gmx.net>)
List 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




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Further pg_upgrade analysis for many tables
Next
From: "Karl O. Pinc"
Date:
Subject: Re: Suggestion for --truncate-tables to pg_restore