Re: ENABLE/DISABLE CONSTRAINT NAME
| От | wangshuo@highgo.com.cn |
|---|---|
| Тема | Re: ENABLE/DISABLE CONSTRAINT NAME |
| Дата | |
| Msg-id | 4212a401b6014356540ac842546edd68@highgo.com.cn обсуждение исходный текст |
| Ответ на | Re: ENABLE/DISABLE CONSTRAINT NAME (Robert Haas <robertmhaas@gmail.com>) |
| Ответы |
Re: ENABLE/DISABLE CONSTRAINT NAME
|
| Список | pgsql-hackers |
于 2013-09-05 01:56, Robert Haas 回复: > 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 I had committed the patch to the Server Features (https://commitfest.postgresql.org/action/commitfest_view/open). Is this right ? If not, please give me more advice,thanks ! Wang Shuo HighGo Software Co.,Ltd. September 5, 2013
В списке pgsql-hackers по дате отправления: