-
Notifications
You must be signed in to change notification settings - Fork 797
Description
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!