-
Notifications
You must be signed in to change notification settings - Fork 69
Open
@sangli00
Description
Why cannot use pg_pathman?
detail error:
pipeline=# CREATE TABLE journal (
pipeline(# id SERIAL,
pipeline(# dt TIMESTAMP NOT NULL,
pipeline(# level INTEGER,
pipeline(# msg TEXT);
CREATE TABLE
pipeline=# CREATE INDEX ON journal(dt);
CREATE INDEX
pipeline=#
pipeline=# INSERT INTO journal (dt, level, msg)
pipeline-# SELECT g, random() * 6, md5(g::text)
pipeline-# FROM generate_series('2015-01-01'::date, '2015-12-31'::date, '1 minute') as g;
INSERT 0 524161
pipeline=# SELECT create_range_partitions('journal', 'dt', '2015-01-01'::date, '1 day'::interval);
ERROR: pg_pathman is disabled
CONTEXT: SQL statement "SELECT public.add_to_pathman_config(parent_relid, expression,
p_interval::TEXT)"
PL/pgSQL function create_range_partitions(regclass,text,anyelement,interval,integer,boolean) line 59 at PERFORM
pipeline=# show pg_pathman.enable;
pg_pathman.enable
-------------------
on
(1 row)
pipeline=#
Metadata
Metadata
Assignees
Labels
No labels