Re: using index or check in ALTER TABLE SET NOT NULL

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: using index or check in ALTER TABLE SET NOT NULL
Дата
Msg-id 611431520341951@web57o.yandex.ru
обсуждение исходный текст
Ответ на Re: using index or check in ALTER TABLE SET NOT NULL  (Ildar Musin <i.musin@postgrespro.ru>)
Ответы Re: using index or check in ALTER TABLE SET NOT NULL  (Ildar Musin <i.musin@postgrespro.ru>)
Список pgsql-hackers
Hello
thank you for review!

> Adding check constraint will also force the full table scan. So I think
> it would be better to rephrased it as follows:
Agree. I updated docs in new attached patch slightly different

> Regarding regression tests it may be useful to set client_min_messages
> to 'debug1' before setting "NOT NULL" attribute for a column. In this
> case you can tell for sure that NotNullImpliedByRelConstraints()
> returned true (i.e. your code actually did the job) as the special debug
> message is printed to the log.
I can not find any debug messages in tests: grep client_min_messages -irn src/test/ Only some warning level and few
error.So i verify in regression tests only top-level behavior.
 
Or this paragraph was for other people, not for tests?

regards, Sergei
Вложения

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

Предыдущее
От: Petr Jelinek
Дата:
Сообщение: Re: BUGFIX: standby disconnect can corrupt serialized reorder buffers
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: pgbench - allow to specify scale as a size