summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorAlvaro Herrera2023-08-25 12:06:13 +0000
committerAlvaro Herrera2023-08-25 12:06:13 +0000
commit98976d0ce0a3947427182394041f6dd0e33438b4 (patch)
treeafc90b78b2bcc5bce2401d690f26a193da2d68af /src
parentb0e96f311985bceba79825214f8e43f65afa653a (diff)
Rename test table to avoid cs_CZ locale problem
Per buildfarm member Hippopotamus
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/inherit.out38
-rw-r--r--src/test/regress/sql/inherit.sql10
2 files changed, 24 insertions, 24 deletions
diff --git a/src/test/regress/expected/inherit.out b/src/test/regress/expected/inherit.out
index b084cb6a6f3..6daca12340c 100644
--- a/src/test/regress/expected/inherit.out
+++ b/src/test/regress/expected/inherit.out
@@ -2251,7 +2251,7 @@ select conrelid::regclass, conname, contype, coninhcount, conislocal
-- test deinherit procedure
--
-- deinherit inh_child1
-create table inh_grandchld () inherits (inh_child1);
+create table inh_child3 () inherits (inh_child1);
alter table inh_child1 no inherit inh_parent;
\d+ inh_parent
Table "public.inh_parent"
@@ -2269,7 +2269,7 @@ Not-null constraints:
Not-null constraints:
"inh_child1_f1_not_null" NOT NULL "f1"
Child tables: inh_child2,
- inh_grandchld
+ inh_child3
\d+ inh_child2
Table "public.inh_child2"
@@ -2282,17 +2282,17 @@ Inherits: inh_child1
select conrelid::regclass, conname, contype, coninhcount, conislocal
from pg_constraint where contype = 'n' and
- conrelid::regclass::text in ('inh_parent', 'inh_child1', 'inh_child2', 'inh_grandchld')
+ conrelid::regclass::text in ('inh_parent', 'inh_child1', 'inh_child2', 'inh_child3')
order by 2, 1;
- conrelid | conname | contype | coninhcount | conislocal
----------------+------------------------+---------+-------------+------------
- inh_child1 | inh_child1_f1_not_null | n | 0 | t
- inh_grandchld | inh_child1_f1_not_null | n | 1 | f
- inh_child2 | inh_child2_f1_not_null | n | 1 | t
- inh_parent | inh_parent_f1_not_null | n | 0 | t
+ conrelid | conname | contype | coninhcount | conislocal
+------------+------------------------+---------+-------------+------------
+ inh_child1 | inh_child1_f1_not_null | n | 0 | t
+ inh_child3 | inh_child1_f1_not_null | n | 1 | f
+ inh_child2 | inh_child2_f1_not_null | n | 1 | t
+ inh_parent | inh_parent_f1_not_null | n | 0 | t
(4 rows)
-drop table inh_parent, inh_child1, inh_child2, inh_grandchld;
+drop table inh_parent, inh_child1, inh_child2, inh_child3;
-- a PK in parent must have a not-null in child that it can mark inherited
create table inh_parent (a int primary key);
create table inh_child (a int primary key);
@@ -2307,26 +2307,26 @@ drop table inh_parent, inh_child;
create table inh_parent(f1 int not null);
create table inh_child1() inherits(inh_parent);
create table inh_child2() inherits(inh_parent);
-create table inh_grandchld() inherits(inh_child1, inh_child2);
+create table inh_child3() inherits(inh_child1, inh_child2);
NOTICE: merging multiple inherited definitions of column "f1"
-- show constraint info
select conrelid::regclass, conname, contype, coninhcount, conislocal
from pg_constraint where contype = 'n' and
- conrelid in ('inh_parent'::regclass, 'inh_child1'::regclass, 'inh_child2'::regclass, 'inh_grandchld'::regclass)
+ conrelid in ('inh_parent'::regclass, 'inh_child1'::regclass, 'inh_child2'::regclass, 'inh_child3'::regclass)
order by 2, conrelid::regclass::text;
- conrelid | conname | contype | coninhcount | conislocal
----------------+------------------------+---------+-------------+------------
- inh_child1 | inh_parent_f1_not_null | n | 1 | f
- inh_child2 | inh_parent_f1_not_null | n | 1 | f
- inh_grandchld | inh_parent_f1_not_null | n | 2 | f
- inh_parent | inh_parent_f1_not_null | n | 0 | t
+ conrelid | conname | contype | coninhcount | conislocal
+------------+------------------------+---------+-------------+------------
+ inh_child1 | inh_parent_f1_not_null | n | 1 | f
+ inh_child2 | inh_parent_f1_not_null | n | 1 | f
+ inh_child3 | inh_parent_f1_not_null | n | 2 | f
+ inh_parent | inh_parent_f1_not_null | n | 0 | t
(4 rows)
drop table inh_parent cascade;
NOTICE: drop cascades to 3 other objects
DETAIL: drop cascades to table inh_child1
drop cascades to table inh_child2
-drop cascades to table inh_grandchld
+drop cascades to table inh_child3
-- test child table with inherited columns and
-- with explicitly specified not null constraints
create table inh_parent_1(f1 int);
diff --git a/src/test/regress/sql/inherit.sql b/src/test/regress/sql/inherit.sql
index 4f269af166f..d8fae92a533 100644
--- a/src/test/regress/sql/inherit.sql
+++ b/src/test/regress/sql/inherit.sql
@@ -823,16 +823,16 @@ select conrelid::regclass, conname, contype, coninhcount, conislocal
--
-- deinherit inh_child1
-create table inh_grandchld () inherits (inh_child1);
+create table inh_child3 () inherits (inh_child1);
alter table inh_child1 no inherit inh_parent;
\d+ inh_parent
\d+ inh_child1
\d+ inh_child2
select conrelid::regclass, conname, contype, coninhcount, conislocal
from pg_constraint where contype = 'n' and
- conrelid::regclass::text in ('inh_parent', 'inh_child1', 'inh_child2', 'inh_grandchld')
+ conrelid::regclass::text in ('inh_parent', 'inh_child1', 'inh_child2', 'inh_child3')
order by 2, 1;
-drop table inh_parent, inh_child1, inh_child2, inh_grandchld;
+drop table inh_parent, inh_child1, inh_child2, inh_child3;
-- a PK in parent must have a not-null in child that it can mark inherited
create table inh_parent (a int primary key);
@@ -848,12 +848,12 @@ drop table inh_parent, inh_child;
create table inh_parent(f1 int not null);
create table inh_child1() inherits(inh_parent);
create table inh_child2() inherits(inh_parent);
-create table inh_grandchld() inherits(inh_child1, inh_child2);
+create table inh_child3() inherits(inh_child1, inh_child2);
-- show constraint info
select conrelid::regclass, conname, contype, coninhcount, conislocal
from pg_constraint where contype = 'n' and
- conrelid in ('inh_parent'::regclass, 'inh_child1'::regclass, 'inh_child2'::regclass, 'inh_grandchld'::regclass)
+ conrelid in ('inh_parent'::regclass, 'inh_child1'::regclass, 'inh_child2'::regclass, 'inh_child3'::regclass)
order by 2, conrelid::regclass::text;
drop table inh_parent cascade;