Re: cataloguing NOT NULL constraints

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: cataloguing NOT NULL constraints
Дата
Msg-id
20230823170818.v22xaa432h6ttwjf@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Marcos Pegoraro <marcos@f10.com.br>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Justin Pryzby <pryzby@telsasoft.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Andres Freund <andres@anarazel.de>
Re: cataloguing NOT NULL constraints Michael Paquier <michael@paquier.xyz>
Re: cataloguing NOT NULL constraints Justin Pryzby <pryzby@telsasoft.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Andres Freund <andres@anarazel.de>
Re: cataloguing NOT NULL constraints Andres Freund <andres@anarazel.de>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Andres Freund <andres@anarazel.de>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Andres Freund <andres@anarazel.de>
Re: cataloguing NOT NULL constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: cataloguing NOT NULL constraints Andres Freund <andres@anarazel.de>
Re: cataloguing NOT NULL constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: cataloguing NOT NULL constraints Andres Freund <andres@anarazel.de>
Re: cataloguing NOT NULL constraints Andres Freund <andres@anarazel.de>
Re: cataloguing NOT NULL constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: cataloguing NOT NULL constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Peter Eisentraut <peter@eisentraut.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Dean Rasheed <dean.a.rasheed@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Dean Rasheed <dean.a.rasheed@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Dean Rasheed <dean.a.rasheed@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Vik Fearing <vik@postgresfriends.org>
Re: cataloguing NOT NULL constraints Dean Rasheed <dean.a.rasheed@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Robert Haas <robertmhaas@gmail.com>
Re: cataloguing NOT NULL constraints Isaac Morland <isaac.morland@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Isaac Morland <isaac.morland@gmail.com>
Re: cataloguing NOT NULL constraints Robert Haas <robertmhaas@gmail.com>
Re: cataloguing NOT NULL constraints Isaac Morland <isaac.morland@gmail.com>
Re: cataloguing NOT NULL constraints Robert Haas <robertmhaas@gmail.com>
Re: cataloguing NOT NULL constraints Dean Rasheed <dean.a.rasheed@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Dean Rasheed <dean.a.rasheed@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Dean Rasheed <dean.a.rasheed@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Peter Eisentraut <peter@eisentraut.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Peter Eisentraut <peter@eisentraut.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alexander Lakhin <exclusion@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alexander Lakhin <exclusion@gmail.com>
Re: cataloguing NOT NULL constraints Michael Paquier <michael@paquier.xyz>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints jian he <jian.universality@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Andrew Bille <andrewbille@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alexander Lakhin <exclusion@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alexander Lakhin <exclusion@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Robert Haas <robertmhaas@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Bruce Momjian <bruce@momjian.us>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Peter Eisentraut <peter@eisentraut.org>
Re: cataloguing NOT NULL constraints Bruce Momjian <bruce@momjian.us>
Re: cataloguing NOT NULL constraints Robert Haas <robertmhaas@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Robert Haas <robertmhaas@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Robert Haas <robertmhaas@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Bruce Momjian <bruce@momjian.us>
Re: cataloguing NOT NULL constraints Alexander Lakhin <exclusion@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alexander Lakhin <exclusion@gmail.com>
Re: cataloguing NOT NULL constraints Alexander Lakhin <exclusion@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alexander Lakhin <exclusion@gmail.com>
Re: cataloguing NOT NULL constraints Dean Rasheed <dean.a.rasheed@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Peter Eisentraut <peter@eisentraut.org>
Re: cataloguing NOT NULL constraints Peter Eisentraut <peter@eisentraut.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Dean Rasheed <dean.a.rasheed@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Peter Eisentraut <peter@eisentraut.org>
Re: cataloguing NOT NULL constraints Robert Haas <robertmhaas@gmail.com>
Re: cataloguing NOT NULL constraints Andres Freund <andres@anarazel.de>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Justin Pryzby <pryzby@telsasoft.com>
Re: cataloguing NOT NULL constraints Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Peter Eisentraut <peter@eisentraut.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: information_schema and not-null constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: information_schema and not-null constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: information_schema and not-null constraints Vik Fearing <vik@postgresfriends.org>
Re: information_schema and not-null constraints "David G. Johnston" <david.g.johnston@gmail.com>
Re: information_schema and not-null constraints Vik Fearing <vik@postgresfriends.org>
Re: information_schema and not-null constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: information_schema and not-null constraints Vik Fearing <vik@postgresfriends.org>
Re: information_schema and not-null constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: information_schema and not-null constraints Vik Fearing <vik@postgresfriends.org>
Re: information_schema and not-null constraints Peter Eisentraut <peter@eisentraut.org>
Re: cataloguing NOT NULL constraints Robert Haas <robertmhaas@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Isaac Morland <isaac.morland@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Robert Haas <robertmhaas@gmail.com>
Re: cataloguing NOT NULL constraints Isaac Morland <isaac.morland@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: cataloguing NOT NULL constraints Laurenz Albe <laurenz.albe@cybertec.at>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Laurenz Albe <laurenz.albe@cybertec.at>
Re: cataloguing NOT NULL constraints Amit Langote <amitlangote09@gmail.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: cataloguing NOT NULL constraints Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: cataloguing NOT NULL constraints Amit Langote <amitlangote09@gmail.com>
Re: cataloguing NOT NULL constraints Zhihong Yu <zyu@yugabyte.com>
Re: cataloguing NOT NULL constraints Zhihong Yu <zyu@yugabyte.com>
Re: cataloguing NOT NULL constraints Zhihong Yu <zyu@yugabyte.com>
I went over the whole patch and made a very large number of additional
cleanups[1], to the point where I think this is truly ready for commit now.
There are some relatively minor things that could still be subject of
debate, such as what to name constraints that derive from PKs or from
multiple inheritance parents.  I have one commented out Assert() because
of that.  But other than those and a couple of not-terribly-important
XXX comments, this is as ready as it'll ever be.

I'll put it through CI soon.  It's been a while since I tested using
pg_upgrade from older versions, so I'll do that too.  If no problems
emerge, I intend to get this committed soon.

[1] https://github.com/alvherre/postgres/tree/catalog-notnull-9

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"If you want to have good ideas, you must have many ideas.  Most of them
will be wrong, and what you have to learn is which ones to throw away."
                                                         (Linus Pauling)
В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ