Version 6.1

Release date: 2021-10-21

This release contains a number of bug fixes and new features since the release of pgAdmin4 6.0.

New features

Issue #4596 - Added support for indent guides in the browser tree.
Issue #6081 - Added support for advanced table fields like the foreign key, primary key in the ERD tool.
Issue #6241 - Added support to allow tables to be dragged to ERD Tool.
Issue #6529 - Added index creation when generating SQL in the ERD tool.
Issue #6657 - Added support for authentication via the webserver (REMOTE_USER).
Issue #6794 - Added support to enable/disable rules.

Housekeeping

Bug fixes

Issue #6719 - Fixed OAuth2 integration redirect issue.
Issue #6754 - Ensure that query highlighting color in the query tool should be less intensive.
Issue #6776 - Changed the label ‘Inherits Tables?’ to ‘Is inherited?’ as it misleading in the properties panel.
Issue #6790 - Fixed an issue where the user is unable to create an index with concurrently keyword.
Issue #6797 - Remove an extra blank line at the start of the SQL for function, procedure, and trigger function.
Issue #6802 - Fixed the issue of editing triggers for advanced servers.
Issue #6828 - Fixed an issue where the tree is not scrolling to the object selected from the search result.
Issue #6858 - Fixed object delete issue from the properties tab for the collection nodes.
Issue #6876 - Ensure that the Dashboard should get updated after connecting to the server.
Issue #6881 - Fixed an issue where the browser tree doesn’t show all contents on changing resolution.
Issue #6882 - Ensure that columns should be displayed in the order of creation instead of alphabetical order in the browser tree.
Issue #6890 - Fixed background colour issue in the browser tree.
Issue #6891 - Added support for composite foreign keys in the ERD tool.
Issue #6900 - Fixed an issue where exclusion constraint cannot be created from table dialog if the access method name is changed once.
Issue #6905 - Fixed an issue where the users are unable to load the databases behind an HTTP reverse proxy.
Issue #6908 - Fixed an issue where each click to refresh the collection node, the number of objects decreasing by tens or more.
Issue #6912 - Fixed browser tree sort order regression issue.
Issue #6915 - Fixed an issue where the blank string is stored instead of NULL in the server table of SQLite database.
Issue #6928 - Ensure that the master password should be prompt when MASTER_PASSWORD_REQUIRED is set to True and AUTHENTICATION_SOURCES is webserver.
Issue #6929 - Ensure that only the table node should be allowed to drop on the ERD tool.
Issue #6930 - Fixed an issue where the existing server group is disappeared on rename it.
Issue #6935 - Fixed an issue where the wrong SQL is generated when deleting and renaming table columns together.