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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
|
\set ON_ERROR_ROLLBACK 1
\set ON_ERROR_STOP true
BEGIN;
SELECT set_config('search_path','partman, public',false);
SELECT plan(4);
CREATE SCHEMA partman_test;
-- Sanity check that new features get add to definition dumping.
SELECT bag_eq(
E'SELECT attname
FROM pg_catalog.pg_attribute a
JOIN pg_catalog.pg_class c ON a.attrelid = c.oid
WHERE c.relname = ''part_config''
AND NOT attisdropped AND attnum > 0',
ARRAY[
'parent_table',
'control',
'time_encoder',
'time_decoder',
'partition_interval',
'partition_type',
'premake',
'automatic_maintenance',
'template_table',
'retention',
'retention_schema',
'retention_keep_index',
'retention_keep_table',
'epoch',
'constraint_cols',
'optimize_constraint',
'infinite_time_partitions',
'datetime_string',
'jobmon',
'sub_partition_set_full',
'undo_in_progress',
'inherit_privileges',
'constraint_valid',
'ignore_default_data',
'date_trunc_interval',
'maintenance_order',
'retention_keep_publication',
'maintenance_last_run',
'async_partitioning_in_progress'
]::TEXT[],
'When adding a new column to part_config please ensure it is also added to the dump_partitioned_table_definition function and the tests in this file'
);
-- Create a partman declarative partitioned table.
CREATE TABLE partman_test.declarative_objects(
id SERIAL,
t TEXT,
created_at TIMESTAMP NOT NULL
) PARTITION BY RANGE (created_at);
SELECT create_parent('partman_test.declarative_objects', 'created_at', '1 week', p_premake := 2, p_start_partition := (NOW() - '4 weeks'::INTERVAL)::TEXT);
-- Update config options you can't set at initial creation.
UPDATE part_config
SET retention='5 weeks', retention_keep_table = 'f', infinite_time_partitions = 't', constraint_valid = 'f', inherit_privileges = 't'
WHERE parent_table = 'partman_test.declarative_objects';
-- Test output "visually" (with p_ignore_template_table = true).
SELECT dump_partitioned_table_definition('partman_test.declarative_objects', p_ignore_template_table := true);
--
-- -- Test output "visually" (with default p_ignore_template_table = false).
-- -- Note that spaces before each line are literal tabs (\t), not spaces
SELECT is(
(SELECT dump_partitioned_table_definition('partman_test.declarative_objects')),
E'SELECT partman.create_parent(
p_parent_table := ''partman_test.declarative_objects'',
p_control := ''created_at'',
p_interval := ''7 days'',
p_type := ''range'',
p_epoch := ''none'',
p_premake := 2,
p_default_table := ''t'',
p_automatic_maintenance := ''on'',
p_constraint_cols := NULL,
p_template_table := ''partman.template_partman_test_declarative_objects'',
p_jobmon := ''t'',
p_date_trunc_interval := NULL,
p_control_not_null := ''t''
);
UPDATE partman.part_config SET
optimize_constraint = 30,
retention = ''5 weeks'',
retention_schema = NULL,
retention_keep_index = ''t'',
retention_keep_table = ''f'',
infinite_time_partitions = ''t'',
datetime_string = ''YYYYMMDD'',
sub_partition_set_full = ''f'',
inherit_privileges = ''t'',
constraint_valid = ''f'',
ignore_default_data = ''t'',
maintenance_order = NULL,
retention_keep_publication = ''f''
WHERE parent_table = ''partman_test.declarative_objects'';'
);
-- Test end to end (with p_ignore_template_table = true):
-- 1. Capture the current config.
SELECT part_config AS declarative_objects_part_config FROM part_config WHERE parent_table = 'partman_test.declarative_objects'
\gset
SELECT dump_partitioned_table_definition('partman_test.declarative_objects', p_ignore_template_table := true) AS var_sql
\gset
-- 2. Remove partitioning and recreate table.
CREATE TABLE partman_test.old_declarative_objects(id SERIAL, t TEXT, created_at TIMESTAMP NOT NULL);
SELECT undo_partition('partman_test.declarative_objects', p_target_table := 'partman_test.old_declarative_objects', p_keep_table := false);
DROP TABLE partman_test.declarative_objects;
CREATE TABLE partman_test.declarative_objects(
id SERIAL,
t TEXT,
created_at TIMESTAMP NOT NULL
) PARTITION BY RANGE (created_at);
-- 3. Run dumped config.
SELECT :'var_sql'
\gexec
-- 4. Check the current config (it should match step 1).
SELECT row_eq(
'SELECT * FROM part_config WHERE parent_table = ''partman_test.declarative_objects''',
(:'declarative_objects_part_config')::part_config
);
-- Test end to end (with default p_ignore_template_table = false):
-- 1. Capture the current config.
SELECT part_config AS declarative_objects_part_config FROM part_config WHERE parent_table = 'partman_test.declarative_objects'
\gset
SELECT dump_partitioned_table_definition('partman_test.declarative_objects') AS var_sql
\gset
-- 2. Remove partitioning and recreate table.
SELECT undo_partition('partman_test.declarative_objects', p_target_table := 'partman_test.old_declarative_objects', p_keep_table := false);
DROP TABLE partman_test.declarative_objects;
CREATE TABLE partman_test.declarative_objects(
id SERIAL,
t TEXT,
created_at TIMESTAMP NOT NULL
) PARTITION BY RANGE (created_at);
-- 3. Run dumped config (after creating template table).
CREATE TABLE template_partman_test_declarative_objects(
id SERIAL,
t TEXT,
created_at TIMESTAMP NOT NULL
);
SELECT :'var_sql'
\gexec
-- 4. Check the current config (it should match step 1).
SELECT row_eq(
'SELECT * FROM part_config WHERE parent_table = ''partman_test.declarative_objects''',
(:'declarative_objects_part_config')::part_config
);
SELECT * FROM finish();
ROLLBACK;
|
