Re: [HACKERS] foreign table creation and NOT VALID check constraints

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: [HACKERS] foreign table creation and NOT VALID check constraints
Дата
Msg-id d49692e8-3ef3-4a4a-0550-7e36109670de@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: [HACKERS] foreign table creation and NOT VALID check constraints  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: [HACKERS] foreign table creation and NOT VALID check constraints  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 2017/08/02 20:40, Robert Haas wrote:
> On Wed, Aug 2, 2017 at 3:46 AM, Ashutosh Bapat
> <ashutosh.bapat@enterprisedb.com> wrote:
>> If the user has specified "not valid" for a constraint on the foreign
>> table, there is high chance that s/he is aware of the fact that the
>> remote table that the foreign table points to has some rows which will
>> violet the constraint. So, +1.
> 
> +1 from me, too.

Alright, thanks.

Attached is a patch.  I think this could be considered a bug-fix,
backpatchable to 9.6 which introduced this behavior change [1].

Thoughts?

Thanks,
Amit

[1]
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f27a6b15e656

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Вложения

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] Why does logical replication launcher exit with exitcode 1?
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Why does logical replication launcher exit with exitcode 1?