Error "Request failed with status code 500" is displayed if we click on Dependents for the user

[FaharAbbasRizvi]

Error "Request failed with status code 500" is displayed if we click on Dependents for the user

To Reproduce

Steps to reproduce the behavior:

1. Click on Dependents
2. Go to Login and Users
3. Click on postgres user
4. See the error "Request failed with status code 500"

Expected behavior

No Error Message is displayed if the user clicks on Dependents

Screenshots

• OS: [All]
• Version: [7.0]
• Mode: [All]
• Package type: [All]

[adityatoshniwal]

@FaharAbbasRizvi Isn't this same as #6093 which you marked as resolved?

[FaharAbbasRizvi]

Please note that this is only specific to EPAS/PG 15

Here is the View log information:
dispatch_request
return method(*args, **kwargs)
File "C:\Users\faharabbas\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\browser\server_groups\servers\roles_init_.py", line 700, in wrapped
return f(self, **kwargs)
File "C:\Users\faharabbas\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\browser\server_groups\servers\roles_init_.py", line 1069, in dependents
dependents_result = self.get_dependents(self.conn, sid, rid)
File "C:\Users\faharabbas\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\browser\server_groups\servers\roles_init_.py", line 1220, in get_dependents
self.temp_connection_check(rid, temp_conn, db_row, types,
File "C:\Users\faharabbas\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\browser\server_groups\servers\roles_init.py", line 1135, in _temp_connection_check
RoleView.handle_dependents_data(result, types, dependents, db_row)
File "C:\Users\faharabbas\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\browser\server_groups\servers\roles_init.py", line 1091, in _handle_dependents_data
for row in result['rows']:
TypeError: string indices must be integers

[FaharAbbasRizvi]

This is fixed in the latest snapshot build:
https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2023-04-25/