Re: Pg partman

Поиск
Список
Период
Сортировка
От Keith Fiske
Тема Re: Pg partman
Дата
Msg-id CAODZiv7y3gH9UfHxALbdSwR1OFMAcUq3ABXXJ5qohEiU9GnQ6g@mail.gmail.com
обсуждение исходный текст
Ответ на Pg partman  (Sathish Reddy <sathishreddy.postgresql@gmail.com>)
Ответы Re: Pg partman
Список pgsql-admin


On Mon, Aug 26, 2024 at 2:13 PM Sathish Reddy <sathishreddy.postgresql@gmail.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


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

В списке pgsql-admin по дате отправления: