这是indexloc提供的服务,不要输入任何密码
Skip to content

"Failed to setup role" with hyphens in name #6531

@Arawn-Davies

Description

@Arawn-Davies

Please note that security bugs or issues should be reported to security@pgadmin.org.

Describe the bug

At my organisation, we have roles setup, and one of these roles is "giscorp-pg-ict-admin". In pgAdmin 4 v6.21 I am able to connect using this role, specified in the server properties window, however when I use the same server .json list in pgAdmin 4 v7.3 it gives this error

Failed to setup the role syntax error at or near "-" LINE 1: SET ROLE TO giscorp-pg-ict-admin ^

I've tried to escape the role name by surrounding it in single and double quotes, but single quotes return the error:

Failed to setup the role the cursor is closed

and double quotes return the error:

Failed to setup the role "giscorp-pg-ict-admin"

To Reproduce

Steps to reproduce the behavior:
Setup a role with hyphens in the name, and set role using the specified role just created

Expected behavior

Log in as the specified role, as it works in pgAdmin v6

Error message

Single quotes return the error:

Failed to setup the role the cursor is closed

and double quotes return the error:

Failed to setup the role "giscorp-pg-ict-admin"

Desktop (please complete the following information):

  • OS: Windows 10 Enterprise
  • Version: 22H2 (19045.3086)
  • Mode: Desktop

Additional context
I'm fairly low on the organisational hierarchy so I won't be able to perform any workarounds, although they'll probably just tell us to stick with v6 for the time being.

Thank you!

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions