ALL privileges still not working for tables in postgres version => 17

[amais33]

Related to @talbx works here: #339

I confirm that the issue is solved with postgres version under 17 for me.
But I still have the issue for "tables" with the version 17.
I think it's because of the new MAINTAIN privilege.
I found this 2 places where the list of tables privileges are present:

postgresql/helpers.go
postgresql/helpers_test.go
Maybe one need to add a test of postgres version and append the list with the MAINTAIN privilege if it's => 17, WDYT?

[talbx]

hey @amais33 I struggled reproducing your issue with PG 17. Could you provide a very minimal example IaC definition for me?

[amais33]

Hey @talbx, thanks for looking into this issue.
Here’s a minimal example of an IaC definition:

resource "postgresql_default_privileges" "default_privileges" {
  database = "exampledb"
  role     = "exampleuser"
  schema   = "public"
  object_type = "table"
  privileges = ["ALL"]

  depends_on = [module.postgres]
}

Does this work for you?