role granted to another role revoked on next run

[ghdiska]

Hi i have some application role and some role for nominal user. The first one are assigned to the second one.

resource "postgresql_role" "data_inquiry_role" {
name = "${postgresql_schema.app_schema.name}_data_inquiry"
}

resource "postgresql_grant_role" "grant_gr_inquiry" {
role = "gr_${var.app_name}_data_inquiry"
grant_role = postgresql_role.data_inquiry_role.name
}

At first run role are correctly assigned but if i run another plan after apply it try to revoke grant, a new run after apply assigne grant again.

I'm using provider 1.26 but was the same with 1.25.

[AndresPinerosZen]

This happened to me when I was granting access on a same Postgres object with two different Terraform resources. What fixed it was to make sure object grants where done in a single tf resource.

[ghdiska]

i'm my case i want to grant different role to same "gr_" role but grant_role is never duplicated