Re: ENABLE/DISABLE CONSTRAINT NAME - Mailing list pgsql-hackers

From Robert Haas
Subject Re: ENABLE/DISABLE CONSTRAINT NAME
Date
Msg-id CA+TgmobXBqLS4qCDKL3OpWopuPyKNuc7g7j1Bck9hS3xZus26A@mail.gmail.com
Whole thread Raw
In response to Re: ENABLE/DISABLE CONSTRAINT NAME  (wangshuo@highgo.com.cn)
Responses Re: ENABLE/DISABLE CONSTRAINT NAME
List pgsql-hackers
On Tue, Sep 3, 2013 at 3:13 AM,  <wangshuo@highgo.com.cn> wrote:
> 于 2013-09-03 08:15, David Johnston 回复:
>
>> Jeff Davis-8 wrote
>>>
>>> Is there any semantic difference between marking a constraint as
>>> DISABLED and simply dropping it? Or does it just make it easier to
>>> re-add it later?
>>
>>
> David Johnston wrote:
>>
>> I cannot answer the question but if there is none then the main concern
>> I'd
>> have is capturing "meta-information" about WHY such a constraint has been
>> disabled instead of dropped.
>
>
> Drop/build and disable/enable constraint has no fundamental difference,
> and could achieve the same purpose.What I do also more convenient for the
> user.
> Recording the disabled constraints is easier than recoding all the
> constrains.
> What's more, a lot of people ever asked about turing off constraint and
> The sql2008 support this.So I think it's necessary in some ways.

Please add your patch to the upcoming CommitFest so we don't forget about it.

https://commitfest.postgresql.org/action/commitfest_view/open

Please see also https://wiki.postgresql.org/wiki/Submitting_a_Patch

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



pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Eliminating pg_catalog.pg_rewrite.ev_attr
Next
From: Pavel Stehule
Date:
Subject: Re: Improving avg performance for numeric