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
