diff options
| author | Fujii Masao <fujii@postgresql.org> | 2021-01-26 17:16:52 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2021-01-26 17:16:52 +0900 |
| commit | 0c3fc09fe359a6dc46f1870ceccf60ec60396bc9 (patch) | |
| tree | 2aca3c3db1974a246c57f242c7adeb1a96f682fc /contrib/postgres_fdw/sql/postgres_fdw.sql | |
| parent | 6adc5376dca4ef8b7d591c0ee7338cb9ff660216 (diff) | |
| download | postgresql-0c3fc09fe359a6dc46f1870ceccf60ec60396bc9.tar.gz postgresql-0c3fc09fe359a6dc46f1870ceccf60ec60396bc9.zip | |
postgres_fdw: Fix test failure with -DENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS
The roles created by regression test should have names starting with
"regress_", and the test introduced in commit 411ae64997 did not do that.
Per buildfarm member longfin.
Discussion: https://postgr.es/m/73fc5ae4-3c54-1262-4533-f8c547de2e60@oss.nttdata.com
Diffstat (limited to 'contrib/postgres_fdw/sql/postgres_fdw.sql')
| -rw-r--r-- | contrib/postgres_fdw/sql/postgres_fdw.sql | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/contrib/postgres_fdw/sql/postgres_fdw.sql b/contrib/postgres_fdw/sql/postgres_fdw.sql index 62382d1a55f..647192cf6ac 100644 --- a/contrib/postgres_fdw/sql/postgres_fdw.sql +++ b/contrib/postgres_fdw/sql/postgres_fdw.sql @@ -2801,18 +2801,18 @@ SELECT * FROM postgres_fdw_get_connections() ORDER BY 1; -- ============================================================================= -- test case for having multiple cached connections for a foreign server -- ============================================================================= -CREATE ROLE multi_conn_user1 SUPERUSER; -CREATE ROLE multi_conn_user2 SUPERUSER; -CREATE USER MAPPING FOR multi_conn_user1 SERVER loopback; -CREATE USER MAPPING FOR multi_conn_user2 SERVER loopback; +CREATE ROLE regress_multi_conn_user1 SUPERUSER; +CREATE ROLE regress_multi_conn_user2 SUPERUSER; +CREATE USER MAPPING FOR regress_multi_conn_user1 SERVER loopback; +CREATE USER MAPPING FOR regress_multi_conn_user2 SERVER loopback; --- Will cache loopback connection with user mapping for multi_conn_user1 -SET ROLE multi_conn_user1; +-- Will cache loopback connection with user mapping for regress_multi_conn_user1 +SET ROLE regress_multi_conn_user1; SELECT 1 FROM ft1 LIMIT 1; RESET ROLE; --- Will cache loopback connection with user mapping for multi_conn_user2 -SET ROLE multi_conn_user2; +-- Will cache loopback connection with user mapping for regress_multi_conn_user2 +SET ROLE regress_multi_conn_user2; SELECT 1 FROM ft1 LIMIT 1; RESET ROLE; @@ -2827,10 +2827,10 @@ SELECT postgres_fdw_disconnect('loopback'); SELECT * FROM postgres_fdw_get_connections() ORDER BY 1; -- Clean up -DROP USER MAPPING FOR multi_conn_user1 SERVER loopback; -DROP USER MAPPING FOR multi_conn_user2 SERVER loopback; -DROP ROLE multi_conn_user1; -DROP ROLE multi_conn_user2; +DROP USER MAPPING FOR regress_multi_conn_user1 SERVER loopback; +DROP USER MAPPING FOR regress_multi_conn_user2 SERVER loopback; +DROP ROLE regress_multi_conn_user1; +DROP ROLE regress_multi_conn_user2; -- =================================================================== -- batch insert |