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.
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 |