diff options
Diffstat (limited to 'contrib/file_fdw/input/file_fdw.source')
| -rw-r--r-- | contrib/file_fdw/input/file_fdw.source | 54 |
1 files changed, 27 insertions, 27 deletions
diff --git a/contrib/file_fdw/input/file_fdw.source b/contrib/file_fdw/input/file_fdw.source index 35db4af0824..685561fc2a0 100644 --- a/contrib/file_fdw/input/file_fdw.source +++ b/contrib/file_fdw/input/file_fdw.source @@ -3,37 +3,37 @@ -- -- Clean up in case a prior regression run failed -SET client_min_messages TO 'error'; -DROP ROLE IF EXISTS file_fdw_superuser, file_fdw_user, no_priv_user; +SET client_min_messages TO 'warning'; +DROP ROLE IF EXISTS regress_file_fdw_superuser, regress_file_fdw_user, regress_no_priv_user; RESET client_min_messages; -CREATE ROLE file_fdw_superuser LOGIN SUPERUSER; -- is a superuser -CREATE ROLE file_fdw_user LOGIN; -- has priv and user mapping -CREATE ROLE no_priv_user LOGIN; -- has priv but no user mapping +CREATE ROLE regress_file_fdw_superuser LOGIN SUPERUSER; -- is a superuser +CREATE ROLE regress_file_fdw_user LOGIN; -- has priv and user mapping +CREATE ROLE regress_no_priv_user LOGIN; -- has priv but no user mapping -- Install file_fdw CREATE EXTENSION file_fdw; --- file_fdw_superuser owns fdw-related objects -SET ROLE file_fdw_superuser; +-- regress_file_fdw_superuser owns fdw-related objects +SET ROLE regress_file_fdw_superuser; CREATE SERVER file_server FOREIGN DATA WRAPPER file_fdw; -- privilege tests -SET ROLE file_fdw_user; +SET ROLE regress_file_fdw_user; CREATE FOREIGN DATA WRAPPER file_fdw2 HANDLER file_fdw_handler VALIDATOR file_fdw_validator; -- ERROR CREATE SERVER file_server2 FOREIGN DATA WRAPPER file_fdw; -- ERROR -CREATE USER MAPPING FOR file_fdw_user SERVER file_server; -- ERROR +CREATE USER MAPPING FOR regress_file_fdw_user SERVER file_server; -- ERROR -SET ROLE file_fdw_superuser; -GRANT USAGE ON FOREIGN SERVER file_server TO file_fdw_user; +SET ROLE regress_file_fdw_superuser; +GRANT USAGE ON FOREIGN SERVER file_server TO regress_file_fdw_user; -SET ROLE file_fdw_user; -CREATE USER MAPPING FOR file_fdw_user SERVER file_server; +SET ROLE regress_file_fdw_user; +CREATE USER MAPPING FOR regress_file_fdw_user SERVER file_server; -- create user mappings and grant privilege to test users -SET ROLE file_fdw_superuser; -CREATE USER MAPPING FOR file_fdw_superuser SERVER file_server; -CREATE USER MAPPING FOR no_priv_user SERVER file_server; +SET ROLE regress_file_fdw_superuser; +CREATE USER MAPPING FOR regress_file_fdw_superuser SERVER file_server; +CREATE USER MAPPING FOR regress_no_priv_user SERVER file_server; -- validator tests CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'xml'); -- ERROR @@ -66,7 +66,7 @@ CREATE FOREIGN TABLE agg_text ( b float4 ) SERVER file_server OPTIONS (format 'text', filename '@abs_srcdir@/data/agg.data', delimiter ' ', null '\N'); -GRANT SELECT ON agg_text TO file_fdw_user; +GRANT SELECT ON agg_text TO regress_file_fdw_user; CREATE FOREIGN TABLE agg_csv ( a int2, b float4 @@ -163,29 +163,29 @@ ALTER FOREIGN TABLE agg_csv NO INHERIT agg; DROP TABLE agg; -- privilege tests -SET ROLE file_fdw_superuser; +SET ROLE regress_file_fdw_superuser; SELECT * FROM agg_text ORDER BY a; -SET ROLE file_fdw_user; +SET ROLE regress_file_fdw_user; SELECT * FROM agg_text ORDER BY a; -SET ROLE no_priv_user; +SET ROLE regress_no_priv_user; SELECT * FROM agg_text ORDER BY a; -- ERROR -SET ROLE file_fdw_user; +SET ROLE regress_file_fdw_user; \t on EXPLAIN (VERBOSE, COSTS FALSE) SELECT * FROM agg_text WHERE a > 0; \t off -- file FDW allows foreign tables to be accessed without user mapping -DROP USER MAPPING FOR file_fdw_user SERVER file_server; +DROP USER MAPPING FOR regress_file_fdw_user SERVER file_server; SELECT * FROM agg_text ORDER BY a; -- privilege tests for object -SET ROLE file_fdw_superuser; -ALTER FOREIGN TABLE agg_text OWNER TO file_fdw_user; +SET ROLE regress_file_fdw_superuser; +ALTER FOREIGN TABLE agg_text OWNER TO regress_file_fdw_user; ALTER FOREIGN TABLE agg_text OPTIONS (SET format 'text'); -SET ROLE file_fdw_user; +SET ROLE regress_file_fdw_user; ALTER FOREIGN TABLE agg_text OPTIONS (SET format 'text'); -SET ROLE file_fdw_superuser; +SET ROLE regress_file_fdw_superuser; -- cleanup RESET ROLE; DROP EXTENSION file_fdw CASCADE; -DROP ROLE file_fdw_superuser, file_fdw_user, no_priv_user; +DROP ROLE regress_file_fdw_superuser, regress_file_fdw_user, regress_no_priv_user; |