Dash character is not supported for Name property

[jeroenkoknl]

If one would create a Custom::PostgreSQLUser resource with Name property value that includes a dash character ('-') then the resource creation fails.

I think this is because the generated SQL does not use a delimited identifier or quoted identifier for user, role and database names.

E.g.

This will fail:

CREATE DATABASE database-name

Adding double quotes fixes this:

CREATE DATABASE "database-name"

[mvanholsteijn]

Hi Jeroen,

I explicitly restricted the SQL identifier to ^[_A-Za-z][A-Za-z0-9_$]*$ to keep names nice and clean. To honour your request, I would need to modify the provider and I am pretty stretched for time right now. Are you in a hurry for this feature?

Cheers,

Mark

[jeroenkoknl]

Thanks Mark for looking into this. No hurry at all. We could easily replace the dash with an underscore.