You signed in with another tab or window.Reload to refresh your session.You signed out in another tab or window.Reload to refresh your session.You switched accounts on another tab or window.Reload to refresh your session.Dismiss alert
NOTICE: sequence "range_rel_seq" does not exist, skipping
23
25
create_range_partitions
24
26
-------------------------
25
27
4
26
28
(1 row)
27
29
30
+
SELECT pathman.partition_data('test.range_rel');
31
+
NOTICE: Copying data to test.range_rel_4 (condition: ((dt >= 'Wed Apr 01 00:00:00 2015'::timestamp without time zone) AND (dt < 'Fri May 01 00:00:00 2015'::timestamp without time zone)))
32
+
NOTICE: Copying data to test.range_rel_3 (condition: ((dt >= 'Sun Mar 01 00:00:00 2015'::timestamp without time zone) AND (dt < 'Wed Apr 01 00:00:00 2015'::timestamp without time zone)))
33
+
NOTICE: Copying data to test.range_rel_2 (condition: ((dt >= 'Sun Feb 01 00:00:00 2015'::timestamp without time zone) AND (dt < 'Sun Mar 01 00:00:00 2015'::timestamp without time zone)))
34
+
NOTICE: Copying data to test.range_rel_1 (condition: ((dt >= 'Thu Jan 01 00:00:00 2015'::timestamp without time zone) AND (dt < 'Sun Feb 01 00:00:00 2015'::timestamp without time zone)))
35
+
partition_data
36
+
----------------
37
+
0
38
+
(1 row)
39
+
28
40
CREATE TABLE test.num_range_rel (
29
41
id SERIAL PRIMARY KEY,
30
42
txt TEXT);
@@ -37,8 +49,6 @@ NOTICE: sequence "num_range_rel_seq" does not exist, skipping
37
49
38
50
INSERT INTO test.num_range_rel
39
51
SELECT g, md5(g::TEXT) FROM generate_series(1, 3000) as g;
40
-
INSERT INTO test.range_rel (dt, txt)
41
-
SELECT g, md5(g::TEXT) FROM generate_series('2015-01-01', '2015-04-30', '1 day'::interval) as g;