terraform-provider-postgresql
terraform-provider-postgresql copied to clipboard
cyrilgdn
Manage new createrole_self_grant setting (PG16)
cf https://github.com/cyrilgdn/terraform-provider-postgresql/issues/407#issuecomment-2407615861 PR: #481
In v1.24.0, we did a small fix to be compatible with PG16 but with the same behavior than previous version. In Postgres 16, we can now change the role inheritance behavior when a non-superuser role creates another role. cf https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-CREATEROLE-SELF-GRANT
The new setting createrole_self_grant allows to configure this behavior
@librucha already did the work in #481 to manage this setting, I'm just creating this issue to keep track of it until we merge/release it.
@cyrilgdn I closed previous PR #481 and will prepeare smaller PR only for role parameters attribute. (currently only with createrole_self_grant allowed).
I see this is pretty old; was this resolved in a newer version? I'm running into issues where I need to be able to assign this setting to create roles in my azure postgresql cluster (default value there is 'set, inherit' vs the empty string in the postgresql docs), and while I see a feature flag for it in the current source, I'm not seeing any of the other bits from #481 in there. Are there plans for this to move forward? Am I missing another obvious way to do this with my provider?
