-
Notifications
You must be signed in to change notification settings - Fork 69
Closed
Labels
Milestone
@DmitriyAr
Description
Steps to reproduce:
CREATE TABLE public._journal (
id SERIAL,
dt TIMESTAMP NOT NULL,
level INTEGER,
msg TEXT);
CREATE OR REPLACE VIEW public.journal AS SELECT * FROM public._journal;
CREATE INDEX ON public._journal(dt);
INSERT INTO public._journal (dt, level, msg)
SELECT g, random() * 6, md5(g::text)
FROM generate_series('2016-01-01'::date, '2016-12-31'::date, '1 minute') as g;
SELECT public.create_range_partitions('public._journal', 'dt', '2016-01-01'::date, '1 month'::interval);
********** Error **********
ERROR: could not find junk tableoid1 column
SQL state: XX000
If disable pg_pathman for the table:
SELECT public.disable_pathman_for('public._journal'::regclass);
SELECT .. FOR UPDATE is OK.