File: tablespace

package info (click to toggle)
pg-repack 1.4.8-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 768 kB
  • sloc: ansic: 4,911; sql: 376; makefile: 107; sh: 53
file content (63 lines) | stat: -rw-r--r-- 2,310 bytes parent folder | download | duplicates (2)
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
The tests expect a tablespace to exists, we let the tests create it

--- a/regress/sql/tablespace.sql
+++ b/regress/sql/tablespace.sql
@@ -6,6 +6,8 @@ SET client_min_messages = warning;
 -- Note: in order to pass this test you must create a tablespace called 'testts'
 --
 
+CREATE TABLESPACE testts LOCATION '/tmp/pg-repack-tablespace';
+
 SELECT spcname FROM pg_tablespace WHERE spcname = 'testts';
 -- If the query above failed you must create the 'testts' tablespace;
 
--- a/regress/expected/tablespace.out
+++ b/regress/expected/tablespace.out
@@ -4,6 +4,7 @@ SET client_min_messages = warning;
 --
 -- Note: in order to pass this test you must create a tablespace called 'testts'
 --
+CREATE TABLESPACE testts LOCATION '/tmp/pg-repack-tablespace';
 SELECT spcname FROM pg_tablespace WHERE spcname = 'testts';
  spcname 
 ---------
--- a/regress/expected/tablespace_1.out
+++ b/regress/expected/tablespace_1.out
@@ -4,6 +4,7 @@ SET client_min_messages = warning;
 --
 -- Note: in order to pass this test you must create a tablespace called 'testts'
 --
+CREATE TABLESPACE testts LOCATION '/tmp/pg-repack-tablespace';
 SELECT spcname FROM pg_tablespace WHERE spcname = 'testts';
  spcname 
 ---------
--- a/regress/expected/tablespace_2.out
+++ b/regress/expected/tablespace_2.out
@@ -4,6 +4,7 @@ SET client_min_messages = warning;
 --
 -- Note: in order to pass this test you must create a tablespace called 'testts'
 --
+CREATE TABLESPACE testts LOCATION '/tmp/pg-repack-tablespace';
 SELECT spcname FROM pg_tablespace WHERE spcname = 'testts';
  spcname 
 ---------
--- a/regress/expected/tablespace_3.out
+++ b/regress/expected/tablespace_3.out
@@ -4,6 +4,7 @@ SET client_min_messages = warning;
 --
 -- Note: in order to pass this test you must create a tablespace called 'testts'
 --
+CREATE TABLESPACE testts LOCATION '/tmp/pg-repack-tablespace';
 SELECT spcname FROM pg_tablespace WHERE spcname = 'testts';
  spcname 
 ---------
--- a/regress/expected/tablespace_4.out
+++ b/regress/expected/tablespace_4.out
@@ -4,6 +4,7 @@ SET client_min_messages = warning;
 --
 -- Note: in order to pass this test you must create a tablespace called 'testts'
 --
+CREATE TABLESPACE testts LOCATION '/tmp/pg-repack-tablespace';
 SELECT spcname FROM pg_tablespace WHERE spcname = 'testts';
  spcname 
 ---------