pgAdmin 4 7.8

What's new in this version:

New features:
- Add support for foreign table’s new functionality for PG 11 and above
- Allow setting custom username for shared servers, with default as username of server being shared
- Add ‘GENERATED ALWAYS AS..’ option while creating column constraints for Foreign Table
- GUI representation of the system’s activity using the ‘system_stats’ extension
- Added ‘load_balance_hosts’ connection string parameter for PG 16 and above

Housekeeping:
- Use PG16 as the default PostgreSQL version

Fixed:
- Fixed an issue in ERD tool where the downloaded images have a few links cut
- Fixed an issue where user was not able to assign new/old columns as primary key once column with primary key is deleted
- Add support for setting prepare threshold in server connection
- Fixed an issue where the wrong message “Current database has been moved or renamed” is displayed when debugging any function
- Fixed an issue where Processes tab displays wrong server name in some scenario
- Fix an issue where global/native keyboard shortcuts are not working when any cell of data output grid has focus
- Fixed query history slowness issue by storing query only for those having certain threshold max length
- Fix an issue where foreign table column name becomes “none” if the user changes any column data type
- Pin the cryptography version to fix PyO3 modules initialisation error
- Ensure that the backup works properly for PG 16 on the latest docker image
- Fixed an issue where the user is unable to select objects on the backup dialog due to tree flickering
- Fixed an issue where non-super PostgreSQL users are not able to terminate their own connections from dashboard
- Fix an issue where scale in columns is not allowed to have value as 0 or below
- Fix an issue in graphical explain plan where query tool crashes when the plan has parallel workers details and sort node is clicked for details
- Fix an issue where user login is not working if username/email contains single quote in server mode