Partman maintenance function issue

From: Ameya Bidwalkar <bidwalkar(dot)ameya10(at)gmail(dot)com>
To: Pgsql-admin(at)postgresql(dot)org
Subject: Partman maintenance function issue
Date: 2023-05-04 13:54:02
Message-ID: CA+OaHWL_ghMocRzoyzoBq=hRdjyTNO8DmKoi-Cac-7ko5iMRVw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Folks ,

We are moving from native partitioning to partman based partitioning. We
used this doc to migrate the existing set to partman
https://github.com/pgpartman/pg_partman/blob/master/doc/migration_to_partman.md

All the old partitions are renamed and new partitions were also created in
the initial setup with partman.create_parent function with the premake
values. Now we want to run maintenance to create the next set of partitions
for the future .
We are trying to run the command

select partman.run_maintenance(

p_parent_table := '<schema_name>.<table_name>');

This command gives error

SQL Error [P0001]: ERROR: zero-length delimited identifier at or near """"
CONTEXT: PL/pgSQL function partman.run_maintenance(text,boolean,boolean)
line 374 at EXECUTE
DETAIL:
HINT:
Where: PL/pgSQL function partman.run_maintenance(text,boolean,boolean)
line 408 at RAISE
If someone can help understand the cause of the error ,it would be
helpful for debugging.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2023-05-04 16:31:29 Re: pg_stat_activity.client_addr sometimes null for host connections
Previous Message M Sarwar 2023-05-04 13:21:50 Re: Just View create privilege to user user2