In reference to [1], 0001 attached to this email contains the updated
view definitions that I propose.
In 0002, I took the tests added by Peter's proposed patch and put them
in a separate test file that runs at the end. There are some issues,
however. One is that the ORDER BY clause in the check_constraints view
is not fully deterministic, because the table name is not part of the
view definition, so we cannot sort by table name. In the current
regression database there is only one case[2] where two constraints have
the same name and different definition:
inh_check_constraint │ 2 │ ((f1 > 0)) NOT VALID ↵
│ │ ((f1 > 0))
(on tables invalid_check_con and invalid_check_con_child). I assume
this is going to bite us at some point. We could just add a WHERE
clause to omit that one constraint.
Another issue I notice eyeballing at the results is that foreign keys on
partitioned tables are listing the rows used to implement the
constraints on partitions, which are sort-of "internal" constraints (and
are not displayed by psql's \d). I hope this is a relatively simple fix
that we could extract from the code used by psql.
Anyway, I think I'm going to get 0001 committed sometime tomorrow, and
then play a bit more with 0002 to try and get it pushed soon also.
Thanks
[1] https://postgr.es/m/[email protected]
[2]
select constraint_name, count(*),
string_agg(distinct check_clause, E'\n')
from information_schema.check_constraints
group by constraint_name
having count(*) > 1;
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"You don't solve a bad join with SELECT DISTINCT" #CupsOfFail
https://twitter.com/connor_mc_d/status/1431240081726115845
>From d8a5f8103934fe65a83a2ca44f6af72449cb6aa9 Mon Sep 17 00:00:00 2001
From: Alvaro Herrera <[email protected]>
Date: Mon, 4 Sep 2023 18:05:50 +0200
Subject: [PATCH v2 1/2] update information_schema definition
---
src/backend/catalog/information_schema.sql | 74 ++++++++--------------
1 file changed, 27 insertions(+), 47 deletions(-)
diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql
index a06ec7a0a8..c402cca7f4 100644
--- a/src/backend/catalog/information_schema.sql
+++ b/src/backend/catalog/information_schema.sql
@@ -444,22 +444,19 @@ CREATE VIEW check_constraints AS
WHERE pg_has_role(coalesce(c.relowner, t.typowner), 'USAGE')
AND con.contype = 'c'
- UNION
+ UNION ALL
-- not-null constraints
-
- SELECT CAST(current_database() AS sql_identifier) AS constraint_catalog,
- CAST(n.nspname AS sql_identifier) AS constraint_schema,
- CAST(CAST(n.oid AS text) || '_' || CAST(r.oid AS text) || '_' || CAST(a.attnum AS text) || '_not_null' AS sql_identifier) AS constraint_name, -- XXX
- CAST(a.attname || ' IS NOT NULL' AS character_data)
- AS check_clause
- FROM pg_namespace n, pg_class r, pg_attribute a
- WHERE n.oid = r.relnamespace
- AND r.oid = a.attrelid
- AND a.attnum > 0
- AND NOT a.attisdropped
- AND a.attnotnull
- AND r.relkind IN ('r', 'p')
- AND pg_has_role(r.relowner, 'USAGE');
+ SELECT current_database()::information_schema.sql_identifier AS constraint_catalog,
+ rs.nspname::information_schema.sql_identifier AS constraint_schema,
+ con.conname::information_schema.sql_identifier AS constraint_name,
+ format('CHECK (%s IS NOT NULL)', at.attname)::information_schema.character_data AS check_clause
+ FROM pg_constraint con
+ LEFT JOIN pg_namespace rs ON rs.oid = con.connamespace
+ LEFT JOIN pg_class c ON c.oid = con.conrelid
+ LEFT JOIN pg_type t ON t.oid = con.contypid
+ LEFT JOIN pg_attribute at ON (con.conrelid = at.attrelid AND con.conkey[1] = at.attnum)
+ WHERE pg_has_role(coalesce(c.relowner, t.typowner), 'USAGE'::text)
+ AND con.contype = 'n';
GRANT SELECT ON check_constraints TO PUBLIC;
@@ -826,6 +823,20 @@ CREATE VIEW constraint_column_usage AS
AND r.relkind IN ('r', 'p')
AND NOT a.attisdropped
+ UNION ALL
+
+ /* not-null constraints */
+ SELECT DISTINCT nr.nspname, r.relname, r.relowner, a.attname, nc.nspname, c.conname
+ FROM pg_namespace nr, pg_class r, pg_attribute a, pg_namespace nc, pg_constraint c
+ WHERE nr.oid = r.relnamespace
+ AND r.oid = a.attrelid
+ AND r.oid = c.conrelid
+ AND a.attnum = c.conkey[1]
+ AND c.connamespace = nc.oid
+ AND c.contype = 'n'
+ AND r.relkind in ('r', 'p')
+ AND not a.attisdropped
+
UNION ALL
/* unique/primary key/foreign key constraints */
@@ -1828,6 +1839,7 @@ CREATE VIEW table_constraints AS
CAST(r.relname AS sql_identifier) AS table_name,
CAST(
CASE c.contype WHEN 'c' THEN 'CHECK'
+ WHEN 'n' THEN 'CHECK'
WHEN 'f' THEN 'FOREIGN KEY'
WHEN 'p' THEN 'PRIMARY KEY'
WHEN 'u' THEN 'UNIQUE' END
@@ -1852,38 +1864,6 @@ CREATE VIEW table_constraints AS
AND c.contype NOT IN ('t', 'x') -- ignore nonstandard constraints
AND r.relkind IN ('r', 'p')
AND (NOT pg_is_other_temp_schema(nr.oid))
- AND (pg_has_role(r.relowner, 'USAGE')
- -- SELECT privilege omitted, per SQL standard
- OR has_table_privilege(r.oid, 'INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER')
- OR has_any_column_privilege(r.oid, 'INSERT, UPDATE, REFERENCES') )
-
- UNION ALL
-
- -- not-null constraints
-
- SELECT CAST(current_database() AS sql_identifier) AS constraint_catalog,
- CAST(nr.nspname AS sql_identifier) AS constraint_schema,
- CAST(CAST(nr.oid AS text) || '_' || CAST(r.oid AS text) || '_' || CAST(a.attnum AS text) || '_not_null' AS sql_identifier) AS constraint_name, -- XXX
- CAST(current_database() AS sql_identifier) AS table_catalog,
- CAST(nr.nspname AS sql_identifier) AS table_schema,
- CAST(r.relname AS sql_identifier) AS table_name,
- CAST('CHECK' AS character_data) AS constraint_type,
- CAST('NO' AS yes_or_no) AS is_deferrable,
- CAST('NO' AS yes_or_no) AS initially_deferred,
- CAST('YES' AS yes_or_no) AS enforced,
- CAST(NULL AS yes_or_no) AS nulls_distinct
-
- FROM pg_namespace nr,
- pg_class r,
- pg_attribute a
-
- WHERE nr.oid = r.relnamespace
- AND r.oid = a.attrelid
- AND a.attnotnull
- AND a.attnum > 0
- AND NOT a.attisdropped
- AND r.relkind IN ('r', 'p')
- AND (NOT pg_is_other_temp_schema(nr.oid))
AND (pg_has_role(r.relowner, 'USAGE')
-- SELECT privilege omitted, per SQL standard
OR has_table_privilege(r.oid, 'INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER')
--
2.39.2
>From b0c39ecaf6c4a1179d45fa9de7876b173c92d6ca Mon Sep 17 00:00:00 2001
From: Alvaro Herrera <[email protected]>
Date: Mon, 4 Sep 2023 18:05:33 +0200
Subject: [PATCH v2 2/2] add information_schema test
---
.../regress/expected/information_schema.out | 691 ++++++++++++++++++
src/test/regress/parallel_schedule | 5 +-
src/test/regress/sql/information_schema.sql | 41 ++
3 files changed, 735 insertions(+), 2 deletions(-)
create mode 100644 src/test/regress/expected/information_schema.out
create mode 100644 src/test/regress/sql/information_schema.sql
diff --git a/src/test/regress/expected/information_schema.out b/src/test/regress/expected/information_schema.out
new file mode 100644
index 0000000000..0b7b93eb69
--- /dev/null
+++ b/src/test/regress/expected/information_schema.out
@@ -0,0 +1,691 @@
+-- We test the information schema last, so that we examine
+-- database state at the end of the regression test run.
+--
+-- Table constraints
+--
+SELECT * FROM information_schema.check_constraints
+ WHERE constraint_schema = 'public'
+ ORDER BY constraint_name;
+ constraint_catalog | constraint_schema | constraint_name | check_clause
+--------------------+-------------------+--------------------------------------------+-----------------------------------------------------------------------
+ regression | public | atnotnull1_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | atnotnull1_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | bar1_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | bar2_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | blocal | (((b)::double precision < (1000)::double precision))
+ regression | public | bmerged | (((b)::double precision > (1)::double precision))
+ regression | public | bmerged | (((b)::double precision > (1)::double precision))
+ regression | public | bnoinherit | (((b)::double precision > (100)::double precision)) NO INHERIT
+ regression | public | boolvalues_value_not_null | CHECK (value IS NOT NULL)
+ regression | public | brinopers_bloom_check | ((cardinality(op) = cardinality(value)))
+ regression | public | brinopers_bloom_check1 | ((cardinality(op) = cardinality(matches)))
+ regression | public | brinopers_check | ((cardinality(op) = cardinality(value)))
+ regression | public | brinopers_check1 | ((cardinality(op) = cardinality(matches)))
+ regression | public | brinopers_multi_check | ((cardinality(op) = cardinality(value)))
+ regression | public | brinopers_multi_check1 | ((cardinality(op) = cardinality(matches)))
+ regression | public | cc1_f1_not_null | CHECK (f1 IS NOT NULL)
+ regression | public | cc1_f1_not_null | CHECK (f1 IS NOT NULL)
+ regression | public | check_b | (((b IS NULL) OR (b = 'a'::bpchar)))
+ regression | public | check_con | ((x > 3))
+ regression | public | check_con_tbl_check | (check_con_function(check_con_tbl.*))
+ regression | public | chk | ((b < 50)) NOT VALID
+ regression | public | clstr_tst_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | clstr_tst_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | clstr_tst_s_rf_a_not_null | CHECK (rf_a IS NOT NULL)
+ regression | public | cnn_child2_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | cnn_child2_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | cnn_child_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | cnn_grandchild_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | cnn_grandchild_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | comment_test_positive_col_check | ((positive_col > 0))
+ regression | public | con_check | ((VALUE > 0))
+ regression | public | copy_con | (((x > 3) AND (y <> 'check failed'::text) AND (x < 7)))
+ regression | public | customer_name_not_null | CHECK (name IS NOT NULL)
+ regression | public | foo | ((xx = 'text'::text))
+ regression | public | gtest1_1_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | gtest1_y_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | gtest20_b_check | ((b < 50))
+ regression | public | gtest21a_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | gtest_child3_f1_not_null | CHECK (f1 IS NOT NULL)
+ regression | public | gtest_parent_f1_not_null | CHECK (f1 IS NOT NULL)
+ regression | public | gtest_parent_f1_not_null | CHECK (f1 IS NOT NULL)
+ regression | public | gtest_parent_f1_not_null | CHECK (f1 IS NOT NULL)
+ regression | public | gtestdomain1_check | ((VALUE < 10))
+ regression | public | gtestx_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | gtestxx_1_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | gtestxx_3_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | gtestxx_4_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | inh_check_constraint | ((f1 > 0)) NOT VALID
+ regression | public | inh_check_constraint | ((f1 > 0))
+ regression | public | insert_tbl_check | (((x + z) = 0))
+ regression | public | insert_tbl_con | (((x >= 3) AND (y <> 'check failed'::text) AND (x < 8)))
+ regression | public | itest10_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | itest11_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | itest13_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | itest13_c_not_null | CHECK (c IS NOT NULL)
+ regression | public | itest14_id_not_null | CHECK (id IS NOT NULL)
+ regression | public | itest1_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | itest2_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | itest3_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | itest3_c_not_null | CHECK (c IS NOT NULL)
+ regression | public | itest5_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | itest6_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | itest7_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | itest7_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | itest7c_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | itest7d_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | itest7d_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | itest9_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | list_parted2_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | meow | ((VALUE < 11))
+ regression | public | mlparted11_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | mlparted1_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | mlparted1_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | mlparted1_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | mlparted1_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | mlparted1_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | mlparted2_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | mlparted2_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | mlparted4_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | mvtest_t_amt_not_null | CHECK (amt IS NOT NULL)
+ regression | public | mvtest_t_id_not_null | CHECK (id IS NOT NULL)
+ regression | public | mvtest_t_type_not_null | CHECK (type IS NOT NULL)
+ regression | public | notnull_tbl3_a_check | ((a IS NOT NULL))
+ regression | public | nv_child_2009_d_check | (((d >= '01-01-2009'::date) AND (d <= '12-31-2009'::date)))
+ regression | public | nv_child_2010_d_check | (((d >= '01-01-2010'::date) AND (d <= '12-31-2010'::date))) NOT VALID
+ regression | public | nv_child_2011_d_check | (((d >= '01-01-2011'::date) AND (d <= '12-31-2011'::date)))
+ regression | public | nv_parent_check | (false) NO INHERIT
+ regression | public | nv_parent_d_check | (((d >= '01-01-2001'::date) AND (d <= '12-31-2099'::date))) NOT VALID
+ regression | public | nv_parent_d_check | (((d >= '01-01-2001'::date) AND (d <= '12-31-2099'::date))) NOT VALID
+ regression | public | nv_parent_d_check | (((d >= '01-01-2001'::date) AND (d <= '12-31-2099'::date))) NOT VALID
+ regression | public | nv_parent_d_check | (((d >= '01-01-2001'::date) AND (d <= '12-31-2099'::date))) NOT VALID
+ regression | public | orderedpair_check | (((VALUE)[1] < (VALUE)[2]))
+ regression | public | part1_a_check | ((a = 1))
+ regression | public | part1_a_not_null | CHECK (a IS NOT NULL)
+ regression | public | part1_b_check | (((b >= 1) AND (b <= 10)))
+ regression | public | part1_b_not_null | CHECK (b IS NOT NULL)
+ regression | public | part1_self_fk_id_not_null | CHECK (id IS NOT NULL)
+ regression | public | part33_self_fk_id_not_null | CHECK (id IS NOT NULL)
+ regression | public | part3_self_fk_id_not_null | CHECK (id IS NOT NULL)
+ regression | public | part3_self_fk_id_not_null | CHECK (id IS NOT NULL)
+ regression | public | part_rp100_a_check | (((a >= 123) AND (a < 133) AND (a IS NOT NULL)))
+ regression | public | part_rp_a_check | (((a IS NOT NULL) AND (a >= 0) AND (a < 100)))
+ regression | public | parted_self_fk_id_not_null | CHECK (id IS NOT NULL)
+ regression | public | parted_self_fk_id_not_null | CHECK (id IS NOT NULL)
+ regression | public | persons3_name_not_null | CHECK (name IS NOT NULL)
+ regression | public | plpgsql_arr_domain_check | (plpgsql_arr_domain_check(VALUE))
+ regression | public | plpgsql_domain_check | (plpgsql_domain_check(VALUE))
+ regression | public | pos_int_check | ((VALUE > 0))
+ regression | public | reservations_room_id_not_null | CHECK (room_id IS NOT NULL)
+ regression | public | rules_log_id_not_null | CHECK (id IS NOT NULL)
+ regression | public | sequence_con | (((x > 3) AND (y <> 'check failed'::text) AND (z < 8)))
+ regression | public | sorted | (((VALUE)[1] < (VALUE)[2]))
+ regression | public | spgist_box_tbl_id_not_null | CHECK (id IS NOT NULL)
+ regression | public | spgist_unlogged_tbl_id_not_null | CHECK (id IS NOT NULL)
+ regression | public | str_domain2_check | ((VALUE <> 'foo'::text))
+ regression | public | test_inh_check_a_check | (((a)::double precision > (10.2)::double precision))
+ regression | public | test_inh_check_a_check | (((a)::double precision > (10.2)::double precision))
+ regression | public | transition_table_level1_level1_no_not_null | CHECK (level1_no IS NOT NULL)
+ regression | public | transition_table_level2_level2_no_not_null | CHECK (level2_no IS NOT NULL)
+ regression | public | transition_table_level2_parent_no_not_null | CHECK (parent_no IS NOT NULL)
+ regression | public | transition_table_status_level_not_null | CHECK (level IS NOT NULL)
+ regression | public | transition_table_status_node_no_not_null | CHECK (node_no IS NOT NULL)
+ regression | public | truncate_b_id_not_null | CHECK (id IS NOT NULL)
+ regression | public | tt0_x_not_null | CHECK (x IS NOT NULL)
+ regression | public | tt0_x_not_null | CHECK (x IS NOT NULL)
+(125 rows)
+
+SELECT * FROM information_schema.constraint_column_usage
+ WHERE constraint_schema = 'public'
+ ORDER BY table_name, column_name, constraint_name;
+ table_catalog | table_schema | table_name | column_name | constraint_catalog | constraint_schema | constraint_name
+---------------+--------------+-------------------------------------+--------------+--------------------+-------------------+--------------------------------------------
+ regression | public | alter_table_under_transition_tables | id | regression | public | alter_table_under_transition_tables_pkey
+ regression | public | atnotnull1 | a | regression | public | atnotnull1_a_not_null
+ regression | public | atnotnull1 | b | regression | public | atnotnull1_b_not_null
+ regression | public | atnotnull1 | c | regression | public | atnotnull1_pkey
+ regression | public | bar1 | b | regression | public | bar1_b_not_null
+ regression | public | bar2 | b | regression | public | bar2_b_not_null
+ regression | public | boolvalues | value | regression | public | boolvalues_value_not_null
+ regression | public | brinopers | matches | regression | public | brinopers_check1
+ regression | public | brinopers | op | regression | public | brinopers_check
+ regression | public | brinopers | op | regression | public | brinopers_check1
+ regression | public | brinopers | value | regression | public | brinopers_check
+ regression | public | brinopers_bloom | matches | regression | public | brinopers_bloom_check1
+ regression | public | brinopers_bloom | op | regression | public | brinopers_bloom_check
+ regression | public | brinopers_bloom | op | regression | public | brinopers_bloom_check1
+ regression | public | brinopers_bloom | value | regression | public | brinopers_bloom_check
+ regression | public | brinopers_multi | matches | regression | public | brinopers_multi_check1
+ regression | public | brinopers_multi | op | regression | public | brinopers_multi_check
+ regression | public | brinopers_multi | op | regression | public | brinopers_multi_check1
+ regression | public | brinopers_multi | value | regression | public | brinopers_multi_check
+ regression | public | cc1 | f1 | regression | public | cc1_f1_not_null
+ regression | public | cc2 | f1 | regression | public | cc1_f1_not_null
+ regression | public | check2_tbl | x | regression | public | sequence_con
+ regression | public | check2_tbl | y | regression | public | sequence_con
+ regression | public | check2_tbl | z | regression | public | sequence_con
+ regression | public | check_tbl | x | regression | public | check_con
+ regression | public | clstr_tst | a | regression | public | clstr_tst_a_not_null
+ regression | public | clstr_tst | a | regression | public | clstr_tst_pkey
+ regression | public | clstr_tst_inh | a | regression | public | clstr_tst_a_not_null
+ regression | public | clstr_tst_s | rf_a | regression | public | clstr_tst_con
+ regression | public | clstr_tst_s | rf_a | regression | public | clstr_tst_s_pkey
+ regression | public | clstr_tst_s | rf_a | regression | public | clstr_tst_s_rf_a_not_null
+ regression | public | cnn_child | b | regression | public | cnn_child_b_not_null
+ regression | public | cnn_child2 | a | regression | public | cnn_child2_a_not_null
+ regression | public | cnn_child2 | b | regression | public | cnn_child2_b_not_null
+ regression | public | cnn_grandchild | b | regression | public | cnn_grandchild_b_not_null
+ regression | public | cnn_grandchild2 | b | regression | public | cnn_grandchild_b_not_null
+ regression | public | cnn_parent | b | regression | public | b_uq
+ regression | public | comment_test | id | regression | public | comment_test_child_fk
+ regression | public | comment_test | id | regression | public | comment_test_pk
+ regression | public | comment_test | positive_col | regression | public | comment_test_positive_col_check
+ regression | public | copy_tbl | x | regression | public | copy_con
+ regression | public | copy_tbl | y | regression | public | copy_con
+ regression | public | customer | cid | regression | public | credit_card_cid_fkey
+ regression | public | customer | cid | regression | public | credit_usage_cid_fkey
+ regression | public | customer | cid | regression | public | customer_pkey
+ regression | public | customer | name | regression | public | customer_name_not_null
+ regression | public | delete_test_table | a | regression | public | delete_test_table_pkey
+ regression | public | delete_test_table | b | regression | public | delete_test_table_pkey
+ regression | public | delete_test_table | c | regression | public | delete_test_table_pkey
+ regression | public | delete_test_table | d | regression | public | delete_test_table_pkey
+ regression | public | ec0 | ff | regression | public | ec0_pkey
+ regression | public | ec1 | ff | regression | public | ec1_pkey
+ regression | public | ec2 | xf | regression | public | ec2_pkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_notpartitioned_pk_pkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_4_2_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_4_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_4_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_4_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_5_1_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_5_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_5_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_5_a_b_fkey1
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_5_a_b_fkey1
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | a | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_notpartitioned_pk_pkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_4_2_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_4_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_4_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_4_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_5_1_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_5_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_5_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_5_a_b_fkey1
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_5_a_b_fkey1
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | fk_notpartitioned_pk | b | regression | public | fk_partitioned_fk_a_b_fkey
+ regression | public | gtest0 | a | regression | public | gtest0_pkey
+ regression | public | gtest1 | a | regression | public | gtest1_pkey
+ regression | public | gtest10 | a | regression | public | gtest10_pkey
+ regression | public | gtest10a | a | regression | public | gtest10a_pkey
+ regression | public | gtest1_1 | a | regression | public | gtest1_1_a_not_null
+ regression | public | gtest1_y | a | regression | public | gtest1_y_a_not_null
+ regression | public | gtest2 | a | regression | public | gtest2_pkey
+ regression | public | gtest20 | a | regression | public | gtest20_pkey
+ regression | public | gtest20 | b | regression | public | gtest20_b_check
+ regression | public | gtest20a | a | regression | public | gtest20a_pkey
+ regression | public | gtest20b | a | regression | public | gtest20b_pkey
+ regression | public | gtest20b | b | regression | public | chk
+ regression | public | gtest21a | a | regression | public | gtest21a_pkey
+ regression | public | gtest21a | b | regression | public | gtest21a_b_not_null
+ regression | public | gtest21b | a | regression | public | gtest21b_pkey
+ regression | public | gtest22a | a | regression | public | gtest22a_pkey
+ regression | public | gtest22a | b | regression | public | gtest22a_b_key
+ regression | public | gtest22b | a | regression | public | gtest22b_pkey
+ regression | public | gtest22b | b | regression | public | gtest22b_pkey
+ regression | public | gtest23p | y | regression | public | gtest23p_pkey
+ regression | public | gtest23p | y | regression | public | gtest23q_b_fkey
+ regression | public | gtest23q | a | regression | public | gtest23q_pkey
+ regression | public | gtest24 | a | regression | public | gtest24_pkey
+ regression | public | gtest25 | a | regression | public | gtest25_pkey
+ regression | public | gtest26 | a | regression | public | gtest26_pkey
+ regression | public | gtest_child | f1 | regression | public | gtest_parent_f1_not_null
+ regression | public | gtest_child2 | f1 | regression | public | gtest_parent_f1_not_null
+ regression | public | gtest_child3 | f1 | regression | public | gtest_child3_f1_not_null
+ regression | public | gtest_parent | f1 | regression | public | gtest_parent_f1_not_null
+ regression | public | gtest_tableoid | a | regression | public | gtest_tableoid_pkey
+ regression | public | gtestx | a | regression | public | gtestx_a_not_null
+ regression | public | gtestxx_1 | a | regression | public | gtestxx_1_a_not_null
+ regression | public | gtestxx_3 | a | regression | public | gtestxx_3_a_not_null
+ regression | public | gtestxx_4 | a | regression | public | gtestxx_4_a_not_null
+ regression | public | idxpart_another | a | regression | public | idxpart_another_pkey
+ regression | public | idxpart_another | b | regression | public | idxpart_another_pkey
+ regression | public | idxpart_another_1 | a | regression | public | idxpart_another_1_pkey
+ regression | public | idxpart_another_1 | b | regression | public | idxpart_another_1_pkey
+ regression | public | inh_test | b | regression | public | list_parted2_b_not_null
+ regression | public | inhx | xx | regression | public | foo
+ regression | public | inhx | xx | regression | public | inhx_pkey
+ regression | public | insert_tbl | x | regression | public | insert_tbl_check
+ regression | public | insert_tbl | x | regression | public | insert_tbl_con
+ regression | public | insert_tbl | y | regression | public | insert_tbl_con
+ regression | public | insert_tbl | z | regression | public | insert_tbl_check
+ regression | public | invalid_check_con | f1 | regression | public | inh_check_constraint
+ regression | public | invalid_check_con_child | f1 | regression | public | inh_check_constraint
+ regression | public | itest1 | a | regression | public | itest1_a_not_null
+ regression | public | itest10 | a | regression | public | itest10_a_not_null
+ regression | public | itest11 | a | regression | public | itest11_a_not_null
+ regression | public | itest13 | b | regression | public | itest13_b_not_null
+ regression | public | itest13 | c | regression | public | itest13_c_not_null
+ regression | public | itest14 | id | regression | public | itest14_id_not_null
+ regression | public | itest2 | a | regression | public | itest2_a_not_null
+ regression | public | itest3 | a | regression | public | itest3_a_not_null
+ regression | public | itest3 | c | regression | public | itest3_c_not_null
+ regression | public | itest5 | a | regression | public | itest5_a_not_null
+ regression | public | itest6 | a | regression | public | itest6_a_not_null
+ regression | public | itest7 | a | regression | public | itest7_a_not_null
+ regression | public | itest7a | a | regression | public | itest7_a_not_null
+ regression | public | itest7c | a | regression | public | itest7c_a_not_null
+ regression | public | itest7d | a | regression | public | itest7d_a_not_null
+ regression | public | itest7e | a | regression | public | itest7d_a_not_null
+ regression | public | itest9 | a | regression | public | itest9_a_not_null
+ regression | public | mlparted1 | a | regression | public | mlparted1_a_not_null
+ regression | public | mlparted1 | b | regression | public | mlparted1_b_not_null
+ regression | public | mlparted11 | a | regression | public | mlparted11_a_not_null
+ regression | public | mlparted11 | b | regression | public | mlparted1_b_not_null
+ regression | public | mlparted12 | a | regression | public | mlparted1_a_not_null
+ regression | public | mlparted12 | b | regression | public | mlparted1_b_not_null
+ regression | public | mlparted2 | a | regression | public | mlparted2_a_not_null
+ regression | public | mlparted2 | b | regression | public | mlparted2_b_not_null
+ regression | public | mlparted4 | a | regression | public | mlparted4_a_not_null
+ regression | public | mvtest_t | amt | regression | public | mvtest_t_amt_not_null
+ regression | public | mvtest_t | id | regression | public | mvtest_t_id_not_null
+ regression | public | mvtest_t | id | regression | public | mvtest_t_pkey
+ regression | public | mvtest_t | type | regression | public | mvtest_t_type_not_null
+ regression | public | notnull_tbl2 | a | regression | public | notnull_tbl2_pkey
+ regression | public | notnull_tbl3 | a | regression | public | notnull_tbl3_a_check
+ regression | public | nv_child_2009 | d | regression | public | nv_child_2009_d_check
+ regression | public | nv_child_2009 | d | regression | public | nv_parent_d_check
+ regression | public | nv_child_2010 | d | regression | public | nv_child_2010_d_check
+ regression | public | nv_child_2010 | d | regression | public | nv_parent_d_check
+ regression | public | nv_child_2011 | d | regression | public | nv_child_2011_d_check
+ regression | public | nv_child_2011 | d | regression | public | nv_parent_d_check
+ regression | public | nv_parent | d | regression | public | nv_parent_d_check
+ regression | public | part1_self_fk | id | regression | public | part1_self_fk_id_not_null
+ regression | public | part1_self_fk | id | regression | public | part1_self_fk_pkey
+ regression | public | part2_self_fk | id | regression | public | part2_self_fk_pkey
+ regression | public | part2_self_fk | id | regression | public | parted_self_fk_id_not_null
+ regression | public | part32_self_fk | id | regression | public | part32_self_fk_pkey
+ regression | public | part32_self_fk | id | regression | public | part3_self_fk_id_not_null
+ regression | public | part33_self_fk | id | regression | public | part33_self_fk_id_not_null
+ regression | public | part33_self_fk | id | regression | public | part33_self_fk_pkey
+ regression | public | part3_self_fk | id | regression | public | part3_self_fk_id_not_null
+ regression | public | part3_self_fk | id | regression | public | part3_self_fk_pkey
+ regression | public | part_7_a_null | b | regression | public | check_b
+ regression | public | part_rp | a | regression | public | part_rp_a_check
+ regression | public | part_rp100 | a | regression | public | part_rp100_a_check
+ regression | public | parted_self_fk | id | regression | public | parted_self_fk_id_abc_fkey
+ regression | public | parted_self_fk | id | regression | public | parted_self_fk_id_abc_fkey
+ regression | public | parted_self_fk | id | regression | public | parted_self_fk_id_abc_fkey
+ regression | public | parted_self_fk | id | regression | public | parted_self_fk_id_abc_fkey
+ regression | public | parted_self_fk | id | regression | public | parted_self_fk_id_abc_fkey
+ regression | public | parted_self_fk | id | regression | public | parted_self_fk_id_abc_fkey
+ regression | public | parted_self_fk | id | regression | public | parted_self_fk_id_not_null
+ regression | public | parted_self_fk | id | regression | public | parted_self_fk_pkey
+ regression | public | partr_def2 | a | regression | public | part1_a_check
+ regression | public | partr_def2 | a | regression | public | part1_a_not_null
+ regression | public | partr_def2 | b | regression | public | part1_b_check
+ regression | public | partr_def2 | b | regression | public | part1_b_not_null
+ regression | public | persons2 | id | regression | public | persons2_pkey
+ regression | public | persons2 | name | regression | public | persons2_name_key
+ regression | public | persons3 | id | regression | public | persons3_pkey
+ regression | public | persons3 | name | regression | public | persons3_name_not_null
+ regression | public | pp1 | f1 | regression | public | pp1_pkey
+ regression | public | reservations | room_id | regression | public | reservations_room_id_not_null
+ regression | public | rule_and_refint_t1 | id1a | regression | public | rule_and_refint_t1_pkey
+ regression | public | rule_and_refint_t1 | id1a | regression | public | rule_and_refint_t3_id3a_id3b_fkey
+ regression | public | rule_and_refint_t1 | id1b | regression | public | rule_and_refint_t1_pkey
+ regression | public | rule_and_refint_t1 | id1b | regression | public | rule_and_refint_t3_id3a_id3b_fkey
+ regression | public | rule_and_refint_t2 | id2a | regression | public | rule_and_refint_t2_pkey
+ regression | public | rule_and_refint_t2 | id2a | regression | public | rule_and_refint_t3_id3a_id3c_fkey
+ regression | public | rule_and_refint_t2 | id2c | regression | public | rule_and_refint_t2_pkey
+ regression | public | rule_and_refint_t2 | id2c | regression | public | rule_and_refint_t3_id3a_id3c_fkey
+ regression | public | rule_and_refint_t3 | id3a | regression | public | rule_and_refint_t3_pkey
+ regression | public | rule_and_refint_t3 | id3b | regression | public | rule_and_refint_t3_pkey
+ regression | public | rule_and_refint_t3 | id3c | regression | public | rule_and_refint_t3_pkey
+ regression | public | rules_log | id | regression | public | rules_log_id_not_null
+ regression | public | skip_wal_skip_rewrite_index | c | regression | public | skip_wal_skip_rewrite_index_pkey
+ regression | public | spgist_box_tbl | id | regression | public | spgist_box_tbl_id_not_null
+ regression | public | spgist_unlogged_tbl | id | regression | public | spgist_unlogged_tbl_id_not_null
+ regression | public | tbl_include_box | c1 | regression | public | tbl_include_box_idx_unique
+ regression | public | tbl_include_box | c2 | regression | public | tbl_include_box_idx_unique
+ regression | public | tbl_include_pk | c1 | regression | public | tbl_include_pk_pkey
+ regression | public | tbl_include_pk | c2 | regression | public | tbl_include_pk_pkey
+ regression | public | tbl_include_unique1 | c1 | regression | public | tbl_include_unique1_c1_c2_c3_c4_key
+ regression | public | tbl_include_unique1 | c1 | regression | public | tbl_include_unique1_idx_unique
+ regression | public | tbl_include_unique1 | c2 | regression | public | tbl_include_unique1_c1_c2_c3_c4_key
+ regression | public | tbl_include_unique1 | c2 | regression | public | tbl_include_unique1_idx_unique
+ regression | public | test_inh_check | a | regression | public | test_inh_check_a_check
+ regression | public | test_inh_check | b | regression | public | bmerged
+ regression | public | test_inh_check | b | regression | public | bnoinherit
+ regression | public | test_inh_check_child | a | regression | public | test_inh_check_a_check
+ regression | public | test_inh_check_child | b | regression | public | blocal
+ regression | public | test_inh_check_child | b | regression | public | bmerged
+ regression | public | transition_table_base | id | regression | public | transition_table_base_pkey
+ regression | public | transition_table_level1 | level1_no | regression | public | transition_table_level1_level1_no_not_null
+ regression | public | transition_table_level1 | level1_no | regression | public | transition_table_level1_pkey
+ regression | public | transition_table_level2 | level2_no | regression | public | transition_table_level2_level2_no_not_null
+ regression | public | transition_table_level2 | level2_no | regression | public | transition_table_level2_pkey
+ regression | public | transition_table_level2 | parent_no | regression | public | transition_table_level2_parent_no_not_null
+ regression | public | transition_table_status | level | regression | public | transition_table_status_level_not_null
+ regression | public | transition_table_status | level | regression | public | transition_table_status_pkey
+ regression | public | transition_table_status | node_no | regression | public | transition_table_status_node_no_not_null
+ regression | public | transition_table_status | node_no | regression | public | transition_table_status_pkey
+ regression | public | trigger_parted | a | regression | public | trigger_parted_pkey
+ regression | public | trigger_parted_p1 | a | regression | public | trigger_parted_p1_pkey
+ regression | public | trigger_parted_p1_1 | a | regression | public | trigger_parted_p1_1_pkey
+ regression | public | trigger_parted_p2 | a | regression | public | trigger_parted_p2_pkey
+ regression | public | trigger_parted_p2_2 | a | regression | public | trigger_parted_p2_2_pkey
+ regression | public | truncate_b | id | regression | public | truncate_b_id_not_null
+ regression | public | tt0 | x | regression | public | tt0_x_not_null
+ regression | public | tt6 | x | regression | public | tt0_x_not_null
+ regression | public | utf8_verification_inputs | description | regression | public | utf8_verification_inputs_pkey
+ regression | public | view_base_table | key | regression | public | view_base_table_pkey
+(255 rows)
+
+SELECT * FROM information_schema.table_constraints
+ WHERE constraint_schema = 'public'
+ ORDER BY table_name, constraint_name;
+ constraint_catalog | constraint_schema | constraint_name | table_catalog | table_schema | table_name | constraint_type | is_deferrable | initially_deferred | enforced | nulls_distinct
+--------------------+-------------------+--------------------------------------------+---------------+--------------+-------------------------------------+-----------------+---------------+--------------------+----------+----------------
+ regression | public | alter_table_under_transition_tables_pkey | regression | public | alter_table_under_transition_tables | PRIMARY KEY | NO | NO | YES |
+ regression | public | atnotnull1_a_not_null | regression | public | atnotnull1 | CHECK | NO | NO | YES |
+ regression | public | atnotnull1_b_not_null | regression | public | atnotnull1 | CHECK | NO | NO | YES |
+ regression | public | atnotnull1_pkey | regression | public | atnotnull1 | PRIMARY KEY | NO | NO | YES |
+ regression | public | bar1_b_not_null | regression | public | bar1 | CHECK | NO | NO | YES |
+ regression | public | bar2_b_not_null | regression | public | bar2 | CHECK | NO | NO | YES |
+ regression | public | boolvalues_value_not_null | regression | public | boolvalues | CHECK | NO | NO | YES |
+ regression | public | brinopers_check | regression | public | brinopers | CHECK | NO | NO | YES |
+ regression | public | brinopers_check1 | regression | public | brinopers | CHECK | NO | NO | YES |
+ regression | public | brinopers_bloom_check | regression | public | brinopers_bloom | CHECK | NO | NO | YES |
+ regression | public | brinopers_bloom_check1 | regression | public | brinopers_bloom | CHECK | NO | NO | YES |
+ regression | public | brinopers_multi_check | regression | public | brinopers_multi | CHECK | NO | NO | YES |
+ regression | public | brinopers_multi_check1 | regression | public | brinopers_multi | CHECK | NO | NO | YES |
+ regression | public | cc1_f1_not_null | regression | public | cc1 | CHECK | NO | NO | YES |
+ regression | public | cc1_f1_not_null | regression | public | cc2 | CHECK | NO | NO | YES |
+ regression | public | sequence_con | regression | public | check2_tbl | CHECK | NO | NO | YES |
+ regression | public | check_con_tbl_check | regression | public | check_con_tbl | CHECK | NO | NO | YES |
+ regression | public | check_con | regression | public | check_tbl | CHECK | NO | NO | YES |
+ regression | public | clstr_tst_a_not_null | regression | public | clstr_tst | CHECK | NO | NO | YES |
+ regression | public | clstr_tst_con | regression | public | clstr_tst | FOREIGN KEY | NO | NO | YES |
+ regression | public | clstr_tst_pkey | regression | public | clstr_tst | PRIMARY KEY | NO | NO | YES |
+ regression | public | clstr_tst_a_not_null | regression | public | clstr_tst_inh | CHECK | NO | NO | YES |
+ regression | public | clstr_tst_s_pkey | regression | public | clstr_tst_s | PRIMARY KEY | NO | NO | YES |
+ regression | public | clstr_tst_s_rf_a_not_null | regression | public | clstr_tst_s | CHECK | NO | NO | YES |
+ regression | public | cnn_child_b_not_null | regression | public | cnn_child | CHECK | NO | NO | YES |
+ regression | public | cnn_child2_a_not_null | regression | public | cnn_child2 | CHECK | NO | NO | YES |
+ regression | public | cnn_child2_b_not_null | regression | public | cnn_child2 | CHECK | NO | NO | YES |
+ regression | public | cnn_grandchild_b_not_null | regression | public | cnn_grandchild | CHECK | NO | NO | YES |
+ regression | public | cnn_grandchild_b_not_null | regression | public | cnn_grandchild2 | CHECK | NO | NO | YES |
+ regression | public | b_uq | regression | public | cnn_parent | PRIMARY KEY | NO | NO | YES |
+ regression | public | comment_test_pk | regression | public | comment_test | PRIMARY KEY | NO | NO | YES |
+ regression | public | comment_test_positive_col_check | regression | public | comment_test | CHECK | NO | NO | YES |
+ regression | public | comment_test_child_fk | regression | public | comment_test_child | FOREIGN KEY | NO | NO | YES |
+ regression | public | copy_con | regression | public | copy_tbl | CHECK | NO | NO | YES |
+ regression | public | credit_card_cid_fkey | regression | public | credit_card | FOREIGN KEY | NO | NO | YES |
+ regression | public | credit_usage_cid_fkey | regression | public | credit_usage | FOREIGN KEY | NO | NO | YES |
+ regression | public | customer_name_not_null | regression | public | customer | CHECK | NO | NO | YES |
+ regression | public | customer_pkey | regression | public | customer | PRIMARY KEY | NO | NO | YES |
+ regression | public | delete_test_table_pkey | regression | public | delete_test_table | PRIMARY KEY | NO | NO | YES |
+ regression | public | ec0_pkey | regression | public | ec0 | PRIMARY KEY | NO | NO | YES |
+ regression | public | ec1_pkey | regression | public | ec1 | PRIMARY KEY | NO | NO | YES |
+ regression | public | ec2_pkey | regression | public | ec2 | PRIMARY KEY | NO | NO | YES |
+ regression | public | fk_notpartitioned_pk_pkey | regression | public | fk_notpartitioned_pk | PRIMARY KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_a_b_fkey | regression | public | fk_partitioned_fk | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_a_b_fkey | regression | public | fk_partitioned_fk_1 | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_a_b_fkey | regression | public | fk_partitioned_fk_2 | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_a_b_fkey | regression | public | fk_partitioned_fk_2_1 | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_a_b_fkey | regression | public | fk_partitioned_fk_2_2 | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_a_b_fkey | regression | public | fk_partitioned_fk_3 | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_4_a_b_fkey | regression | public | fk_partitioned_fk_4 | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_4_a_b_fkey | regression | public | fk_partitioned_fk_4_1 | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_4_2_a_b_fkey | regression | public | fk_partitioned_fk_4_2 | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_4_a_b_fkey | regression | public | fk_partitioned_fk_4_2 | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_5_a_b_fkey | regression | public | fk_partitioned_fk_5 | FOREIGN KEY | YES | NO | YES |
+ regression | public | fk_partitioned_fk_5_a_b_fkey1 | regression | public | fk_partitioned_fk_5 | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_a_b_fkey | regression | public | fk_partitioned_fk_5 | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_5_1_a_b_fkey | regression | public | fk_partitioned_fk_5_1 | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_5_a_b_fkey | regression | public | fk_partitioned_fk_5_1 | FOREIGN KEY | YES | NO | YES |
+ regression | public | fk_partitioned_fk_5_a_b_fkey1 | regression | public | fk_partitioned_fk_5_1 | FOREIGN KEY | NO | NO | YES |
+ regression | public | fk_partitioned_fk_a_b_fkey | regression | public | fk_partitioned_fk_5_1 | FOREIGN KEY | NO | NO | YES |
+ regression | public | gtest0_pkey | regression | public | gtest0 | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest1_pkey | regression | public | gtest1 | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest10_pkey | regression | public | gtest10 | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest10a_pkey | regression | public | gtest10a | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest1_1_a_not_null | regression | public | gtest1_1 | CHECK | NO | NO | YES |
+ regression | public | gtest1_y_a_not_null | regression | public | gtest1_y | CHECK | NO | NO | YES |
+ regression | public | gtest2_pkey | regression | public | gtest2 | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest20_b_check | regression | public | gtest20 | CHECK | NO | NO | YES |
+ regression | public | gtest20_pkey | regression | public | gtest20 | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest20a_pkey | regression | public | gtest20a | PRIMARY KEY | NO | NO | YES |
+ regression | public | chk | regression | public | gtest20b | CHECK | NO | NO | YES |
+ regression | public | gtest20b_pkey | regression | public | gtest20b | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest21a_b_not_null | regression | public | gtest21a | CHECK | NO | NO | YES |
+ regression | public | gtest21a_pkey | regression | public | gtest21a | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest21b_pkey | regression | public | gtest21b | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest22a_b_key | regression | public | gtest22a | UNIQUE | NO | NO | YES | YES
+ regression | public | gtest22a_pkey | regression | public | gtest22a | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest22b_pkey | regression | public | gtest22b | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest23p_pkey | regression | public | gtest23p | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest23q_b_fkey | regression | public | gtest23q | FOREIGN KEY | NO | NO | YES |
+ regression | public | gtest23q_pkey | regression | public | gtest23q | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest24_pkey | regression | public | gtest24 | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest25_pkey | regression | public | gtest25 | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest26_pkey | regression | public | gtest26 | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtest_parent_f1_not_null | regression | public | gtest_child | CHECK | NO | NO | YES |
+ regression | public | gtest_parent_f1_not_null | regression | public | gtest_child2 | CHECK | NO | NO | YES |
+ regression | public | gtest_child3_f1_not_null | regression | public | gtest_child3 | CHECK | NO | NO | YES |
+ regression | public | gtest_parent_f1_not_null | regression | public | gtest_parent | CHECK | NO | NO | YES |
+ regression | public | gtest_tableoid_pkey | regression | public | gtest_tableoid | PRIMARY KEY | NO | NO | YES |
+ regression | public | gtestx_a_not_null | regression | public | gtestx | CHECK | NO | NO | YES |
+ regression | public | gtestxx_1_a_not_null | regression | public | gtestxx_1 | CHECK | NO | NO | YES |
+ regression | public | gtestxx_3_a_not_null | regression | public | gtestxx_3 | CHECK | NO | NO | YES |
+ regression | public | gtestxx_4_a_not_null | regression | public | gtestxx_4 | CHECK | NO | NO | YES |
+ regression | public | idxpart_another_pkey | regression | public | idxpart_another | PRIMARY KEY | NO | NO | YES |
+ regression | public | idxpart_another_1_pkey | regression | public | idxpart_another_1 | PRIMARY KEY | NO | NO | YES |
+ regression | public | list_parted2_b_not_null | regression | public | inh_test | CHECK | NO | NO | YES |
+ regression | public | foo | regression | public | inhx | CHECK | NO | NO | YES |
+ regression | public | inhx_pkey | regression | public | inhx | PRIMARY KEY | NO | NO | YES |
+ regression | public | insert_tbl_check | regression | public | insert_tbl | CHECK | NO | NO | YES |
+ regression | public | insert_tbl_con | regression | public | insert_tbl | CHECK | NO | NO | YES |
+ regression | public | inh_check_constraint | regression | public | invalid_check_con | CHECK | NO | NO | YES |
+ regression | public | inh_check_constraint | regression | public | invalid_check_con_child | CHECK | NO | NO | YES |
+ regression | public | itest1_a_not_null | regression | public | itest1 | CHECK | NO | NO | YES |
+ regression | public | itest10_a_not_null | regression | public | itest10 | CHECK | NO | NO | YES |
+ regression | public | itest11_a_not_null | regression | public | itest11 | CHECK | NO | NO | YES |
+ regression | public | itest13_b_not_null | regression | public | itest13 | CHECK | NO | NO | YES |
+ regression | public | itest13_c_not_null | regression | public | itest13 | CHECK | NO | NO | YES |
+ regression | public | itest14_id_not_null | regression | public | itest14 | CHECK | NO | NO | YES |
+ regression | public | itest2_a_not_null | regression | public | itest2 | CHECK | NO | NO | YES |
+ regression | public | itest3_a_not_null | regression | public | itest3 | CHECK | NO | NO | YES |
+ regression | public | itest3_c_not_null | regression | public | itest3 | CHECK | NO | NO | YES |
+ regression | public | itest5_a_not_null | regression | public | itest5 | CHECK | NO | NO | YES |
+ regression | public | itest6_a_not_null | regression | public | itest6 | CHECK | NO | NO | YES |
+ regression | public | itest7_a_not_null | regression | public | itest7 | CHECK | NO | NO | YES |
+ regression | public | itest7_a_not_null | regression | public | itest7a | CHECK | NO | NO | YES |
+ regression | public | itest7c_a_not_null | regression | public | itest7c | CHECK | NO | NO | YES |
+ regression | public | itest7d_a_not_null | regression | public | itest7d | CHECK | NO | NO | YES |
+ regression | public | itest7d_a_not_null | regression | public | itest7e | CHECK | NO | NO | YES |
+ regression | public | itest9_a_not_null | regression | public | itest9 | CHECK | NO | NO | YES |
+ regression | public | mlparted1_a_not_null | regression | public | mlparted1 | CHECK | NO | NO | YES |
+ regression | public | mlparted1_b_not_null | regression | public | mlparted1 | CHECK | NO | NO | YES |
+ regression | public | mlparted11_a_not_null | regression | public | mlparted11 | CHECK | NO | NO | YES |
+ regression | public | mlparted1_b_not_null | regression | public | mlparted11 | CHECK | NO | NO | YES |
+ regression | public | mlparted1_a_not_null | regression | public | mlparted12 | CHECK | NO | NO | YES |
+ regression | public | mlparted1_b_not_null | regression | public | mlparted12 | CHECK | NO | NO | YES |
+ regression | public | mlparted2_a_not_null | regression | public | mlparted2 | CHECK | NO | NO | YES |
+ regression | public | mlparted2_b_not_null | regression | public | mlparted2 | CHECK | NO | NO | YES |
+ regression | public | mlparted4_a_not_null | regression | public | mlparted4 | CHECK | NO | NO | YES |
+ regression | public | mvtest_t_amt_not_null | regression | public | mvtest_t | CHECK | NO | NO | YES |
+ regression | public | mvtest_t_id_not_null | regression | public | mvtest_t | CHECK | NO | NO | YES |
+ regression | public | mvtest_t_pkey | regression | public | mvtest_t | PRIMARY KEY | NO | NO | YES |
+ regression | public | mvtest_t_type_not_null | regression | public | mvtest_t | CHECK | NO | NO | YES |
+ regression | public | notnull_tbl2_pkey | regression | public | notnull_tbl2 | PRIMARY KEY | NO | NO | YES |
+ regression | public | notnull_tbl3_a_check | regression | public | notnull_tbl3 | CHECK | NO | NO | YES |
+ regression | public | nv_child_2009_d_check | regression | public | nv_child_2009 | CHECK | NO | NO | YES |
+ regression | public | nv_parent_d_check | regression | public | nv_child_2009 | CHECK | NO | NO | YES |
+ regression | public | nv_child_2010_d_check | regression | public | nv_child_2010 | CHECK | NO | NO | YES |
+ regression | public | nv_parent_d_check | regression | public | nv_child_2010 | CHECK | NO | NO | YES |
+ regression | public | nv_child_2011_d_check | regression | public | nv_child_2011 | CHECK | NO | NO | YES |
+ regression | public | nv_parent_d_check | regression | public | nv_child_2011 | CHECK | NO | NO | YES |
+ regression | public | nv_parent_check | regression | public | nv_parent | CHECK | NO | NO | YES |
+ regression | public | nv_parent_d_check | regression | public | nv_parent | CHECK | NO | NO | YES |
+ regression | public | part1_self_fk_id_not_null | regression | public | part1_self_fk | CHECK | NO | NO | YES |
+ regression | public | part1_self_fk_pkey | regression | public | part1_self_fk | PRIMARY KEY | NO | NO | YES |
+ regression | public | parted_self_fk_id_abc_fkey | regression | public | part1_self_fk | FOREIGN KEY | NO | NO | YES |
+ regression | public | part2_self_fk_pkey | regression | public | part2_self_fk | PRIMARY KEY | NO | NO | YES |
+ regression | public | parted_self_fk_id_abc_fkey | regression | public | part2_self_fk | FOREIGN KEY | NO | NO | YES |
+ regression | public | parted_self_fk_id_not_null | regression | public | part2_self_fk | CHECK | NO | NO | YES |
+ regression | public | part32_self_fk_pkey | regression | public | part32_self_fk | PRIMARY KEY | NO | NO | YES |
+ regression | public | part3_self_fk_id_not_null | regression | public | part32_self_fk | CHECK | NO | NO | YES |
+ regression | public | parted_self_fk_id_abc_fkey | regression | public | part32_self_fk | FOREIGN KEY | NO | NO | YES |
+ regression | public | part33_self_fk_id_not_null | regression | public | part33_self_fk | CHECK | NO | NO | YES |
+ regression | public | part33_self_fk_pkey | regression | public | part33_self_fk | PRIMARY KEY | NO | NO | YES |
+ regression | public | parted_self_fk_id_abc_fkey | regression | public | part33_self_fk | FOREIGN KEY | NO | NO | YES |
+ regression | public | part3_self_fk_id_not_null | regression | public | part3_self_fk | CHECK | NO | NO | YES |
+ regression | public | part3_self_fk_pkey | regression | public | part3_self_fk | PRIMARY KEY | NO | NO | YES |
+ regression | public | parted_self_fk_id_abc_fkey | regression | public | part3_self_fk | FOREIGN KEY | NO | NO | YES |
+ regression | public | check_b | regression | public | part_7_a_null | CHECK | NO | NO | YES |
+ regression | public | part_rp_a_check | regression | public | part_rp | CHECK | NO | NO | YES |
+ regression | public | part_rp100_a_check | regression | public | part_rp100 | CHECK | NO | NO | YES |
+ regression | public | parted_self_fk_id_abc_fkey | regression | public | parted_self_fk | FOREIGN KEY | NO | NO | YES |
+ regression | public | parted_self_fk_id_not_null | regression | public | parted_self_fk | CHECK | NO | NO | YES |
+ regression | public | parted_self_fk_pkey | regression | public | parted_self_fk | PRIMARY KEY | NO | NO | YES |
+ regression | public | part1_a_check | regression | public | partr_def2 | CHECK | NO | NO | YES |
+ regression | public | part1_a_not_null | regression | public | partr_def2 | CHECK | NO | NO | YES |
+ regression | public | part1_b_check | regression | public | partr_def2 | CHECK | NO | NO | YES |
+ regression | public | part1_b_not_null | regression | public | partr_def2 | CHECK | NO | NO | YES |
+ regression | public | persons2_name_key | regression | public | persons2 | UNIQUE | NO | NO | YES | YES
+ regression | public | persons2_pkey | regression | public | persons2 | PRIMARY KEY | NO | NO | YES |
+ regression | public | persons3_name_not_null | regression | public | persons3 | CHECK | NO | NO | YES |
+ regression | public | persons3_pkey | regression | public | persons3 | PRIMARY KEY | NO | NO | YES |
+ regression | public | pp1_pkey | regression | public | pp1 | PRIMARY KEY | NO | NO | YES |
+ regression | public | reservations_room_id_not_null | regression | public | reservations | CHECK | NO | NO | YES |
+ regression | public | rule_and_refint_t1_pkey | regression | public | rule_and_refint_t1 | PRIMARY KEY | NO | NO | YES |
+ regression | public | rule_and_refint_t2_pkey | regression | public | rule_and_refint_t2 | PRIMARY KEY | NO | NO | YES |
+ regression | public | rule_and_refint_t3_id3a_id3b_fkey | regression | public | rule_and_refint_t3 | FOREIGN KEY | NO | NO | YES |
+ regression | public | rule_and_refint_t3_id3a_id3c_fkey | regression | public | rule_and_refint_t3 | FOREIGN KEY | NO | NO | YES |
+ regression | public | rule_and_refint_t3_pkey | regression | public | rule_and_refint_t3 | PRIMARY KEY | NO | NO | YES |
+ regression | public | rules_log_id_not_null | regression | public | rules_log | CHECK | NO | NO | YES |
+ regression | public | skip_wal_skip_rewrite_index_pkey | regression | public | skip_wal_skip_rewrite_index | PRIMARY KEY | NO | NO | YES |
+ regression | public | spgist_box_tbl_id_not_null | regression | public | spgist_box_tbl | CHECK | NO | NO | YES |
+ regression | public | spgist_unlogged_tbl_id_not_null | regression | public | spgist_unlogged_tbl | CHECK | NO | NO | YES |
+ regression | public | tbl_include_box_idx_unique | regression | public | tbl_include_box | PRIMARY KEY | NO | NO | YES |
+ regression | public | tbl_include_pk_pkey | regression | public | tbl_include_pk | PRIMARY KEY | NO | NO | YES |
+ regression | public | tbl_include_unique1_c1_c2_c3_c4_key | regression | public | tbl_include_unique1 | UNIQUE | NO | NO | YES | YES
+ regression | public | tbl_include_unique1_idx_unique | regression | public | tbl_include_unique1 | UNIQUE | NO | NO | YES | YES
+ regression | public | bmerged | regression | public | test_inh_check | CHECK | NO | NO | YES |
+ regression | public | bnoinherit | regression | public | test_inh_check | CHECK | NO | NO | YES |
+ regression | public | test_inh_check_a_check | regression | public | test_inh_check | CHECK | NO | NO | YES |
+ regression | public | blocal | regression | public | test_inh_check_child | CHECK | NO | NO | YES |
+ regression | public | bmerged | regression | public | test_inh_check_child | CHECK | NO | NO | YES |
+ regression | public | test_inh_check_a_check | regression | public | test_inh_check_child | CHECK | NO | NO | YES |
+ regression | public | transition_table_base_pkey | regression | public | transition_table_base | PRIMARY KEY | NO | NO | YES |
+ regression | public | transition_table_level1_level1_no_not_null | regression | public | transition_table_level1 | CHECK | NO | NO | YES |
+ regression | public | transition_table_level1_pkey | regression | public | transition_table_level1 | PRIMARY KEY | NO | NO | YES |
+ regression | public | transition_table_level2_level2_no_not_null | regression | public | transition_table_level2 | CHECK | NO | NO | YES |
+ regression | public | transition_table_level2_parent_no_not_null | regression | public | transition_table_level2 | CHECK | NO | NO | YES |
+ regression | public | transition_table_level2_pkey | regression | public | transition_table_level2 | PRIMARY KEY | NO | NO | YES |
+ regression | public | transition_table_status_level_not_null | regression | public | transition_table_status | CHECK | NO | NO | YES |
+ regression | public | transition_table_status_node_no_not_null | regression | public | transition_table_status | CHECK | NO | NO | YES |
+ regression | public | transition_table_status_pkey | regression | public | transition_table_status | PRIMARY KEY | NO | NO | YES |
+ regression | public | trigger_parted_pkey | regression | public | trigger_parted | PRIMARY KEY | NO | NO | YES |
+ regression | public | trigger_parted_p1_pkey | regression | public | trigger_parted_p1 | PRIMARY KEY | NO | NO | YES |
+ regression | public | trigger_parted_p1_1_pkey | regression | public | trigger_parted_p1_1 | PRIMARY KEY | NO | NO | YES |
+ regression | public | trigger_parted_p2_pkey | regression | public | trigger_parted_p2 | PRIMARY KEY | NO | NO | YES |
+ regression | public | trigger_parted_p2_2_pkey | regression | public | trigger_parted_p2_2 | PRIMARY KEY | NO | NO | YES |
+ regression | public | truncate_b_id_not_null | regression | public | truncate_b | CHECK | NO | NO | YES |
+ regression | public | tt0_x_not_null | regression | public | tt0 | CHECK | NO | NO | YES |
+ regression | public | tt0_x_not_null | regression | public | tt6 | CHECK | NO | NO | YES |
+ regression | public | utf8_verification_inputs_pkey | regression | public | utf8_verification_inputs | PRIMARY KEY | NO | NO | YES |
+ regression | public | view_base_table_pkey | regression | public | view_base_table | PRIMARY KEY | NO | NO | YES |
+(211 rows)
+
+--
+-- Domain constraints
+--
+SELECT * FROM information_schema.column_domain_usage
+ WHERE domain_schema = 'public' AND table_schema = 'public'
+ ORDER BY domain_name;
+ domain_catalog | domain_schema | domain_name | table_catalog | table_schema | table_name | column_name
+----------------+---------------+--------------+---------------+--------------+-------------------+-------------
+ regression | public | con | regression | public | domcontest | col1
+ regression | public | dom | regression | public | domview | col1
+ regression | public | gtestdomain1 | regression | public | gtest24 | b
+ regression | public | spgist_text | regression | public | spgist_domain_tbl | f1
+ regression | public | things | regression | public | thethings | stuff
+(5 rows)
+
+SELECT * FROM information_schema.domain_constraints
+ WHERE domain_schema = 'public'
+ ORDER BY constraint_name;
+ constraint_catalog | constraint_schema | constraint_name | domain_catalog | domain_schema | domain_name | is_deferrable | initially_deferred
+--------------------+-------------------+--------------------------+----------------+---------------+--------------------+---------------+--------------------
+ regression | public | con_check | regression | public | con | NO | NO
+ regression | public | gtestdomain1_check | regression | public | gtestdomain1 | NO | NO
+ regression | public | meow | regression | public | things | NO | NO
+ regression | public | orderedpair_check | regression | public | orderedpair | NO | NO
+ regression | public | plpgsql_arr_domain_check | regression | public | plpgsql_arr_domain | NO | NO
+ regression | public | plpgsql_domain_check | regression | public | plpgsql_domain | NO | NO
+ regression | public | pos_int_check | regression | public | pos_int | NO | NO
+ regression | public | sorted | regression | public | orderedarray | NO | NO
+ regression | public | str_domain2_check | regression | public | str_domain2 | NO | NO
+(9 rows)
+
+SELECT * FROM information_schema.domains
+ WHERE domain_schema = 'public'
+ ORDER BY domain_name;
+ domain_catalog | domain_schema | domain_name | data_type | character_maximum_length | character_octet_length | character_set_catalog | character_set_schema | character_set_name | collation_catalog | collation_schema | collation_name | numeric_precision | numeric_precision_radix | numeric_scale | datetime_precision | interval_type | interval_precision | domain_default | udt_catalog | udt_schema | udt_name | scope_catalog | scope_schema | scope_name | maximum_cardinality | dtd_identifier
+----------------+---------------+--------------------+-------------------+--------------------------+------------------------+-----------------------+----------------------+--------------------+-------------------+------------------+----------------+-------------------+-------------------------+---------------+--------------------+---------------+--------------------+----------------+-------------+------------+----------+---------------+--------------+------------+---------------------+----------------
+ regression | public | con | integer | | | | | | | | | 32 | 2 | 0 | | | | | regression | pg_catalog | int4 | | | | | 1
+ regression | public | dom | integer | | | | | | | | | 32 | 2 | 0 | | | | | regression | pg_catalog | int4 | | | | | 1
+ regression | public | gtestdomain1 | integer | | | | | | | | | 32 | 2 | 0 | | | | | regression | pg_catalog | int4 | | | | | 1
+ regression | public | mynums | numeric[] | | | | | | | | | | | | | | | | regression | pg_catalog | _numeric | | | | | 1
+ regression | public | mynums2 | USER-DEFINED | | | | | | | | | | | | | | | | regression | public | mynums | | | | | 1
+ regression | public | orderedarray | integer[] | | | | | | | | | | | | | | | | regression | pg_catalog | _int4 | | | | | 1
+ regression | public | orderedpair | integer[] | | | | | | | | | | | | | | | | regression | pg_catalog | _int4 | | | | | 1
+ regression | public | plpgsql_arr_domain | integer[] | | | | | | | | | | | | | | | | regression | pg_catalog | _int4 | | | | | 1
+ regression | public | plpgsql_domain | integer | | | | | | | | | 32 | 2 | 0 | | | | | regression | pg_catalog | int4 | | | | | 1
+ regression | public | pos_int | integer | | | | | | | | | 32 | 2 | 0 | | | | | regression | pg_catalog | int4 | | | | | 1
+ regression | public | spgist_text | character varying | | 1073741824 | | | | | | | | | | | | | | regression | pg_catalog | varchar | | | | | 1
+ regression | public | str_domain | text | | 1073741824 | | | | | | | | | | | | | | regression | pg_catalog | text | | | | | 1
+ regression | public | str_domain2 | text | | 1073741824 | | | | | | | | | | | | | 'foo'::text | regression | pg_catalog | text | | | | | 1
+ regression | public | testboolxmldomain | boolean | | | | | | | | | | | | | | | | regression | pg_catalog | bool | | | | | 1
+ regression | public | testdatexmldomain | date | | | | | | | | | | | | 0 | | | | regression | pg_catalog | date | | | | | 1
+ regression | public | testxmldomain | character varying | | 1073741824 | | | | | | | | | | | | | | regression | pg_catalog | varchar | | | | | 1
+ regression | public | things | integer | | | | | | | | | 32 | 2 | 0 | | | | | regression | pg_catalog | int4 | | | | | 1
+(17 rows)
+
+SELECT * FROM information_schema.check_constraints
+ WHERE (constraint_schema, constraint_name)
+ IN (SELECT constraint_schema, constraint_name
+ FROM information_schema.domain_constraints
+ WHERE domain_schema = 'public')
+ ORDER BY constraint_name;
+ constraint_catalog | constraint_schema | constraint_name | check_clause
+--------------------+-------------------+--------------------------+-----------------------------------
+ regression | public | con_check | ((VALUE > 0))
+ regression | public | gtestdomain1_check | ((VALUE < 10))
+ regression | public | meow | ((VALUE < 11))
+ regression | public | orderedpair_check | (((VALUE)[1] < (VALUE)[2]))
+ regression | public | plpgsql_arr_domain_check | (plpgsql_arr_domain_check(VALUE))
+ regression | public | plpgsql_domain_check | (plpgsql_domain_check(VALUE))
+ regression | public | pos_int_check | ((VALUE > 0))
+ regression | public | sorted | (((VALUE)[1] < (VALUE)[2]))
+ regression | public | str_domain2_check | ((VALUE <> 'foo'::text))
+(9 rows)
+
diff --git a/src/test/regress/parallel_schedule b/src/test/regress/parallel_schedule
index 4df9d8503b..22e9896f18 100644
--- a/src/test/regress/parallel_schedule
+++ b/src/test/regress/parallel_schedule
@@ -130,5 +130,6 @@ test: event_trigger oidjoins
test: fast_default
# run tablespace test at the end because it drops the tablespace created during
-# setup that other tests may use.
-test: tablespace
+# setup that other tests may use. This is also a good place to verify
+# our information_schema definitions.
+test: tablespace information_schema
diff --git a/src/test/regress/sql/information_schema.sql b/src/test/regress/sql/information_schema.sql
new file mode 100644
index 0000000000..a0a8b1ed58
--- /dev/null
+++ b/src/test/regress/sql/information_schema.sql
@@ -0,0 +1,41 @@
+-- We test the information schema last, so that we examine
+-- database state at the end of the regression test run.
+
+--
+-- Table constraints
+--
+
+SELECT * FROM information_schema.check_constraints
+ WHERE constraint_schema = 'public'
+ ORDER BY constraint_name;
+
+SELECT * FROM information_schema.constraint_column_usage
+ WHERE constraint_schema = 'public'
+ ORDER BY table_name, column_name, constraint_name;
+
+SELECT * FROM information_schema.table_constraints
+ WHERE constraint_schema = 'public'
+ ORDER BY table_name, constraint_name;
+
+--
+-- Domain constraints
+--
+
+SELECT * FROM information_schema.column_domain_usage
+ WHERE domain_schema = 'public' AND table_schema = 'public'
+ ORDER BY domain_name;
+
+SELECT * FROM information_schema.domain_constraints
+ WHERE domain_schema = 'public'
+ ORDER BY constraint_name;
+
+SELECT * FROM information_schema.domains
+ WHERE domain_schema = 'public'
+ ORDER BY domain_name;
+
+SELECT * FROM information_schema.check_constraints
+ WHERE (constraint_schema, constraint_name)
+ IN (SELECT constraint_schema, constraint_name
+ FROM information_schema.domain_constraints
+ WHERE domain_schema = 'public')
+ ORDER BY constraint_name;
--
2.39.2
