Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ERROR: pg_pathman is disabled #198

Open
sangli00 opened this issue Apr 22, 2019 · 1 comment
Open

ERROR: pg_pathman is disabled #198

sangli00 opened this issue Apr 22, 2019 · 1 comment

Comments

@sangli00
Copy link

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=#
@sangli00
Copy link
Author

gdb info:

(gdb) b add_to_pathman_config
Breakpoint 1 at 0x7f5c07be88fb: file src/pl_funcs.c, line 742.
(gdb) c
Continuing.

Breakpoint 1, add_to_pathman_config (fcinfo=0x2b49530) at src/pl_funcs.c:742
(gdb) p	pathman_init_state.initialization_needed
$1 = 1 '\001'
(gdb)

Why pathman_init_state.initialization_needed is TRUE?
what config parameter need modify?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant