Re: Detach partition concurrently from pg cron
| От | Keith Fiske |
|---|---|
| Тема | Re: Detach partition concurrently from pg cron |
| Дата | |
| Msg-id | CAODZiv6jH_rb55wWeNaxg7b8PajBVDH4ciCHB1c4X6tA3v5S-A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Detach partition concurrently from pg cron (Sathish Reddy <sathishreddy.postgresql@gmail.com>) |
| Ответы |
Re: Detach partition concurrently from pg cron
|
| Список | pgsql-admin |
On Mon, Jul 8, 2024 at 5:43 AM Sathish Reddy <sathishreddy.postgresql@gmail.com> wrote:
HiPlease help me on partman detach partition concurrently using pg cron run from postgres database to another database in detail.ThanksSathish 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.
В списке pgsql-admin по дате отправления: