Error: pq: syntax error at or near "-" when deleting redshift DB

[fraserc182]

I've been trying to destroy a redshift DB and getting this error, not too sure if this is a bug or if we're running into something else here.
The only way we can get round it is to either delete it manually.

Terraform will perform the following actions:

  # redshift_database.db will be destroyed
  - resource "redshift_database" "db" {
      - connection_limit = -1 -> null
      - id               = "27376203" -> null
      - name             = "database-prd" -> null
      - owner            = (sensitive) -> null
    }

Plan: 0 to add, 0 to change, 1 to destroy.
redshift_database.db: Destroying... [id=27376203]
╷
│ Error: pq: syntax error at or near "-"
│ 
│ 
╵
Problem applying destroying terraform environment

[mtesch-um]

@fraserc182 as a workaround until the fix gets merged you can should be able to manually run DROP DATABASE "database-prd";

[fraserc182]

@mtesch-um yup can do. Thanks for working on this.