Re: Passing initially_valid values instead of !skip_validation to StoreRelCheck() in AddRelationNewConstraints()

Поиск
Список
Период
Сортировка
Искать
От
Marko Tiikkaja
Тема
Re: Passing initially_valid values instead of !skip_validation to StoreRelCheck() in AddRelationNewConstraints()
Дата
Msg-id
56602E0B.9030402@joh.to
Ответ на
Список
Дерево обсуждения
Re: Passing initially_valid values instead of !skip_validation to StoreRelCheck() in AddRelationNewConstraints() Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Passing initially_valid values instead of !skip_validation to StoreRelCheck() in AddRelationNewConstraints() Marko Tiikkaja <marko@joh.to>
Re: Passing initially_valid values instead of !skip_validation to StoreRelCheck() in AddRelationNewConstraints() Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Passing initially_valid values instead of !skip_validation to StoreRelCheck() in AddRelationNewConstraints() Robert Haas <robertmhaas@gmail.com>
Re: Passing initially_valid values instead of !skip_validation to StoreRelCheck() in AddRelationNewConstraints() Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Passing initially_valid values instead of !skip_validation to StoreRelCheck() in AddRelationNewConstraints() Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Passing initially_valid values instead of !skip_validation to StoreRelCheck() in AddRelationNewConstraints() Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Passing initially_valid values instead of !skip_validation to StoreRelCheck() in AddRelationNewConstraints() Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Passing initially_valid values instead of !skip_validation to StoreRelCheck() in AddRelationNewConstraints() Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Passing initially_valid values instead of !skip_validation to StoreRelCheck() in AddRelationNewConstraints() Robert Haas <robertmhaas@gmail.com>
Re: Passing initially_valid values instead of !skip_validation to StoreRelCheck() in AddRelationNewConstraints() Amit Langote <amitlangote09@gmail.com>
On 12/3/15 12:44 PM, amul sul wrote:
>> On Thursday, 3 December 2015 4:36 PM, Amit Langote  wrote:
>> The user will have to separately validate the constraint by issuing a ALTER TABLE VALIDATE CONSTRAINT
>> command at a time of their choosing.
>
> This could be time consuming operation for big table, If I am pretty much sure that my constraint will be valid, simply I could set both flag(initially_valid & skip_validation) to true.

I'm confused here.  It sounds like you're suggesting an SQL level 
feature, but you're really focused on a single line of code for some 
reason.  Could you take a step back and explain the high level picture 
of what you're trying to achieve?


.m


В списке pgsql-hackers по дате отправления
От: Greg Stark
Дата:
FAQ