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

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Doc patch: Document names of automatically created constraints and indexes
Date: 2012-11-12 17:42:24
Message-ID: 1352742144.21373.3@mofo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/12/2012 10:40:00 AM, Tom Lane wrote:
> "Karl O. Pinc" <kop(at)meme(dot)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(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Karl O. Pinc 2012-11-12 17:45:44 Re: Suggestion for --truncate-tables to pg_restore
Previous Message Bruce Momjian 2012-11-12 17:09:08 Re: Further pg_upgrade analysis for many tables