Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit5d5f415

Browse files
committed
Expand test a bit
Make pg_constraint output in inherit test show the convalidated columnas well. This shows the interaction between convalidated andconenforced.This is extracted from a larger patch so that this reformatting isn'tdistracting there.Author: Amul Sul <amul.sul@enterprisedb.com>Discussion:https://www.postgresql.org/message-id/flat/CAAJ_b962c5AcYW9KUt_R_ER5qs3fUGbe4az-SP-vuwPS-w-AGA@mail.gmail.com
1 parentb98be8a commit5d5f415

File tree

2 files changed

+34
-34
lines changed

2 files changed

+34
-34
lines changed

‎src/test/regress/expected/inherit.out

Lines changed: 33 additions & 33 deletions
Original file line numberDiff line numberDiff line change
@@ -1353,41 +1353,41 @@ create table p1_fail(f1 int constraint inh_check_constraint6 check (f1 < 10) not
13531353
NOTICE: merging multiple inherited definitions of column "f1"
13541354
NOTICE: merging column "f1" with inherited definition
13551355
ERROR: constraint "inh_check_constraint6" conflicts with NOT ENFORCED constraint on relation "p1_fail"
1356-
select conrelid::regclass::text as relname, conname, conislocal, coninhcount, conenforced
1356+
select conrelid::regclass::text as relname, conname, conislocal, coninhcount, conenforced, convalidated
13571357
from pg_constraint where conname like 'inh\_check\_constraint%'
13581358
order by 1, 2;
1359-
relname | conname | conislocal | coninhcount | conenforced
1360-
---------+-----------------------+------------+-------------+-------------
1361-
p1 | inh_check_constraint1 | t | 0 | t
1362-
p1 | inh_check_constraint2 | t | 0 | t
1363-
p1 | inh_check_constraint3 | t | 0 | f
1364-
p1 | inh_check_constraint4 | t | 0 | f
1365-
p1 | inh_check_constraint5 | t | 0 | f
1366-
p1 | inh_check_constraint6 | t | 0 | f
1367-
p1 | inh_check_constraint8 | t | 0 | t
1368-
p1_c1 | inh_check_constraint1 | t | 1 | t
1369-
p1_c1 | inh_check_constraint2 | t | 1 | t
1370-
p1_c1 | inh_check_constraint3 | t | 1 | f
1371-
p1_c1 | inh_check_constraint4 | t | 1 | f
1372-
p1_c1 | inh_check_constraint5 | t | 1 | t
1373-
p1_c1 | inh_check_constraint6 | t | 1 | t
1374-
p1_c1 | inh_check_constraint7 | t | 0 | f
1375-
p1_c1 | inh_check_constraint8 | f | 1 | t
1376-
p1_c2 | inh_check_constraint1 | f | 1 | t
1377-
p1_c2 | inh_check_constraint2 | f | 1 | t
1378-
p1_c2 | inh_check_constraint3 | f | 1 | f
1379-
p1_c2 | inh_check_constraint4 | t | 1 | t
1380-
p1_c2 | inh_check_constraint5 | f | 1 | f
1381-
p1_c2 | inh_check_constraint6 | f | 1 | f
1382-
p1_c2 | inh_check_constraint8 | f | 1 | t
1383-
p1_c3 | inh_check_constraint1 | f | 2 | t
1384-
p1_c3 | inh_check_constraint2 | f | 2 | t
1385-
p1_c3 | inh_check_constraint3 | f | 2 | f
1386-
p1_c3 | inh_check_constraint4 | f | 2 | f
1387-
p1_c3 | inh_check_constraint5 | f | 2 | t
1388-
p1_c3 | inh_check_constraint6 | f | 2 | t
1389-
p1_c3 | inh_check_constraint7 | f | 1 | f
1390-
p1_c3 | inh_check_constraint8 | f | 2 | t
1359+
relname | conname | conislocal | coninhcount | conenforced| convalidated
1360+
---------+-----------------------+------------+-------------+-------------+--------------
1361+
p1 | inh_check_constraint1 | t | 0 | t | t
1362+
p1 | inh_check_constraint2 | t | 0 | t | t
1363+
p1 | inh_check_constraint3 | t | 0 | f | f
1364+
p1 | inh_check_constraint4 | t | 0 | f | f
1365+
p1 | inh_check_constraint5 | t | 0 | f | f
1366+
p1 | inh_check_constraint6 | t | 0 | f | f
1367+
p1 | inh_check_constraint8 | t | 0 | t | t
1368+
p1_c1 | inh_check_constraint1 | t | 1 | t | t
1369+
p1_c1 | inh_check_constraint2 | t | 1 | t | t
1370+
p1_c1 | inh_check_constraint3 | t | 1 | f | f
1371+
p1_c1 | inh_check_constraint4 | t | 1 | f | f
1372+
p1_c1 | inh_check_constraint5 | t | 1 | t | t
1373+
p1_c1 | inh_check_constraint6 | t | 1 | t | t
1374+
p1_c1 | inh_check_constraint7 | t | 0 | f | f
1375+
p1_c1 | inh_check_constraint8 | f | 1 | t | t
1376+
p1_c2 | inh_check_constraint1 | f | 1 | t | t
1377+
p1_c2 | inh_check_constraint2 | f | 1 | t | t
1378+
p1_c2 | inh_check_constraint3 | f | 1 | f | f
1379+
p1_c2 | inh_check_constraint4 | t | 1 | t | t
1380+
p1_c2 | inh_check_constraint5 | f | 1 | f | f
1381+
p1_c2 | inh_check_constraint6 | f | 1 | f | f
1382+
p1_c2 | inh_check_constraint8 | f | 1 | t | t
1383+
p1_c3 | inh_check_constraint1 | f | 2 | t | t
1384+
p1_c3 | inh_check_constraint2 | f | 2 | t | t
1385+
p1_c3 | inh_check_constraint3 | f | 2 | f | f
1386+
p1_c3 | inh_check_constraint4 | f | 2 | f | f
1387+
p1_c3 | inh_check_constraint5 | f | 2 | t | t
1388+
p1_c3 | inh_check_constraint6 | f | 2 | t | t
1389+
p1_c3 | inh_check_constraint7 | f | 1 | f | f
1390+
p1_c3 | inh_check_constraint8 | f | 2 | t | t
13911391
(30 rows)
13921392

13931393
drop table p1 cascade;

‎src/test/regress/sql/inherit.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -498,7 +498,7 @@ create table p1_c3() inherits(p1, p1_c1);
498498
-- but not allowed if the child constraint is explicitly asked to be NOT ENFORCED
499499
createtablep1_fail(f1intconstraint inh_check_constraint6check (f1<10) not enforced) inherits(p1, p1_c1);
500500

501-
select conrelid::regclass::textas relname, conname, conislocal, coninhcount, conenforced
501+
select conrelid::regclass::textas relname, conname, conislocal, coninhcount, conenforced, convalidated
502502
from pg_constraintwhere connamelike'inh\_check\_constraint%'
503503
order by1,2;
504504

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp