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

From:	Sergei Kornilov <sk(at)zsrv(dot)org>
To:	PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Cc:	Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Stephen Frost <sfrost(at)snowman(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, Ildar Musin <i(dot)musin(at)postgrespro(dot)ru>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject:	Re: using index or check in ALTER TABLE SET NOT NULL
Date:	2018-04-09 19:19:47
Message-ID:	979461523301587@web39j.yandex.ru
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2017-11-28 18:59:00 from Sergei Kornilov <sk(at)zsrv(dot)org> 📎  2017-11-29 15:05:08 from Robert Haas <robertmhaas(at)gmail(dot)com>   2017-11-29 15:21:35 from Stephen Frost <sfrost(at)snowman(dot)net>    2017-11-29 15:47:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2017-11-29 15:52:36 from Sergei Kornilov <sk(at)zsrv(dot)org>      2017-11-29 16:00:32 from Robert Haas <robertmhaas(at)gmail(dot)com>       2017-11-29 16:50:31 from Stephen Frost <sfrost(at)snowman(dot)net>        2017-11-29 16:55:02 from Andres Freund <andres(at)anarazel(dot)de>      2017-11-29 16:53:01 from Sergei Kornilov <sk(at)zsrv(dot)org> 📎       2017-11-30 20:55:00 from Robert Haas <robertmhaas(at)gmail(dot)com>        2017-11-30 22:05:52 from Sergei Kornilov <sk(at)zsrv(dot)org>        2017-12-04 14:09:44 from Sergei Kornilov <sk(at)zsrv(dot)org> 📎         2018-01-23 15:37:11 from Stephen Frost <sfrost(at)snowman(dot)net>          2018-01-23 19:06:07 from Sergei Kornilov <sk(at)zsrv(dot)org> 📎           2018-03-06 07:57:27 from Ildar Musin <i(dot)musin(at)postgrespro(dot)ru>            2018-03-06 13:12:31 from Sergei Kornilov <sk(at)zsrv(dot)org> 📎             2018-03-06 14:37:06 from Ildar Musin <i(dot)musin(at)postgrespro(dot)ru>              2018-03-06 15:52:58 from Sergei Kornilov <sk(at)zsrv(dot)org> 📎               2018-03-06 17:25:28 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                2018-03-06 18:32:08 from Sergei Kornilov <sk(at)zsrv(dot)org>                 2018-03-06 18:51:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2018-03-06 19:27:40 from Sergei Kornilov <sk(at)zsrv(dot)org>                  2018-03-07 11:03:53 from Ildar Musin <i(dot)musin(at)postgrespro(dot)ru>                   2018-03-09 14:51:25 from Sergei Kornilov <sk(at)zsrv(dot)org>                    2018-03-10 09:35:21 from Sergei Kornilov <sk(at)zsrv(dot)org> 📎                     2018-03-15 14:31:50 from Ildar Musin <i(dot)musin(at)postgrespro(dot)ru>                     2018-04-09 19:19:47 from Sergei Kornilov <sk(at)zsrv(dot)org> 📎                      2018-04-11 18:55:46 from Sergei Kornilov <sk(at)zsrv(dot)org> 📎                       2018-04-15 07:09:11 from Sergei Kornilov <sk(at)zsrv(dot)org> 📎                        2018-11-04 14:18:20 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                         2018-11-04 18:03:19 from Sergei Kornilov <sk(at)zsrv(dot)org>                          2018-11-13 12:47:52 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                           2018-11-13 12:59:49 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                            2018-11-22 17:04:55 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                             2018-12-27 20:03:51 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                        2019-03-01 12:35:22 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                         2019-03-05 19:41:09 from Sergei Kornilov <sk(at)zsrv(dot)org> 📎                          2019-03-05 23:23:14 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                           2019-03-10 11:13:17 from Sergei Kornilov <sk(at)zsrv(dot)org> 📎                            2019-03-11 03:30:31 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                             2019-03-12 14:44:47 from Robert Haas <robertmhaas(at)gmail(dot)com>                              2019-03-12 20:27:47 from Sergei Kornilov <sk(at)zsrv(dot)org> 📎                               2019-03-13 12:57:38 from Robert Haas <robertmhaas(at)gmail(dot)com>                                2019-03-13 13:08:34 from Sergei Kornilov <sk(at)zsrv(dot)org>                                2019-03-13 15:00:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                 2019-03-13 15:17:21 from Sergei Kornilov <sk(at)zsrv(dot)org>                                  2019-03-13 16:20:30 from Robert Haas <robertmhaas(at)gmail(dot)com>                                   2019-03-13 16:46:50 from Sergei Kornilov <sk(at)zsrv(dot)org>                                    2019-03-13 17:09:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                     2019-03-13 17:19:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                      2019-03-13 17:25:11 from Robert Haas <robertmhaas(at)gmail(dot)com>                                       2019-03-13 20:36:50 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                     2019-03-13 17:24:29 from Robert Haas <robertmhaas(at)gmail(dot)com>                                      2019-03-17 11:40:52 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                       2019-03-17 12:53:42 from Sergei Kornilov <sk(at)zsrv(dot)org>                                       2019-03-25 07:51:35 from David Steele <david(at)pgmasters(dot)net>                                        2019-03-25 15:09:47 from Robert Haas <robertmhaas(at)gmail(dot)com>                                         2019-05-01 16:20:21 from Andres Freund <andres(at)anarazel(dot)de>                                          2019-05-01 16:38:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                           2019-05-01 18:18:12 from Sergei Kornilov <sk(at)zsrv(dot)org>                                            2019-05-02 00:57:11 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                             2019-05-02 01:08:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                              2019-05-02 02:22:59 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                               2019-05-03 23:06:46 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                2019-05-31 19:06:01 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                 2019-06-10 15:35:08 from Sergei Kornilov <sk(at)zsrv(dot)org>                                                  2019-06-11 20:34:57 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                   2019-08-02 19:54:38 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                                    2019-08-02 20:02:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2018-04-06 03:29:32 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>       2018-04-06 07:28:00 from Sergei Kornilov <sk(at)zsrv(dot)org>     2017-11-29 15:58:12 from Stephen Frost <sfrost(at)snowman(dot)net>      2017-11-29 16:15:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
alter_table_set_not_null_by_constraints_only_v8.patch	text/x-diff	13.8 KB

In response to

• Re: using index or check in ALTER TABLE SET NOT NULL at 2018-03-10 09:35:21 from Sergei Kornilov

Responses

• Re: using index or check in ALTER TABLE SET NOT NULL at 2018-04-11 18:55:46 from Sergei Kornilov

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Tomas Vondra	2018-04-09 19:22:58	Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS
Previous Message	Andres Freund	2018-04-09 19:13:14	Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS