On Mon, Aug 26, 2024 at 3:36 PM Sathish Reddy <sathishreddy.postgresql@xxxxxxxxx> wrote:
Please share the script which used..
Thanks
Sathish ReddyOn 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: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 ReddyYou 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--
There are no scripts written for this yet.