pgAdmin 4 v7.0 Released

From: pgAdmin Development Team via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: pgAdmin 4 v7.0 Released
Date: 2023-04-15 06:14:22
Message-ID: 168153926200.2127918.17942165583504774981@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 7.0. This release of pgAdmin 4 includes 43 bug fixes and new features. For more details please see the [release notes](https://www.pgadmin.org/docs/pgadmin4/7.0/release_notes_7_0.html).

pgAdmin is the leading Open Source graphical management tool for PostgreSQL. For more information, please see [the website](https://www.pgadmin.org/).

### Note
To upgrade on RHEL 8, Rocky Linux 8, Fedora 36, and Fedora 37 users have to manually remove the “python3-mod_wsgi” package. While removing the “python3-mod_wsgi” package, it removes all the dependencies, and pgadmin 4 is one of the dependencies.

Notable changes in this release include:

### Features:
* Auto expand row edit form when a new row is added for Primary Key, Foreign Key, Unique Constraint, and Exclusion Constraint.
* Added support for mounting shared storage in server mode.
* Add a note on top of keyboard shortcut preferences to show the Accesskey of the browser.
* Added capability to deploy PostgreSQL servers on Google Cloud.
* Added support of BigAnimal v3 API.
* On pressing Ctrl+C on a tree object, copy the fully qualified name to the clipboard.
* Added option to create unique constraint with nulls not distinct.

### Bugs/Housekeeping:
* Upgrade from psycopg2 to psycopg3, Update SQLAlchemy, Flask, Flask-SQLAlchemy, and other packages to current versions, and Remove Bootstrap and jQuery usage.
* Fixed the LDAP authentication issue for the simultaneous login attempts.(CVE-2023-1907).
* Show appropriate error message when master password is not set instead of 'Crypt key missing'.
* Ensure that the user's storage directory is created when the users are created, as well as for those users whose directories have not yet been created.
* Fixed an issue where migration on an external database is not working.
* Fixed CSV export from Query Tool results does not include all columns for multiple CTEs.
* Fixed 'rawunicodeescape' codec can't decode issue in an SQL_ASCII database.
* Use fetch instead of Axios to close connections in SQLEditor, ERD, Schema Diff, and Debugger to ensure it completes.
* Ensure that when pasting rows the rows are added right below the selected rows for copying.
* Fix the dependents SQL of Roles which is throwing a type casting error on PostgreSQL 15.

Builds for Windows and macOS are available now, along with a Python Wheel, Docker Container, RPM, DEB Package, and source code tarball from the [tarball area](https://www.pgadmin.org/download/).

Browse pgsql-announce by date

  From Date Subject
Next Message Yohz Software/Yohz Ventures Sdn Bhd via PostgreSQL Announce 2023-04-15 16:28:19 DB Doc 10.2 released
Previous Message MigOps via PostgreSQL Announce 2023-04-06 21:15:59 credcheck v1.0 released