diff options
Diffstat (limited to 'src/test/regress/expected/namespace.out')
-rw-r--r-- | src/test/regress/expected/namespace.out | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/src/test/regress/expected/namespace.out b/src/test/regress/expected/namespace.out index 2564d1b080..a62fd8ded0 100644 --- a/src/test/regress/expected/namespace.out +++ b/src/test/regress/expected/namespace.out @@ -1,6 +1,14 @@ -- -- Regression tests for schemas (namespaces) -- +-- set the whitespace-only search_path to test that the +-- GUC list syntax is preserved during a schema creation +SELECT pg_catalog.set_config('search_path', ' ', false); + set_config +------------ + +(1 row) + CREATE SCHEMA test_ns_schema_1 CREATE UNIQUE INDEX abc_a_idx ON abc (a) CREATE VIEW abc_view AS @@ -9,6 +17,43 @@ CREATE SCHEMA test_ns_schema_1 a serial, b int UNIQUE ); +-- verify that the correct search_path restored on abort +SET search_path to public; +BEGIN; +SET search_path to public, test_ns_schema_1; +CREATE SCHEMA test_ns_schema_2 + CREATE VIEW abc_view AS SELECT c FROM abc; +ERROR: column "c" does not exist +LINE 2: CREATE VIEW abc_view AS SELECT c FROM abc; + ^ +COMMIT; +SHOW search_path; + search_path +------------- + public +(1 row) + +-- verify that the correct search_path preserved +-- after creating the schema and on commit +BEGIN; +SET search_path to public, test_ns_schema_1; +CREATE SCHEMA test_ns_schema_2 + CREATE VIEW abc_view AS SELECT a FROM abc; +SHOW search_path; + search_path +-------------------------- + public, test_ns_schema_1 +(1 row) + +COMMIT; +SHOW search_path; + search_path +-------------------------- + public, test_ns_schema_1 +(1 row) + +DROP SCHEMA test_ns_schema_2 CASCADE; +NOTICE: drop cascades to view test_ns_schema_2.abc_view -- verify that the objects were created SELECT COUNT(*) FROM pg_class WHERE relnamespace = (SELECT oid FROM pg_namespace WHERE nspname = 'test_ns_schema_1'); |