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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: "Karl O(dot) Pinc" <kop(at)meme(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Doc patch: Document names of automatically created constraints and indexes
Date: 2012-11-21 20:12:26
Message-ID: CA+TgmoZYqR5+ATsbXbfd1bXd711ATVTbKr+nvxjiLPuBTE0+WQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Nov 17, 2012 at 1:22 AM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> On Mon, 2012-11-12 at 11:42 -0600, Karl O. Pinc wrote:
>> 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.
>
> That could be useful, I think. But it might open a can of worms.

Would the new option be syntactic sugar around ALTER TABLE ... DROP
CONSTRAINT "put_the_name_of_the_primary_key_here"?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2012-11-21 20:16:34 WIP json generation enhancements
Previous Message Robert Haas 2012-11-21 20:09:12 Re: [PATCH] binary heap implementation