From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | wangshuo(at)highgo(dot)com(dot)cn |
Cc: | David Johnston <polobo(at)yahoo(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>, Jeff Davis <pgsql(at)j-davis(dot)com> |
Subject: | Re: ENABLE/DISABLE CONSTRAINT NAME |
Date: | 2013-09-04 17:56:04 |
Message-ID: | CA+TgmobXBqLS4qCDKL3OpWopuPyKNuc7g7j1Bck9hS3xZus26A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Sep 3, 2013 at 3:13 AM, <wangshuo(at)highgo(dot)com(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2013-09-04 18:26:11 | Re: Improving avg performance for numeric |
Previous Message | Kevin Grittner | 2013-09-04 17:51:57 | Re: Eliminating pg_catalog.pg_rewrite.ev_attr |