Re: Teaching pg_dump to use NOT VALID constraints

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Teaching pg_dump to use NOT VALID constraints
Дата
Msg-id 54654D25.7010100@gmx.net
обсуждение исходный текст
Ответ на Re: Teaching pg_dump to use NOT VALID constraints  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Teaching pg_dump to use NOT VALID constraints  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On 11/13/14 5:07 AM, Simon Riggs wrote:
> On 13 November 2014 00:20, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
> 
>> Isn't the real use-case here that if constraints were valid when you dumped
>> then we shouldn't have to *any* re-validate when we load? (Though, we'd have
>> to be careful of that with CHECK because that can call user code...)
> 
> Yes, that is the use case this patch would improve considerably.

But your patch doesn't really address that.  It just leaves the
constraints as invalid, and someone will have to revalidate them later
(how?).  What Jim was describing was a mode that creates the constraints
as valid but doesn't actually validate them.  I can see both sides of
that kind of feature.




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: using custom scan nodes to prototype parallel sequential scan
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Performance issue with libpq prepared queries on 9.3 and 9.4