| From: | Keith Fiske <keith(dot)fiske(at)crunchydata(dot)com> |
|---|---|
| To: | Sathish Reddy <sathishreddy(dot)postgresql(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Pg partman |
| Date: | 2024-08-26 18:41:19 |
| Message-ID: | CAODZiv7y3gH9UfHxALbdSwR1OFMAcUq3ABXXJ5qohEiU9GnQ6g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Aug 26, 2024 at 2:13 PM Sathish Reddy <
sathishreddy(dot)postgresql(at)gmail(dot)com> wrote:
> Hi
> We are planning to create function like run_maintance_proc which can do
> detach partition concurrently and create new partion s using pre-make in
> run maintenance..
>
> Please share any use case on these..
>
> Thanks
> Sathish Reddy
>
You cannot create a function or procedure within the database that can do
any commands with the CONCURRENT flag. PostgreSQL simply does not allow
that otherwise I would have done it already. As I stated elsewhere, this
would require an external script
https://github.com/pgpartman/pg_partman/issues/677
--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stepan Neretin | 2024-08-26 18:56:09 | Supporting pg freeze in pg_dump, restore. |
| Previous Message | Sathish Reddy | 2024-08-26 18:13:09 | Pg partman |