Bug: random_password flag is breaking when password validation policy is enabled

[manojchinnala]

TL;DR

In Release v14.0.0 Password Validation Policy to postgres module is released.
Additional users, random_password flag is breaking when password validation policy is enabled and trying to create to additional users.

Error: Error, failed to insert user adduser8 into instance pgsql-cftv14-pswdtest3-bca4ef77: googleapi: Error 400: Invalid request: INVALID_PASSWORD: password should contain at least one lowercase, one uppercase, one number and one non-alphanumeric characters., invalid

Expected behavior

Addition users, random_password should get the password complexity from password validation policy and generate strong password for additional users

Observed behavior

Error: Error, failed to insert user adduser8 into instance pgsql-cftv14-pswdtest3-bca4ef77: googleapi: Error 400: Invalid request: INVALID_PASSWORD: password should contain at least one lowercase, one uppercase, one number and one non-alphanumeric characters., invalid

Terraform Configuration

variable "enable_random_password_special" {
  description = "Enable special characters in generated random passwords."
  type        = bool
  default     = true
}

Terraform Version

Terraform v1.3.9
on windows_amd64
+ provider registry.terraform.io/hashicorp/google v4.55.0
+ provider registry.terraform.io/hashicorp/google-beta v4.55.0
+ provider registry.terraform.io/hashicorp/null v3.2.1
+ provider registry.terraform.io/hashicorp/random v3.4.3

Additional information

No response