DROP EXTENSION pg_partman CASCADE;
DROP TABLE IF EXISTS public.origtab_log_default CASCADE;
DROP TABLE IF EXISTS public.template_public_origtab_log CASCADE;

CREATE EXTENSION pg_partman;
SELECT public.create_parent(
        p_parent_table := 'public.origtab_log'::text,
        p_control      := 'update_timestamp'::text,
        p_type         := 'range'::text,
        p_interval     := '1 day'::text,
        p_premake      := 7::int   -- 7 Tage im Voraus
);

UPDATE public.part_config SET retention = '30 days', retention_keep_table = false WHERE parent_table = 'public.origtab_log';

SELECT public.run_maintenance();