Re: Pg partman

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Mon, Aug 26, 2024 at 3:36 PM Sathish Reddy <sathishreddy.postgresql@xxxxxxxxx> wrote:

Please share the script which used..

Thanks
Sathish Reddy


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


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


There are no scripts written for this yet.

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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux