Postgres Pro
Downloads
Home   >   mailing lists

Re: Detach partition concurrently from pg cron - Mailing list pgsql-admin

From Keith Fiske
Subject Re: Detach partition concurrently from pg cron
Date
Msg-id CAODZiv6jH_rb55wWeNaxg7b8PajBVDH4ciCHB1c4X6tA3v5S-A@mail.gmail.com
Whole thread Raw
In response to Detach partition concurrently from pg cron  (Sathish Reddy <sathishreddy.postgresql@gmail.com>)
Responses Re: Detach partition concurrently from pg cron
List pgsql-admin
Tree view
On Mon, Jul 8, 2024 at 5:43 AM Sathish Reddy <sathishreddy.postgresql@gmail.com> wrote:
Hi 
  Please help me on partman detach partition concurrently using pg cron run from postgres database to another database in detail.

Thanks 
Sathish Reddy 

Concurrent detach is not possible with pg_partman at this time. No concurrent operations can be called within a function's transaction block.

See this issue for more information - https://github.com/pgpartman/pg_partman/issues/387

If you need to detach concurrently, you will have to use some separate process to do it at this time. Not sure if that can be done with pg_cron since I'm not sure if that is also doing its own calls within a functional transaction. 

--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com

pgsql-admin by date:

Previous
From: Wasim Devale
Date:
Subject: Re: reindex from pgadmin issue
Next
From: Peter Adlersburg
Date:
Subject: Retrieve "CREATE FOREIGN SERVER" with pg_dump ... --schema=