resource postgresql_grant not working on postgresql v15

[luismacosta]

Hi there,

Thank you for opening an issue. Please provide the following information:

Terraform Version

Terraform v1.4.0 on darwin_amd64

provider registry.terraform.io/cyrilgdn/postgresql v1.19.0

Affected Resource(s)

postgresql_grant

Terraform Configuration Files

resource "postgresql_grant" "su_schema" {
  database    = test
  role        = test
  schema      = public
  object_type = "schema"
  privileges = [
    "CREATE",
    "USAGE",
  ]
}

Actual Behavior

│ Error: Error granting role pg_database_owner to masteruser: pq: role "pg_database_owner" cannot have explicit members │ │ with module.postgresql_roles.postgresql_grant.su_schema, │ on .terraform/modules/postgresql_roles/postgresql/role/roles.su.tf line 5, in resource "postgresql_grant" "su_schema": │ 5: resource "postgresql_grant" "su_schema" {

Steps to Reproduce

1. terraform plan