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

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: using index or check in ALTER TABLE SET NOT NULL
Дата
Msg-id
1142.1520362313@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Robert Haas <robertmhaas@gmail.com>
Re: using index or check in ALTER TABLE SET NOT NULL Stephen Frost <sfrost@snowman.net>
Re: using index or check in ALTER TABLE SET NOT NULL Tom Lane <tgl@sss.pgh.pa.us>
Re: using index or check in ALTER TABLE SET NOT NULL Stephen Frost <sfrost@snowman.net>
Re: using index or check in ALTER TABLE SET NOT NULL Tom Lane <tgl@sss.pgh.pa.us>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Robert Haas <robertmhaas@gmail.com>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Stephen Frost <sfrost@snowman.net>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
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 Sergei Kornilov <sk@zsrv.org>
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 Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Tom Lane <tgl@sss.pgh.pa.us>
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 Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Dmitry Dolgov <9erthalion6@gmail.com>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Dmitry Dolgov <9erthalion6@gmail.com>
Re: using index or check in ALTER TABLE SET NOT NULL Alvaro Herrera <alvherre@2ndquadrant.com>
Re: using index or check in ALTER TABLE SET NOT NULL Dmitry Dolgov <9erthalion6@gmail.com>
Re: using index or check in ALTER TABLE SET NOT NULL Dmitry Dolgov <9erthalion6@gmail.com>
Re: using index or check in ALTER TABLE SET NOT NULL David Rowley <david.rowley@2ndquadrant.com>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL David Rowley <david.rowley@2ndquadrant.com>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL David Rowley <david.rowley@2ndquadrant.com>
Re: using index or check in ALTER TABLE SET NOT NULL Robert Haas <robertmhaas@gmail.com>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Robert Haas <robertmhaas@gmail.com>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Tom Lane <tgl@sss.pgh.pa.us>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Robert Haas <robertmhaas@gmail.com>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Tom Lane <tgl@sss.pgh.pa.us>
Re: using index or check in ALTER TABLE SET NOT NULL Tom Lane <tgl@sss.pgh.pa.us>
Re: using index or check in ALTER TABLE SET NOT NULL Robert Haas <robertmhaas@gmail.com>
Re: using index or check in ALTER TABLE SET NOT NULL Justin Pryzby <pryzby@telsasoft.com>
Re: using index or check in ALTER TABLE SET NOT NULL Robert Haas <robertmhaas@gmail.com>
Re: using index or check in ALTER TABLE SET NOT NULL David Rowley <david.rowley@2ndquadrant.com>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: Re: using index or check in ALTER TABLE SET NOT NULL David Steele <david@pgmasters.net>
Re: Re: using index or check in ALTER TABLE SET NOT NULL Robert Haas <robertmhaas@gmail.com>
Re: using index or check in ALTER TABLE SET NOT NULL Andres Freund <andres@anarazel.de>
Re: using index or check in ALTER TABLE SET NOT NULL Tom Lane <tgl@sss.pgh.pa.us>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL David Rowley <david.rowley@2ndquadrant.com>
Re: using index or check in ALTER TABLE SET NOT NULL Tom Lane <tgl@sss.pgh.pa.us>
Re: using index or check in ALTER TABLE SET NOT NULL David Rowley <david.rowley@2ndquadrant.com>
Re: using index or check in ALTER TABLE SET NOT NULL David Rowley <david.rowley@2ndquadrant.com>
Re: using index or check in ALTER TABLE SET NOT NULL David Rowley <david.rowley@2ndquadrant.com>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL David Rowley <david.rowley@2ndquadrant.com>
Re: using index or check in ALTER TABLE SET NOT NULL Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: using index or check in ALTER TABLE SET NOT NULL Tom Lane <tgl@sss.pgh.pa.us>
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 Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: using index or check in ALTER TABLE SET NOT NULL Sergei Kornilov <sk@zsrv.org>
Re: using index or check in ALTER TABLE SET NOT NULL Robert Haas <robertmhaas@gmail.com>
Re: using index or check in ALTER TABLE SET NOT NULL Stephen Frost <sfrost@snowman.net>
Re: using index or check in ALTER TABLE SET NOT NULL Andres Freund <andres@anarazel.de>
Sergei Kornilov  writes:
>> ISTM that depending on DEBUG messages is bad because debugging lines
>> added elsewhere will make your tests fail;

> I agree and this is reason why i not used DEBUG message in tests as was proposed. I found INFO messages in tests and decided that this was an acceptable option year ago.

INFO is for user-facing messages, such as output from VACUUM VERBOSE,
where the user has specifically requested the output.  I do not think
this falls into that category.  Even if you persuade some committer
to commit it like that, there will be user pushback asking us to get
this noise out of their faces ... and then we'll have to find some
other way to test it.

Do you actually need test output proving that this code path was taken
rather than the default one?  Seems like looking at the code coverage
report might be enough.

> In this case we need remove INFO from ALTER TABLE ATTACH PARTITION code and tests. I think is a bad idea of using different rules for same stuff, right? Probably i can do this work too.

I did not see any INFO messages in a quick test of ALTER TABLE ATTACH
PARTITION, but if there are any lurking in there, they probably need
to be downgraded.

			regards, tom lane

В списке pgsql-hackers по дате отправления
От: Evgeniy Shishkin
Дата:
От: Sergei Kornilov
Дата:
FAQ