Re: cataloguing NOT NULL constraints

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: cataloguing NOT NULL constraints
Дата
Msg-id
81b461c4-edab-5d8c-2f88-203108425340@enterprisedb.com
Ответ на
Список
Дерево обсуждения
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>
On 27.03.23 15:55, Peter Eisentraut wrote:
> The information schema should be updated.  I think the following views:
> 
> - CHECK_CONSTRAINTS
> - CONSTRAINT_COLUMN_USAGE
> - DOMAIN_CONSTRAINTS
> - TABLE_CONSTRAINTS
> 
> It looks like these have no test coverage; maybe that could be addressed 
> at the same time.

Here are patches for this.  I haven't included the expected files for 
the tests; this should be checked again that output is correct or the 
changes introduced by this patch set are as expected.

The reason we didn't have tests for this before was probably in part 
because the information schema made up names for not-null constraints 
involving OIDs, so the test wouldn't have been stable.

Feel free to integrate this, or we can add it on afterwards.
В списке pgsql-hackers по дате отправления
От: Tomas Vondra
Дата:
От: Peter Eisentraut
Дата:
FAQ