Release date: 2020-08-20

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

New features

Issue #3904 - Replace charting library Flotr2 with ChartJS using React.
Issue #5126 - Modified schema diff tool to compare two databases instead of two schemas.
Issue #5610 - Add a –yes command line option to setup-web.sh to allow non-interactive use.

Housekeeping

Issue #5324 - Improve code coverage and API test cases for Foreign Servers and User Mappings.
Issue #5327 - Improve code coverage and API test cases for Schemas.
Issue #5336 - Improve code coverage and API test cases for Types.
Issue #5700 - Remove old Python 2 compatibility code.
Issue #5731 - Upgrade font awesome from v4 to v5.

Bug fixes

Issue #3767 - Ensure that the original file format should be retained when saving the same file in SQL editor.
Issue #3791 - Added missing comments in reverse engineering SQL for each column of a View.
Issue #4123 - Fixed an issue where debugger doesn’t work if the search path is set other than ‘public’.
Issue #4361 - Fixed ssh tunnel hang issue when the user tries to disconnect the server.
Issue #4387 - Fixed an issue where the user is not able to insert the data if the table and columns name contains special characters.
Issue #4810 - Fixed an issue where the user is not able to save the new row if the table is empty.
Issue #5429 - Ensure that the Dictionaries drop-down shows all the dictionaries in the FTS configuration dialog.
Issue #5490 - Make the runtime configuration dialog non-modal.
Issue #5526 - Fixed an issue where copying and pasting a cell with multiple line data will result in multiple rows.
Issue #5567 - Fixed an issue where conversion of bytea to the binary string results in an error.
Issue #5604 - Fixed an issue where the entire logs is in red text when the user runs backup and restore.
Issue #5632 - Ensure that the user will be able to modify the start value of the Identity column.
Issue #5646 - Ensure that RLS Policy node should be searchable using search object.
Issue #5664 - Fixed an issue where ‘ALTER VIEW’ statement is missing when the user sets the default value of a column for View.
Issue #5670 - Fixed an issue where the error message does not have a close button on utility dialogs.
Issue #5689 - Added the ‘ORDER BY’ clause for the privileges type to fix schema diff issue.
Issue #5708 - Correct TLS certificate filename in the container deployment docs.
Issue #5710 - Fixed an issue when comparing the table with a trigger throwing error in schema diff.
Issue #5713 - Corrected DROP SQL syntax for catalog.
Issue #5716 - Fixed an issue where ajax call continues to fire even after disconnecting the database server.
Issue #5724 - Clarify some of the differences when running in server mode in the docs.
Issue #5730 - Resolve schema diff dependencies by selecting the appropriate node automatically and maintain the order in the generated script.