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