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

Commitc360477

Browse files
committed
Follow the rule that regression-test-created roles are named "regress_xxx".
Commit1c5d927 had not gotten the word about this. (For previouscontext, see18555b1.)
1 parentd993e0f commitc360477

File tree

2 files changed

+65
-65
lines changed

2 files changed

+65
-65
lines changed

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

Lines changed: 61 additions & 61 deletions
Original file line numberDiff line numberDiff line change
@@ -4599,9 +4599,9 @@ last error message: division by zero
45994599
last error code: 22012
46004600
\unset FETCH_COUNT
46014601
create schema testpart;
4602-
create roletestrole_partitioning;
4603-
alter schema testpart owner totestrole_partitioning;
4604-
set role totestrole_partitioning;
4602+
create roleregress_partitioning_role;
4603+
alter schema testpart owner toregress_partitioning_role;
4604+
set role toregress_partitioning_role;
46054605
-- run test inside own schema and hide other partitions
46064606
set search_path to testpart;
46074607
create table testtable_apple(logdate date);
@@ -4614,25 +4614,25 @@ create index testpart_apple_index on testpart_apple(logdate);
46144614
create index testpart_orange_index on testpart_orange(logdate);
46154615
-- only partition related object should be displayed
46164616
\dP test*apple*
4617-
List of partitioned relations
4618-
Schema | Name | Owner | Type | Parent name | Table
4619-
----------+----------------------+-----------------------+-------------------+-------------+----------------
4620-
testpart | testpart_apple |testrole_partitioning | partitioned table | |
4621-
testpart | testpart_apple_index |testrole_partitioning | partitioned index | | testpart_apple
4617+
List of partitioned relations
4618+
Schema | Name |Owner | Type | Parent name | Table
4619+
----------+----------------------+---------------------------+-------------------+-------------+----------------
4620+
testpart | testpart_apple |regress_partitioning_role | partitioned table | |
4621+
testpart | testpart_apple_index |regress_partitioning_role | partitioned index | | testpart_apple
46224622
(2 rows)
46234623

46244624
\dPt test*apple*
4625-
List of partitioned tables
4626-
Schema | Name | Owner | Parent name
4627-
----------+----------------+-----------------------+-------------
4628-
testpart | testpart_apple |testrole_partitioning |
4625+
List of partitioned tables
4626+
Schema | Name |Owner | Parent name
4627+
----------+----------------+---------------------------+-------------
4628+
testpart | testpart_apple |regress_partitioning_role |
46294629
(1 row)
46304630

46314631
\dPi test*apple*
4632-
List of partitioned indexes
4633-
Schema | Name | Owner | Parent name | Table
4634-
----------+----------------------+-----------------------+-------------+----------------
4635-
testpart | testpart_apple_index |testrole_partitioning | | testpart_apple
4632+
List of partitioned indexes
4633+
Schema | Name |Owner | Parent name | Table
4634+
----------+----------------------+---------------------------+-------------+----------------
4635+
testpart | testpart_apple_index |regress_partitioning_role | | testpart_apple
46364636
(1 row)
46374637

46384638
drop table testtable_apple;
@@ -4657,75 +4657,75 @@ create table child_35_40 partition of child_30_40
46574657
for values from (35) to (40);
46584658
insert into parent_tab values (generate_series(30,39));
46594659
\dPt
4660-
List of partitioned tables
4661-
Schema | Name | Owner
4662-
----------+------------+-----------------------
4663-
testpart | parent_tab |testrole_partitioning
4660+
List of partitioned tables
4661+
Schema | Name |Owner
4662+
----------+------------+---------------------------
4663+
testpart | parent_tab |regress_partitioning_role
46644664
(1 row)
46654665

46664666
\dPi
4667-
List of partitioned indexes
4668-
Schema | Name | Owner | Table
4669-
----------+--------------+-----------------------+------------
4670-
testpart | parent_index |testrole_partitioning | parent_tab
4667+
List of partitioned indexes
4668+
Schema | Name |Owner | Table
4669+
----------+--------------+---------------------------+------------
4670+
testpart | parent_index |regress_partitioning_role | parent_tab
46714671
(1 row)
46724672

46734673
\dP testpart.*
4674-
List of partitioned relations
4675-
Schema | Name | Owner | Type | Parent name | Table
4676-
----------+--------------------+-----------------------+-------------------+--------------+-------------
4677-
testpart | parent_tab |testrole_partitioning | partitioned table | |
4678-
testpart | child_30_40 |testrole_partitioning | partitioned table | parent_tab |
4679-
testpart | parent_index |testrole_partitioning | partitioned index | | parent_tab
4680-
testpart | child_30_40_id_idx |testrole_partitioning | partitioned index | parent_index | child_30_40
4674+
List of partitioned relations
4675+
Schema | Name |Owner | Type | Parent name | Table
4676+
----------+--------------------+---------------------------+-------------------+--------------+-------------
4677+
testpart | parent_tab |regress_partitioning_role | partitioned table | |
4678+
testpart | child_30_40 |regress_partitioning_role | partitioned table | parent_tab |
4679+
testpart | parent_index |regress_partitioning_role | partitioned index | | parent_tab
4680+
testpart | child_30_40_id_idx |regress_partitioning_role | partitioned index | parent_index | child_30_40
46814681
(4 rows)
46824682

46834683
\dP
4684-
List of partitioned relations
4685-
Schema | Name | Owner | Type | Table
4686-
----------+--------------+-----------------------+-------------------+------------
4687-
testpart | parent_tab |testrole_partitioning | partitioned table |
4688-
testpart | parent_index |testrole_partitioning | partitioned index | parent_tab
4684+
List of partitioned relations
4685+
Schema | Name |Owner | Type | Table
4686+
----------+--------------+---------------------------+-------------------+------------
4687+
testpart | parent_tab |regress_partitioning_role | partitioned table |
4688+
testpart | parent_index |regress_partitioning_role | partitioned index | parent_tab
46894689
(2 rows)
46904690

46914691
\dPtn
4692-
List of partitioned tables
4693-
Schema | Name | Owner | Parent name
4694-
----------+-------------+-----------------------+-------------
4695-
testpart | parent_tab |testrole_partitioning |
4696-
testpart | child_30_40 |testrole_partitioning | parent_tab
4692+
List of partitioned tables
4693+
Schema | Name |Owner | Parent name
4694+
----------+-------------+---------------------------+-------------
4695+
testpart | parent_tab |regress_partitioning_role |
4696+
testpart | child_30_40 |regress_partitioning_role | parent_tab
46974697
(2 rows)
46984698

46994699
\dPin
4700-
List of partitioned indexes
4701-
Schema | Name | Owner | Parent name | Table
4702-
----------+--------------------+-----------------------+--------------+-------------
4703-
testpart | parent_index |testrole_partitioning | | parent_tab
4704-
testpart | child_30_40_id_idx |testrole_partitioning | parent_index | child_30_40
4700+
List of partitioned indexes
4701+
Schema | Name |Owner | Parent name | Table
4702+
----------+--------------------+---------------------------+--------------+-------------
4703+
testpart | parent_index |regress_partitioning_role | | parent_tab
4704+
testpart | child_30_40_id_idx |regress_partitioning_role | parent_index | child_30_40
47054705
(2 rows)
47064706

47074707
\dPn
4708-
List of partitioned relations
4709-
Schema | Name | Owner | Type | Parent name | Table
4710-
----------+--------------------+-----------------------+-------------------+--------------+-------------
4711-
testpart | parent_tab |testrole_partitioning | partitioned table | |
4712-
testpart | child_30_40 |testrole_partitioning | partitioned table | parent_tab |
4713-
testpart | parent_index |testrole_partitioning | partitioned index | | parent_tab
4714-
testpart | child_30_40_id_idx |testrole_partitioning | partitioned index | parent_index | child_30_40
4708+
List of partitioned relations
4709+
Schema | Name |Owner | Type | Parent name | Table
4710+
----------+--------------------+---------------------------+-------------------+--------------+-------------
4711+
testpart | parent_tab |regress_partitioning_role | partitioned table | |
4712+
testpart | child_30_40 |regress_partitioning_role | partitioned table | parent_tab |
4713+
testpart | parent_index |regress_partitioning_role | partitioned index | | parent_tab
4714+
testpart | child_30_40_id_idx |regress_partitioning_role | partitioned index | parent_index | child_30_40
47154715
(4 rows)
47164716

47174717
\dPn testpart.*
4718-
List of partitioned relations
4719-
Schema | Name | Owner | Type | Parent name | Table
4720-
----------+--------------------+-----------------------+-------------------+--------------+-------------
4721-
testpart | parent_tab |testrole_partitioning | partitioned table | |
4722-
testpart | child_30_40 |testrole_partitioning | partitioned table | parent_tab |
4723-
testpart | parent_index |testrole_partitioning | partitioned index | | parent_tab
4724-
testpart | child_30_40_id_idx |testrole_partitioning | partitioned index | parent_index | child_30_40
4718+
List of partitioned relations
4719+
Schema | Name |Owner | Type | Parent name | Table
4720+
----------+--------------------+---------------------------+-------------------+--------------+-------------
4721+
testpart | parent_tab |regress_partitioning_role | partitioned table | |
4722+
testpart | child_30_40 |regress_partitioning_role | partitioned table | parent_tab |
4723+
testpart | parent_index |regress_partitioning_role | partitioned index | | parent_tab
4724+
testpart | child_30_40_id_idx |regress_partitioning_role | partitioned index | parent_index | child_30_40
47254725
(4 rows)
47264726

47274727
drop table parent_tab cascade;
47284728
drop schema testpart;
47294729
set search_path to default;
47304730
set role to default;
4731-
drop roletestrole_partitioning;
4731+
drop roleregress_partitioning_role;

‎src/test/regress/sql/psql.sql

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1048,11 +1048,11 @@ select 1/(15-unique2) from tenk1 order by unique2 limit 19;
10481048
\unset FETCH_COUNT
10491049

10501050
createschematestpart;
1051-
create roletestrole_partitioning;
1051+
create roleregress_partitioning_role;
10521052

1053-
alterschema testpart owner totestrole_partitioning;
1053+
alterschema testpart owner toregress_partitioning_role;
10541054

1055-
set role totestrole_partitioning;
1055+
set role toregress_partitioning_role;
10561056

10571057
-- run test inside own schema and hide other partitions
10581058
set search_path to testpart;
@@ -1114,4 +1114,4 @@ drop schema testpart;
11141114
set search_path to default;
11151115

11161116
set role to default;
1117-
drop roletestrole_partitioning;
1117+
drop roleregress_partitioning_role;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp