Re: cataloguing NOT NULL constraints

From:	Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To:	Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc:	Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject:	Re: cataloguing NOT NULL constraints
Date:	2023-04-07 12:49:36
Message-ID:	20230407124936.p2jvoynsxo2qr3qf@alvherre.pgsql
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2022-08-17 18:12:49 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>  2022-08-17 18:24:30 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>   2022-08-17 20:09:22 from Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>  2022-08-18 08:17:08 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>   2022-08-18 09:04:25 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>    2022-08-18 15:00:52 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>    2022-08-22 03:42:02 from Amit Langote <amitlangote09(at)gmail(dot)com>     2022-08-23 16:49:26 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>      2022-08-31 22:19:10 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎       2022-08-31 23:08:52 from Zhihong Yu <zyu(at)yugabyte(dot)com>        2022-08-31 23:11:42 from Zhihong Yu <zyu(at)yugabyte(dot)com>         2022-09-10 00:28:19 from Zhihong Yu <zyu(at)yugabyte(dot)com>       2022-09-09 17:58:13 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎        2022-09-13 03:17:29 from Amit Langote <amitlangote09(at)gmail(dot)com>        2022-09-14 20:03:50 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>         2022-09-19 11:19:19 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>  2022-09-19 13:32:14 from Robert Haas <robertmhaas(at)gmail(dot)com>   2022-09-19 13:54:41 from Isaac Morland <isaac(dot)morland(at)gmail(dot)com>    2022-09-19 14:08:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2022-09-20 10:53:02 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>   2022-09-19 14:10:17 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>    2022-09-20 10:56:19 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>     2022-09-20 14:15:29 from Isaac Morland <isaac(dot)morland(at)gmail(dot)com>      2022-09-20 14:39:46 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>       2022-09-20 16:49:46 from Robert Haas <robertmhaas(at)gmail(dot)com>   2022-09-20 10:51:09 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>  2023-02-28 19:15:37 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎   2023-03-01 12:03:48 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎   2023-03-01 22:32:14 from Justin Pryzby <pryzby(at)telsasoft(dot)com>   2023-03-03 10:15:00 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>    2023-03-03 10:47:28 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>   2023-03-15 22:44:40 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎    2023-03-27 13:55:27 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>     2023-03-29 14:46:16 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> 📎      2023-08-31 10:02:39 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>       2023-09-04 11:00:05 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>       2023-09-05 11:29:47 from Peter Eisentraut <peter(at)eisentraut(dot)org>        2023-09-05 15:29:56 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>        2023-09-05 16:24:37 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>         2023-09-05 17:15:43 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>          2023-09-05 21:50:04 from Vik Fearing <vik(at)postgresfriends(dot)org>           2023-09-05 22:14:15 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>            2023-09-05 23:35:24 from Vik Fearing <vik(at)postgresfriends(dot)org>             2023-09-06 00:53:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2023-09-06 02:31:44 from Vik Fearing <vik(at)postgresfriends(dot)org>               2023-09-06 03:40:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2023-09-06 19:09:20 from Vik Fearing <vik(at)postgresfriends(dot)org>         2023-09-06 11:02:50 from Peter Eisentraut <peter(at)eisentraut(dot)org>     2023-04-05 23:33:56 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎      2023-04-06 01:54:54 from Andres Freund <andres(at)anarazel(dot)de>       2023-04-06 02:08:30 from Michael Paquier <michael(at)paquier(dot)xyz>      2023-04-06 18:20:41 from Justin Pryzby <pryzby(at)telsasoft(dot)com>       2023-04-07 02:14:13 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎        2023-04-07 12:49:36 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎         2023-04-07 20:38:43 from Andres Freund <andres(at)anarazel(dot)de>          2023-04-07 20:45:30 from Andres Freund <andres(at)anarazel(dot)de>           2023-04-07 21:00:01 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>            2023-04-07 21:10:00 from Andres Freund <andres(at)anarazel(dot)de>             2023-04-07 21:11:55 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>              2023-04-07 21:19:50 from Andres Freund <andres(at)anarazel(dot)de>               2023-04-07 21:46:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2023-04-07 22:23:26 from Andres Freund <andres(at)anarazel(dot)de>                 2023-04-07 22:26:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2023-04-07 22:39:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2023-04-08 00:19:42 from Andres Freund <andres(at)anarazel(dot)de>                   2023-04-08 00:41:47 from Andres Freund <andres(at)anarazel(dot)de>                   2023-04-09 16:23:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                    2023-04-09 19:11:01 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                     2023-04-09 20:11:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2023-06-30 11:44:03 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎          2023-07-01 01:12:08 from Andres Freund <andres(at)anarazel(dot)de>           2023-07-03 12:58:49 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>          2023-07-03 14:02:37 from Peter Eisentraut <peter(at)eisentraut(dot)org> 📎           2023-07-10 16:52:13 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎           2023-07-11 14:17:20 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎            2023-07-11 17:29:04 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎             2023-07-12 17:10:59 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎              2023-07-13 13:56:44 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>               2023-07-20 15:31:48 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                2023-07-24 08:42:57 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                 2023-07-24 10:32:53 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                  2023-07-24 19:22:50 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2023-08-02 08:29:39 from Peter Eisentraut <peter(at)eisentraut(dot)org>                2023-07-24 10:06:06 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                 2023-07-24 10:10:51 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                  2023-07-24 16:42:28 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                   2023-07-24 17:19:48 from Vik Fearing <vik(at)postgresfriends(dot)org>                   2023-07-24 19:05:39 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                    2023-07-25 12:35:54 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                     2023-07-25 15:39:13 from Robert Haas <robertmhaas(at)gmail(dot)com>                      2023-07-25 15:54:39 from Isaac Morland <isaac(dot)morland(at)gmail(dot)com>                       2023-07-25 16:24:38 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                        2023-07-25 17:32:56 from Isaac Morland <isaac(dot)morland(at)gmail(dot)com>                         2023-07-25 18:59:23 from Robert Haas <robertmhaas(at)gmail(dot)com>                          2023-07-25 19:06:52 from Isaac Morland <isaac(dot)morland(at)gmail(dot)com>                           2023-07-25 20:05:30 from Robert Haas <robertmhaas(at)gmail(dot)com>                     2023-07-26 13:09:02 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                      2023-07-26 13:49:39 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                       2023-07-26 14:06:53 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                       2023-07-28 10:47:44 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                        2023-08-04 18:10:42 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                         2023-08-05 11:35:02 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                          2023-08-05 17:37:50 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                           2023-08-05 19:50:01 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                            2023-08-09 07:55:09 from Peter Eisentraut <peter(at)eisentraut(dot)org>                             2023-08-09 11:10:29 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                            2023-08-11 13:54:22 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                             2023-08-15 09:57:34 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                              2023-08-15 10:15:32 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                              2023-08-16 08:02:11 from Peter Eisentraut <peter(at)eisentraut(dot)org>                             2023-08-16 10:09:33 from Peter Eisentraut <peter(at)eisentraut(dot)org> 📎                              2023-08-21 18:01:01 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                               2023-08-23 17:08:18 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                2023-08-25 11:38:33 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                 2023-08-25 12:00:41 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                 2023-08-28 12:55:54 from Peter Eisentraut <peter(at)eisentraut(dot)org>                                  2023-08-28 15:44:55 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                 2023-08-31 10:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                  2023-08-31 10:26:47 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                   2023-08-31 11:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                   2023-09-01 17:55:52 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                 2023-10-12 10:00:01 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                  2023-11-08 17:53:27 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                   2024-02-02 16:00:01 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                    2024-02-05 07:21:23 from Michael Paquier <michael(at)paquier(dot)xyz>                                     2024-02-05 08:51:33 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                      2024-02-05 09:50:56 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                       2024-02-05 09:53:17 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                       2024-02-05 14:47:19 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                        2024-02-05 18:11:18 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                       2024-02-07 09:44:24 from jian he <jian(dot)universality(at)gmail(dot)com>                                        2024-04-15 13:20:55 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                 2024-01-25 08:21:35 from Andrew Bille <andrewbille(at)gmail(dot)com>                                  2024-04-18 13:39:12 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                   2024-04-18 20:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                    2024-04-22 10:22:23 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                     2024-04-24 17:36:17 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                      2024-04-25 05:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                       2024-04-25 10:16:25 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                        2024-05-01 17:49:35 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                         2024-05-02 15:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                          2024-05-02 16:21:56 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                           2024-05-03 04:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                         2024-05-07 08:17:24 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                          2024-05-08 20:42:08 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                           2024-05-09 20:05:58 from Robert Haas <robertmhaas(at)gmail(dot)com>                                            2024-05-11 09:40:01 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                             2024-05-12 14:56:09 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                              2024-05-15 01:32:49 from Bruce Momjian <bruce(at)momjian(dot)us> 📎                                               2024-05-15 07:50:36 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                2024-05-15 12:37:48 from Peter Eisentraut <peter(at)eisentraut(dot)org>                                                2024-05-16 03:09:48 from Bruce Momjian <bruce(at)momjian(dot)us>                                             2024-05-13 13:00:28 from Robert Haas <robertmhaas(at)gmail(dot)com>                                              2024-05-13 13:44:40 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                               2024-05-13 15:14:42 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                2024-05-13 16:45:40 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                 2024-05-13 18:58:25 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                  2024-05-14 09:58:11 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                              2024-05-15 01:34:00 from Bruce Momjian <bruce(at)momjian(dot)us>                 2023-07-24 10:55:26 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                 2023-07-24 17:17:33 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                  2023-07-24 17:18:54 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎        2023-04-07 14:55:58 from Justin Pryzby <pryzby(at)telsasoft(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v8-0001-Catalog-NOT-NULL-constraints.patch	text/x-diff	201.9 KB

In response to

• Re: cataloguing NOT NULL constraints at 2023-04-07 02:14:13 from Alvaro Herrera

Responses

• Re: cataloguing NOT NULL constraints at 2023-04-07 20:38:43 from Andres Freund
• Re: cataloguing NOT NULL constraints at 2023-06-30 11:44:03 from Alvaro Herrera

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Hayato Kuroda (Fujitsu)	2023-04-07 12:51:51	RE: [PoC] pg_upgrade: allow to upgrade publisher node
Previous Message	Thomas Munro	2023-04-07 12:35:15	Re: Direct I/O