The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.3. This release of pgAdmin 4 includes 4 new features and 14 bug fixes/housekeeping changes. For more details, please see the [release notes](https://www.pgadmin.org/docs/pgadmin4/9.3/release_notes_9_3.html). pgAdmin is the leading Open Source graphical management tool for PostgreSQL. For more information, please see [the website](https://www.pgadmin.org/). Notable changes in this release include: ### Features: * Add support for type constructors for PostGIS spatial types. * Added ability to use SQL in the "DB Restriction" field. * Add support for custom roles and role permissions management in pgAdmin. * Added support for font ligatures.
### Bugs/Housekeeping: * Add Cache-Control no-cache,no-store,must-revalidate header to dynamically generated utils.js file. * Fixed an issue where shift + click on rows/columns for range selection did not work in the query tool data output window. * Fixed an issue where the debugger hangs when stepping into nested function/procedure. * Ensure that graph data is updated even when the Dashboard tab is inactive. * Fixed an issue where Ctrl/Cmd+A in cell editor would select all rows. * Fixed an issue where drag and drop function with no parameters does not work. * Fixed an issue where changes to foreign key constraints were not detected in the schema diff. * Fixed an issue where the query tool went blank when converting history dates to the appropriate locale format. * Fixed an issue where the user management tab is not opening in the classic layout. * Allow OAuth 2 login using the username claim if the email is absent from the user profile. Builds for Windows and macOS are available now, along with a Python Wheel, Docker Container, RPM, DEB Package, and source code tarball from the [download area](https://www.pgadmin.org/download/).