Re: Pg partman

Поиск
Список
Период
Сортировка
От Sathish Reddy
Тема Re: Pg partman
Дата
Msg-id CA+M9Y+BFBjEYZ+0kU3nAf_MSW6_wFEBsf-a4B9Uwy5GMTCjKUw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Pg partman  (Keith Fiske <keith.fiske@crunchydata.com>)
Ответы Re: Pg partman
Список pgsql-admin
Дерево обсуждения

Please share the script which used..

Thanks
Sathish Reddy

On Tue, Aug 27, 2024, 12:11 AM Keith Fiske <keith.fiske@crunchydata.com> wrote:


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 по дате отправления: