pgAdmin 4 5.70

What's new in this version:

New:
- Added support for the truncate table with restart identity
- Make code folding case insensitive in the code mirror
- Added database and server information on the Maintenance process watcher dialog
- Allow the referenced table to be the same as the local table in one to many relationship for ERD Tool
- Make closing tabs to be smarter by focusing on the appropriate tab when the user closed a tab
- Set PSQLRC and PSQL_HISTORY env vars to apt. user storage path in the server mode
- Housekeeping

Fixed:
- an issue where privileges were revoked using SQL query on objects like tables that do not correctly show in SQL tab
- an issue where the user can not paste the updated table header in safari 12 and 13 browsers
- Ensure that trigger function SQL should have ‘create or replace function’ instead of ‘create function’ only
- blank screen issue on windows and also made changes to use NWjs manifest for remembering window size
- the export image issue where relation lines are over the nodes
- width limitation issue in PSQL tool window
- an issue where columns with sequences get altered unnecessarily with a schema diff tool
- Ensure that the lock panel should not be blocked for larger records
- Partially fixes the data output panel display issue
- an issue where whitespace in function bodies was not applied while generating the script using Schema Diff
- Introduced OAUTH2_SCOPE variable for the Oauth2 scope configuration
- Enables pgAdmin to retrieve user permissions in case of nested roles which helps to terminate the session for AWS RDS
- no attribute ‘_asdict’ error when connecting the database server
- errors related to HTML tags shown in the error message for JSON editor
- UnboundLocalError where local variable ‘user_id’ referenced before assignment
- Renamed ‘Auto rollback?’ to ‘Auto rollback on error?’
- the JSON editor issue of hiding the first record
- Ensure that deleting a database should not automatically connect to the next database
- Ensure that pgAdmin should not fail at login due to a special character in the hostname
- an issue where multiple query tool tabs getting closed for the single close event