1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
|
----
-- Regression test to Global Temporary Table implementation
--
-- Test on search_path forced by the extension
--
----
DROP EXTENSION pgtt;
SHOW search_path ;
search_path
------------------------------
"$user", public, pgtt_schema
(1 row)
create schema first_schema;
create schema second_schema;
SET search_path TO "$user",public,pg_catalog,fisrt_schema,second_schema;
SHOW search_path ;
search_path
-----------------------------------------------------------------------
"$user", public, pg_catalog, fisrt_schema, second_schema, pgtt_schema
(1 row)
CREATE EXTENSION pgtt;
SHOW search_path ;
search_path
-----------------------------------------------------------------------
"$user", public, pg_catalog, fisrt_schema, second_schema, pgtt_schema
(1 row)
SET search_path TO pg_catalog;
SHOW search_path ;
search_path
-------------------------
pg_catalog, pgtt_schema
(1 row)
SET search_path TO public;
SHOW search_path ;
search_path
---------------------
public, pgtt_schema
(1 row)
-- Test only pg_catalog in search_path.
DROP EXTENSION pgtt;
\c - -
SHOW search_path;
search_path
-----------------
"$user", public
(1 row)
SET search_path TO pg_catalog;
SHOW search_path;
search_path
-------------
pg_catalog
(1 row)
CREATE EXTENSION pgtt;
SHOW search_path;
search_path
--------------------------
pgtt_schema, pg_catalog
(1 row)
-- Test the pg_catalog at end of search_path.
DROP EXTENSION pgtt;
\c - -
SET search_path TO "$user", public, pg_catalog;
SHOW search_path;
search_path
-----------------------------
"$user", public, pg_catalog
(1 row)
CREATE EXTENSION pgtt;
SHOW search_path;
search_path
------------------------------------------
"$user", public, pgtt_schema, pg_catalog
(1 row)
-- Test empty search path like set by pg_dump
SELECT pg_catalog.set_config('search_path', '', false);
set_config
------------
(1 row)
SHOW search_path;
search_path
-------------
(1 row)
|
