Size of database_connection_pool cannot be edited without recreate

[sundowndev]

Bug Report

Describe the bug

Modifying size of connection pool make Terraform to recreate the connection pool. So I have to edit that field on webui then edit in my HCL file for now.

Is that normal ? What will happen for alive connections when the pool will be recreated ?

Affected Resource(s)

Expected Behavior

Terraform to edit the existing resource.

Actual Behavior

Terraform recreates the connection pool.

Steps to Reproduce

1. Create a database connection pool, apply

   resource "digitalocean_database_connection_pool" "pool-01" {
   cluster_id = digitalocean_database_cluster.postgres-example.id
   name       = "pool-01"
   mode       = "transaction"
   size       = 8
   db_name    = "defaultdb"
   user       = "doadmin"
   }

2. Increase the size of the pool, run plan

   -  size       = 8
   + size       = 10
   db_name    = "defaultdb"
   user       = "doadmin"
   }

Let me know if you need further information

[mustafayildirim]

I don't think Edit Connection Pool Api exists.

You can only add a new connection pool https://docs.digitalocean.com/reference/api/api-reference/#operation/add_connection_pool

[andrewsomething]

Just wanted to follow up here to mention that this feedback has been passed on to the Database as a Service team at DigitalOcean.