Support for any object_type in postgresql_default_privileges

[loganmzz]

Terraform Version

Terraform v1.5.7
on linux_amd64
+ provider registry.terraform.io/cyrilgdn/postgresql v1.23.0
+ provider registry.terraform.io/hashicorp/aws v5.68.0
+ provider registry.terraform.io/hashicorp/random v3.6.2

Affected Resource(s)

• postgresql_default_privileges

Terraform Configuration Files

resource "postgresql_default_privileges" "this" {
  role = "main"
  database = "postgres"
  schema = "public"

  owner = "admin"
  object_type = "routine"
  privileges = ["EXECUTE"]
}

Panic Output

│ Error: expected object_type to be one of [table sequence function type schema], got routine
│ 
│   with postgresql_default_privileges.this,
│   on main.tf line 7, in resource "postgresql_default_privileges" "this":
│  7:   object_type = "routine"

Expected Behavior

Support any PgSQL supported type (documentation: https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html)

Actual Behavior

Plan error

Steps to Reproduce

1. terraform plan

Important Factoids

N/A

References

N/A

[tspearconquest]

I would also like to grant default privileges for object_type = "routine" because:

1. Postgresql doesn't support default privileges for object type "procedure"
2. Object type "routine" includes both functions and procedures and
3. The postgresql_grant resource supports object_type = "routine"

[tspearconquest]

Hi @cyrilgdn I have posted a PR to add support for this request for object_type = "routine" in the postgresql_default_privileges resource. I hope it meets the requirements. Please review and let me know if anything is missing.

[cyrilgdn]

This is now available in https://github.com/cyrilgdn/terraform-provider-postgresql/releases/tag/v1.26.0, thanks @tspearconquest for the work.

[Speeddymon]

Thank you! 🙏