Softpedia >Mac >Business >pgAdmin 4 >  Changelog

pgAdmin 4 Changelog

What's new in pgAdmin 4 8.5

Apr 8, 2024
  • New features:
  • Issue #5611 - Added support for provider, deterministic, version and RULES parameter while creating collation.
  • Issue #7098 - Added support for EDB Job Scheduler.
  • Issue #7216 - Added support for viewing Log Based Clusters.
  • Issue #7221 - Added support for UNIX socket in entrypoint.sh for Docker implementation.
  • Housekeeping:
  • Bug fixes:
  • Issue #4413 - Fixed an issue in Schema Diff where Columns with sequences get altered unnecessarily.
  • Issue #7111 - Fixed an issue where user was unable to share a newly registered server.
  • Issue #7116 - Bug fixes and improvements in pgAdmin CLI.
  • Issue #7139 - Fixed an issue where the ‘Save Password’ option for SSH tunneling password was consistently disabled.
  • Issue #7165 - Fixed schema diff wrong query generation for table, foreign table and sequence.
  • Issue #7210 - Fixed an issue where table properties were not updating from properties dialog.
  • Issue #7218 - Fixed an issue where maximize icon is missing from query tool panel.
  • Issue #7229 - Fix an issue in table dialog where changing column name was not syncing table constraints appropriately.
  • Issue #7248 - Fixed rollback and commit button activation on execute button click.
  • Issue #7255 - Fixed an issue where taking backup of a shared server was using server owner’s user name.
  • Issue #7262 - Fix an issue in editor where replace option in query tool edit menu is not working on non-Mac OS.
  • Issue #7268 - Fix an issue in editor where Format SQL shortcut and multiline selection are not working.
  • Issue #7269 - Fix an issue in editor where “Use Spaces?” Preference of Editor is not working.
  • Issue #7271 - Fixed an issue where Triggers, Rules, Indexes were absent from the Schema Diff when comparing views.
  • Issue #7277 - Fix an issue in query tool where toggle case of selected text loses selection.
  • Issue #7299 - Fix query tool autocomplete results when cursor is in between the SQL query.
  • Issue #7305 - Fix an issue in query tool where custom keyboard shortcuts are not working for some.
  • Issue #7304 - Fixed the issue where the update-user CLI command doesn’t change the password.
  • Issue #7308 - Fixed issue related to email authentication of Two-factor authentication.
  • Issue #7326 - Fixed a remote code execution issue in the validate binary path (CVE-2024-3116).

New in pgAdmin 4 8.4 (Mar 7, 2024)

  • New features:
  • Issue #6058 - Allow preferences customization using a configuration file.
  • Issue #7138 - Add support for JSON log format.
  • Issue #7204 - Add –yes option for skipping the confirmation prompt while deleting the user via CLI for scripting purpose.
  • Housekeeping:
  • Issue #7097 - Upgrade CodeMirror from version 5 to 6.
  • Issue #7148 - Added documentation for Dashboard’s System Statistics tab.
  • Issue #7187 - Separate the application name, branding & version information from the configuration file.
  • Issue #7234 - Upgrade python packages cryptography to 42.0.x and Flask-Security-Too to 5.3.x.
  • Bug fixes:
  • Issue #6792 - Fix multiple issues where PasswordExecCommand was not working in server mode and PasswordExecCommand was not loaded when importing servers.
  • Issue #6808 - Fix the tabbed panel backward/forward shortcut for tabs.
  • Issue #7027 - Fixed an issue where dependencies and dependents were not showing if a composite type is used as an attribute in another composite type.
  • Issue #7164 - Fix an issue where constraint check control is enabled in the edit table dialog.
  • Issue #7165 - Fix an issue where the scripts created by generate script of Schema diff for Table with sequence was not working earlier.
  • Issue #7193 - Ensure that the OAuth2 session is logged out when users log out from pgAdmin.
  • Issue #7217 - Remove role related checks on the UI dashboard when terminating session/query and let PostgreSQL take care of it.
  • Issue #7225 - Fix an issue where type column in dependents/dependencies tab is not showing correct label.
  • Issue #7258 - Unsafe Deserialization and Remote Code Execution by an Authenticated user in pgAdmin 4 (CVE-2024-2044).

New in pgAdmin 4 8.3 (Feb 9, 2024)

  • New features:
  • Issue #4419 - Allow drag-n-drop columns collection tree node as comma separated columns.
  • Issue #6380 - Added support to rename columns in Views.
  • Issue #6392 - Added BYPASSRLS|NOBYPASSRLS option while creating a Role.
  • Issue #6450 - Added support for column storage syntax while creating table.
  • Issue #6557 - Use COOKIE_DEFAULT_PATH or SCRIPT_NAME in session cookie path.
  • Issue #6792 - Added configurable parameter to enable support for PasswordExecCommand in server mode.
  • Bug fixes:
  • Issue #5083 - Fixed an issue where format sql was messing up operator. Included many other feature changes, more details here
  • Issue #6785 - Fixed an issue where formatting inserts empty lines in specific case.
  • Issue #7053 - Add support for selecting a schema in the backup database dialog with no tables, mviews, views or foreign tables.
  • Issue #7055 - Fixed a UI border issue on the dependencies tab for columns with icon.
  • Issue #7073 - Fixed an issue where multiple errors were showing if user does not have connect privileges.
  • Issue #7085 - Fixed an issue where group membership information was displayed incorrectly.
  • Issue #7113 - Ensure that the correct SQL is generated when changing the column data type to “char”.
  • Issue #7153 - Fixed an issue pgAdmin fails to launch due to inconsistent PATH variable name on windows.
  • Issue #7166 - Fix a backend server error when creating a named restore point.
  • Issue #7175 - Fix wrong default for FORCE_LOWER in the FLASK_GRAVATAR module.

New in pgAdmin 4 8.2 (Jan 11, 2024)

  • New features:
  • Issue #2483 - Administer pgAdmin Users and Preferences Using the Command Line Interface (CLI).
  • Issue #5908 - Allow users to convert View/Edit table into a Query tool to enable editing the SQL generated.
  • Issue #6085 - Added copy server support, allowing the duplication of existing servers with the option to make certain modifications.
  • Issue #7016 - Added keep-alive support for SSH sessions when connecting to a PostgreSQL server via an SSH tunnel.
  • Housekeeping:
  • Issue #6926 - Ensure that eventlet’s subprocess should be used following the resolution of an issue with Python 3.12 by eventlet.
  • Bug fixes:
  • Issue #6193 - Fixed an issue where query tool title did not change after “Save As” until any new change is made.
  • Issue #6781 - Fixed an issue where export servers was not adding extension if not specified.
  • Issue #6815 - Fixed an issue where pgAdmin imports servers to the wrong accounts for the external authentication.
  • Issue #7002 - Fixed an issue where an error occurred in the SQL tab when using an extended index(pgroonga).
  • Issue #7041 - Fixed an issue where changes done to a node using edit dialog are not reflecting on the properties tab if the properties tab is active.
  • Issue #7059 - Fixed an issue where DB Restrictions were not visible on the server dialog.
  • Issue #7061 - Ensure that the ‘Dbo’ schema is displayed as a regular schema rather than a system catalog schema.
  • Issue #7062 - Introduce LDAP configuration parameter LDAP_IGNORE_MALFORMED_SCHEMA to ignore fetching schema from the LDAP server.
  • Issue #7064 - Fixed an error-‘amname’ when generating ERD for database containing partition tables.
  • Issue #7066 - Fixed an issue where object explorer last tree state was not saving.
  • Issue #7070 - Fixed an issue where pgAgent job schedule dialog is not opening for edit.
  • Issue #7078 - Fixed an issue where user is not able to cancel or terminate active queries from dashboard.
  • Issue #7082 - Fixed browser autocomplete related issues on pgAdmin authentication related pages.
  • Issue #7091 - Fixed an issue where auto commit/rollback setting not persisting across query tool connection change.
  • Issue #7104 - Fixed an issue where Schema Diff not generating difference for missing columns.

New in pgAdmin 4 8.1 (Dec 14, 2023)

  • New features:
  • Issue #4580 - Add support for generating ERD for a schema.
  • Issue #6854 - Add support for creating a function with custom return type.
  • Housekeeping:
  • Issue #6991 - Fixed several accessibility-related issues for enhanced usability.
  • Bug fixes:
  • Issue #5471 - Ensure focus is not changed to ssh tunnel password input when user explicitly focus on server password input.
  • Issue #6095 - Provide a way to bypass the SSL cert verification for OAuth2 provider.
  • Issue #6488 - Fixed an issue where database name was missing in an error message if name contains any special characters.
  • Issue #6717 - Ensure that indexes created by constraints are visible in the object explorer when “Show system objects” is enabled.
  • Issue #6803 - Fixed an issue where reading process logs throws an error when DATA_DIR is moved to a networked drive.
  • Issue #6814 - Remove the ‘Close Window’ submenu specifically for OSX to prevent unintended closure of the entire application.
  • Issue #6842 - Rename all references of ‘Execute query’ to ‘Execute script’ to be more relevant.
  • Issue #6887 - Fixed an issue where syntax error was not highlighting in query tool.
  • Issue #6921 - Fixed an issue where on entering full screen, the option label is not changed to ‘Exit Full Screen’ in desktop mode.
  • Issue #6950 - Ensure that the Authentication Source in the drop-down of the UserManagement dialog aligns with the entries specified for AUTHENTICATION_SOURCES in the configuration file.
  • Issue #6958 - Reverse engineer serial columns when generating ERD for database/table.
  • Issue #6964 - Fixed an issue where the Schema was not visible in the dropdown for table properties or when creating a new table.
  • Issue #6968 - Fixed an issue where option key was not registering in PSQL tool.
  • Issue #6984 - Fixed an issue where the Vacuum option INDEX_CLEANUP have an incorrect value (‘AUTO’) for database versions < 14.
  • Issue #6989 - Fixed an issue where the pgAdmin page went blank when clicking the delete button in the User Management dialog.
  • Issue #7000 - Ensure that correct timezone is set for Docker deployments.
  • Issue #7011 - Fixed an issue where all rows and filter rows buttons of object explorer toolbar were disabled for views and other supported nodes.
  • Issue #7017 - Fixed an issue where schema diff tool is not loading preferences on start.

New in pgAdmin 4 8.0 (Nov 25, 2023)

  • New features:
  • Issue #2821 - Have close buttons on individual panel tabs instead of common.
  • Issue #4733 - Allow closing all the tabs, including SQL and Properties.
  • Issue #5394 - Changes in the context menu on panel tabs - Add close, close all and close others menu items.
  • Housekeeping:
  • Issue #6441 - Update app bundle built to use notarytool instead of altool.
  • Issue #6479 - Replace the current layout library wcDocker with ReactJS based rc-dock.
  • Issue #6850 - Upgrade Flask, Werkzeug and other modules depends on the latest version of Flask.
  • Bug fixes:
  • Issue #2986 - Fix an issue where the scroll position of panels was not remembered on Firefox.
  • Issue #5770 - Add DROP SQL for foreign keys in SQL generated by ERD when using WITH DROP option.
  • Issue #5807 - Fixed an issue where psql was not taking the role used to connect in server properties.
  • Issue #6017 - Fixed an issue where Geometry Viewer renders geometry incorrectly after trying to view 3D or non-4326 SRID geometry.
  • Issue #6459 - Fix the sorting of size on the statistics panel.
  • Issue #6487 - Fixed restoration of query tool database connection after dropping and re-creating the database with the same name.
  • Issue #6602 - Fix an issue where the default server-group is being deleted if the load-server json file contains no servers.
  • Issue #6720 - Fix an issue of the incorrect format (no indent) of SQL stored functions/procedures.
  • Issue #6769 - Server config information in the about dialog should be only visible to admin users.
  • Issue #6784 - Fixed an issue where Schema Diff does not work when the user language is set to any language other than English in Preferences.
  • Issue #6817 - Fixed the query generated when creating subscription where copy_data parameter was missing.
  • Issue #6820 - Ensure backup/restore/maintenance works with invalid pgpass file parameter.
  • Issue #6835 - Fix an issue where OAUTH_ADDITIONAL_CLAIMS does not recognise AzureAD with > 150 groups.
  • Issue #6840 - Fixed circular import error occurring while deploying cloud PostgreSQL instance from pgAdmin.
  • Issue #6874 - Fix an issue where the browser window stuck on spinning with an Oauth user without email.
  • Issue #6875 - Fix an issue where import/export data is not working for shared servers.
  • Issue #6877 - Remove the max length of 255 from password exec command in server configuration dialog.
  • Issue #6884 - Remove gettext from empty strings in the title of the storage graph.
  • Issue #6902 - Fixed an issue where the change server password is not working in desktop mode.
  • Issue #6904 - Fix a crash issue occurring when debugging a function with arguments when using pgAdmin with external config database.
  • Issue #6920 - Fix an issue in ERD tool where SQL generated is missing columns for the table.
  • Issue #6934 - Clear the password field in the config database on clear saved server password.
  • Issue #6962 - Fixed an issue where the data type of the array type was not visible for the column in the Foreign Table dialog.

New in pgAdmin 4 7.8 (Oct 19, 2023)

  • New features:
  • Issue #640 - Add support for foreign table’s new functionality for PG 11 and above.
  • Issue #6229 - Allow setting custom username for shared servers, with default as username of server being shared.
  • Issue #6373 - Add ‘GENERATED ALWAYS AS..’ option while creating column constraints for Foreign Table.
  • Issue #6797 - GUI representation of the system’s activity using the ‘system_stats’ extension.
  • Issue #6802 - Added ‘load_balance_hosts’ connection string parameter for PG 16 and above.
  • Housekeeping:
  • Issue #6782 - Use PG16 as the default PostgreSQL version.
  • Bug fixes:
  • Issue #4995 - Fixed an issue in ERD tool where the downloaded images have a few links cut.
  • Issue #5749 - Fixed an issue where user was not able to assign new/old columns as primary key once column with primary key is deleted.
  • Issue #6285 - Add support for setting prepare threshold in server connection.
  • Issue #6482 - Fixed an issue where the wrong message “Current database has been moved or renamed” is displayed when debugging any function.
  • Issue #6538 - Fixed an issue where Processes tab displays wrong server name in some scenario.
  • Issue #6579 - Fix an issue where global/native keyboard shortcuts are not working when any cell of data output grid has focus.
  • Issue #6666 - Fixed query history slowness issue by storing query only for those having certain threshold max length.
  • Issue #6674 - Fix an issue where foreign table column name becomes “none” if the user changes any column data type.
  • Issue #6718 - Pin the cryptography version to fix PyO3 modules initialisation error.
  • Issue #6790 - Ensure that the backup works properly for PG 16 on the latest docker image.
  • Issue #6799 - Fixed an issue where the user is unable to select objects on the backup dialog due to tree flickering.
  • Issue #6836 - Fixed an issue where non-super PostgreSQL users are not able to terminate their own connections from dashboard.
  • Issue #6851 - Fix an issue where scale in columns is not allowed to have value as 0 or below.
  • Issue #6858 - 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.
  • Issue #6865 - Fix an issue where user login is not working if username/email contains single quote in server mode.

New in pgAdmin 4 7.7 (Sep 22, 2023)

  • New features:
  • Issue #642 - Added support to select/deselect objects in the Backup dialog.
  • Issue #4805 - Added all the new options of the ‘WITH’ clause in the subscription dialog.
  • Issue #6378 - Added USING method while creating the table.
  • Issue #6379 - Added compression method option while creating a column.
  • Issue #6383 - Added Strategy, Locale Provider, ICU Locale, ICU Rules, and OID options while creating a database.
  • Issue #6400 - Added USING method while creating the materialized view.
  • Issue #6736 - Add support for additional ID token claim checks for OAuth 2 authentication.
  • Housekeeping:
  • Issue #2411 - Added the ‘data type’ column in the properties tab of the Columns collection node.
  • Bug fixes:
  • Issue #6274 - Fix an issue where user is not able to change the password when SMTP is not configured.
  • Issue #6704 - Ensure user is redirected to login page after failed login.
  • Issue #6712 - Ensure that Materialized view size fields in “Statistics” should be human-readable.
  • Issue #6730 - Fix an issue where changing the password shows success but the new password is not working.
  • Issue #6738 - Fix an issue where login form doesn’t appear if internal auth source is removed.
  • Issue #6764 - Fix a security related issue where an authenticated user can run remote command using validate binary path API (CVE-2023-5002).

New in pgAdmin 4 7.6 (Aug 24, 2023)

  • New features:
  • Issue #2595 - Added Expression to CREATE INDEX.
  • Issue #3942 - Added cascade option while creating an extension.
  • Issue #5759 - Added ‘Ignore Grants’ option in the schema diff tool.
  • Issue #6004 - Added ‘Ignore Tablespace’ option in the schema diff tool.
  • Issue #6375 - Added support for ALTER INDEX column statistics.
  • Issue #6376 - Added unlogged option while creating a sequence.
  • Issue #6377 - Added all like options while creating a table.
  • Issue #6381 - Added support for SYSTEM, CONCURRENTLY and TABLESPACE options in REINDEX.
  • Issue #6382 - Added WAL option to EXPLAIN ANALYZE command.
  • Issue #6397 - Added new/missing options to the VACUUM command.
  • Issue #6415 - Added SKIP_LOCKED and BUFFER_USAGE_LIMIT option to Analyze command.
  • Issue #6448 - Add support for TRUNCATE trigger in foreign table.
  • Issue #6595 - Ensure that Schema Diff comparison results should be displayed in the sorted order.
  • Housekeeping:
  • Issue #3702 - Generate software bill of materials as part of the package builds.
  • Issue #6588 - Added support for PostgreSQL and EPAS 16 to ensure it works without any errors.
  • Bug fixes:
  • Issue #5454 - Fix incorrect redirection URL after authentication by removing fixed value set to SCRIPT_NAME environment variable in pgAdmin4.wsgi file.
  • Issue #6208 - Allow changing the POOL_SIZE and MAX_OVERFLOW config values of the pgAdmin config DB connection pool.
  • Issue #6252 - Fix an issue where query tool on shared server is throwing error if the pgAdmin config DB is external.
  • Issue #6420 - Fix the query tool issue where raise Notice from func/proc or code blocks are no longer displayed live.
  • Issue #6500 - Fix the issue where query tool window turns blank if the user tries to generate a graph on the result.
  • Issue #6624 - Fix an issue where changing MFA_SUPPORTED_METHODS breaks the MFA validation.
  • Issue #6630 - Fix an issue where pgAdmin 7.5 fails to render table SQL with extension loaded index method.
  • Issue #6639 - Fix an issue where cycle syntax was not added in SQL when creating new sequence from UI.
  • Issue #6651 - Fix an issue where the SET directive is excluded from the function header in the schema diff tool.
  • Issue #6660 - Fix a query tool error ‘pgAdminThread’ object has no attribute ‘native_id’.
  • Issue #6664 - Ensure keyboard shortcut for query execution is disabled when query execution is in progress.

New in pgAdmin 4 7.5 (Jul 27, 2023)

  • New features:
  • Issue #6369 - Added support to detach partitions using concurrently and finalize.
  • Issue #6374 - Added all supported index storage parameters while creating an index.
  • Issue #6416 - Added new/missing parameters to pg_dumpall (Backup Server).
  • Issue #6417 - Added new/missing parameters to pg_dump (Backup Objects).
  • Issue #6562 - Added new/missing parameters to pg_restore.
  • Housekeeping:
  • Issue #6295 - Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS.
  • Issue #6323 - Enable cluster deployment with gp3 volume for AWS & BigAnimal cloud providers.
  • Issue #6423 - Clarify the LICENSE file to indicate that it is the PostgreSQL Licence.
  • Issue #6532 - Remove unsupported PostgreSQL versions from the container.
  • Bug fixes:
  • Issue #6163 - Fix an issue where queries can’t complete execution.
  • Issue #6165 - Fixed an issue where Import Export not working when using pgpassfile.
  • Issue #6317 - Fix an issue where queries longer than 1 minute get stuck - Container 7.1
  • Issue #6356 - Fix an issue where queries get stuck with auto-completion enabled.
  • Issue #6364 - Fixed Query Tool/ PSQL tool tab title not getting updated on database rename.
  • Issue #6406 - Ensure user gets proper error if incorrect credentials are entered while authenticating AWS.
  • Issue #6489 - Fix an issue where the edit server fails in desktop mode if the server password is not stored.
  • Issue #6499 - Ensure that Backup, Restore, and Maintenance should work properly when pgpass file is used.
  • Issue #6501 - Fix the query tool auto-complete issue on the server reconnection.
  • Issue #6502 - Fix the query tool restore connection issue.
  • Issue #6509 - Fix the reconnecton issue if the PostgreSQL server is restarted from the backend.
  • Issue #6514 - Fix the connection and stability issues since v7, possibly related to background schema changes.
  • Issue #6515 - Fixed an issue where the query tool is unable to execute a query on Postgres 10 and below versions.
  • Issue #6524 - Fix the lost connection error in v7.4.
  • Issue #6531 - Fixed an issue where pgAdmin failed to setup role with hyphens in name.
  • Issue #6537 - Fixed an issue where filters are not working and query history shows empty queries.
  • Issue #6544 - Fix an issue where adding a sub-folder inside a folder is not working as expected in File Manager.
  • Issue #6556 - Fix an error ‘list’ object has no attribute ‘strip’ while attempting to populate auto-complete manually the first time.
  • Issue #6558 - Fixed an issue where ERD Tool can’t load the saved pgerd file from Shared Storage.
  • Issue #6582 - Fix an issue where inserting more than 10 rows does not work correctly in View Data; only parts end up in the table.

New in pgAdmin 4 7.4 (Jun 29, 2023)

  • New features:
  • Issue #6367 - Added support to drop databases using the ‘WITH (FORCE)’ option.
  • Issue #6368 - Add “[ NULLS [ NOT ] DISTINCT ]” option while creating an Index.
  • Issue #6370 - Added ‘OR REPLACE’ clause while creating trigger.
  • Issue #6371 - Added security_invoker option while creating a view.
  • Bug fixes:
  • Issue #5306 - Fix an issue where object explorer tree crashes occasionally.
  • Issue #6065 - Ensure that query tool shortcuts are working properly.
  • Issue #6258 - Add Password exec command and Expiration time to server export JSON and also allow them to import.
  • Issue #6266 - When opening pgAdmin the layout should be auto reset if it is corrupted. Reset layout menu should work if layout is corrupted while using pgAdmin.
  • Issue #6291 - Fix an issue where loading more rows indicator will not disappear if connection is lost.
  • Issue #6340 - Fix an encoding error when connecting through Pgbouncer.
  • Issue #6352 - Fix an issue where explain plan details is showing HTML escaped characters.
  • Issue #6354 - Fixed an issue where queries with temporary tables in the same transaction is not working.
  • Issue #6363 - Fixed an issue where preview images for themes were not loading.
  • Issue #6420 - Fix raise notice from func/proc or code blocks are no longer displayed live.
  • Issue #6431 - Fix an issue where PSQL is not working if the database name have quotes or double quotes.
  • Issue #6435 - Fix an issue where all the menus are enabled when pgAdmin is opened and no object is selected in the object explorer.

New in pgAdmin 4 7.3 (Jun 7, 2023)

  • Bug fixes:
  • Issue #6136 - Fix an issue where editing a database object de-selects it on the browser tree.
  • Issue #6341 - Ensure that SSH Tunnel should work properly after upgrading to 7.2 from 7.1
  • Issue #6342 - Fixed an issue where pgadmin is unable to take the defined role.
  • Issue #6345 - Fixed an issue where Foreign Key with 3 or more columns are shown in the wrong order in SQL and Properties.
  • Issue #6353 - Ensure that the master password dialog should not be visible if the parameter MASTER_PASSWORD_REQUIRED is set to False.

New in pgAdmin 4 7.2 (Jun 2, 2023)

  • New features:
  • Issue #3831 - Add Option to only show active connections on Dashboard.
  • Issue #4769 - Allow pgAdmin to retrive master password from external script/program.
  • Issue #5048 - Add an option to hide/show empty object collection nodes.
  • Issue #5123 - Added support to use standard OS secret store to save server/ssh tunnel passwords instead of master password in pgAdmin desktop mode.
  • Issue #5868 - Implement new PostgreSQL 15 features in publication dialog and SQL.
  • Housekeeping:
  • Bug fixes:
  • Issue #5789 - Fixed an issue where Foreign Key columns are shown in the wrong order in SQL and Properties.
  • Issue #5817 - Ensure that a new row should be added on top in the User Management dialog.
  • Issue #5926 - Fixed an issue where REVOKE ALL DDL in table SQL was added only for one role.
  • Issue #6003 - Indicate the user if all the server’s children nodes are hidden from the preferences setting.
  • Issue #6026 - Tools menu should be toggled for “pause replay of wal” and “resume replay of wal”.
  • Issue #6043 - Make the ‘Connect to server’ dialog a modal dialog.
  • Issue #6080 - pgAdmin icon not showing on taskbar on Windows 10.
  • Issue #6127 - Fixed an issue where properties were not visible for FTS Parsers, FTS Templates, MViews, and Rules in Catalog objects.
  • Issue #6147 - Heartbeat is getting logged, though no server is connected in pgAdmin.
  • Issue #6204 - Ensure that name can’t be empty in edit mode for Primary Key and Index.
  • Issue #6221 - Fix circular reference error for the multirange data types in the query tool.
  • Issue #6247 - Fixed an issue where PSQL tool prompts for password if using password exec command.
  • Issue #6253 - Fix an issue in the register server when setting the role, an arbitrary SQL query can be fired.
  • Issue #6267 - Ensure the user is able to log in if the specified OAUTH2_USERNAME_CLAIM is present in the OAuth2 profile.
  • Issue #6278 - Use dependent instead of dependant in the message.
  • Issue #6279 - Fix incorrect number of foreign tables displayed. Show column comments in RE-SQL.
  • Issue #6280 - View SQL tab not quoting column comments.
  • Issue #6281 - VarChar Field Sizes are missing from Query’s Grid header.
  • Issue #6331 - Separate multiple Blocking PIDs with delimiter on Dashboard.

New in pgAdmin 4 7.1 (May 5, 2023)

  • Supported Database Servers:
  • PostgreSQL: 11, 12, 13, 14 and 15
  • EDB Advanced Server: 11, 12, 13, 14 and 15
  • Bundled PostgreSQL Utilities:
  • psql, pg_dump, pg_dumpall, pg_restore: 15.2
  • New features:
  • Issue #2078 - Show object breadcrumbs path along with its comment on object hover.
  • Issue #3275 - Allow on demand record count setting to be changed per user using preferences.
  • Issue #3316 - Added support to show statistics for materialized views.
  • Issue #3318 - Added support to create an unnamed index.
  • Housekeeping:
  • Bug fixes:
  • Issue #5044 - Fixed an issue where query tool hangs for some time when multiple columns are selected to open geometry viewer.
  • Issue #5777 - Fixed an issue where the browser tree state is not remembered when reopening pgAdmin.
  • Issue #5820 - Fixed an issue where collation was set to none if we remove it while creating partitioned table.
  • Issue #5922 - Ensure that when pasting a row in query tool grid, default value is used for autogenerated/serial columns.
  • Issue #6059 - Show proper message if the debugger is stopped by the user.
  • Issue #6075 - Ensure that the save button is enabled when registering a new server fails due to an API error.
  • Issue #6077 - The search object, query tool, and psql tool menu should not be displayed for pgAgent.
  • Issue #6120 - Fixed error occurring while logging out from pgAdmin keeping a query tool opened.
  • Issue #6128 - Fix a SQL error occurring on roles dependents SQL.
  • Issue #6130 - Ensure to quote the primary key value if needed while deleting rows from the table.
  • Issue #6137 - Fixed error occurring while dumping the servers from CLI.
  • Issue #6138 - Throw an appropriate error when a table for which View/Edit data is open, is deleted, and query is executed.
  • Issue #6151 - Ensure that internal users are able to login when auth sources are [ldap, internal].
  • Issue #6158 - Fixed an issue with the properties tab not getting updated if the user updates the selected node.
  • Issue #6159 - Ensure that the ERD tool should work with the external database after moving to psycopg3.
  • Issue #6180 - Fixed an issue where PSQL is not working if the PGUSER env variable is set and service file is used for server connection details.
  • Issue #6183 - Mac crash when you press Command-Shift-C.
  • Issue #6189 - Fix an issue in View SQL when column level privileges are set with multiple roles.
  • Issue #6191 - Fixed an issue where Reset Password is not working after upgrading to latest flask-security-too.
  • Issue #6234 - Usernames/roles with special character are not double quoted when assigning privileges.

New in pgAdmin 4 7.0 (Apr 15, 2023)

  • New features:
  • Issue #3298 - Auto expand row edit form when a new row is added for Primary Key, Foreign Key, Unique Constraint and Exclusion Constraint.
  • Issue #5014 - Added support for mounting shared storage in server mode.
  • Issue #5022 - Add a note on top of keyboard shortcuts preferences to show the Accesskey of the browser.
  • Issue #5750 - Added capability to deploy PostgreSQL servers on Google Cloud.
  • Issue #5805 - Added support of BigAnimal v3 API.
  • Issue #5854 - On pressing Ctrl+C on a tree object, copy the fully qualified name to clipboard.
  • Issue #5855 - Added option to create unique constraint with nulls not distinct.
  • Housekeeping:
  • Issue #4734 - Rename the “Properties…” context menu option of the objects to “Edit Object…” and the “Browser” tree to “Object Explorer”.
  • Issue #5011 - Upgrade from psycopg2 to psycopg3.
  • Issue #5701 - Remove Bootstrap and jQuery usage.
  • Issue #5830 - Add .ts and .tsx files under linter and fix linter issues.
  • Issue #5901 - Update SQLAlchemy, Flask, Flask-SQLAlchemy, and other packages to current versions.
  • Bug fixes:
  • Issue #4423 - Fixed an issue where list of tables is not displayed in a SQL_ASCII database.
  • Issue #4784 - Handle errors occurring during decoding UTF-8 encoded query result data which contains ascii characters.
  • Issue #4884 - Fixed an issue where it is not possible to import csv data to tables having columns with german umlauts in their name.
  • Issue #4891 - Fixed ‘rawunicodeescape’ codec can’t decode issue in a SQL_ASCII database.
  • Issue #5504 - Fixed an issue where incorrect view of text[] fields in query and table results when use other then UTF8 (win1251) codepage and symbols.
  • Issue #5735 - Show appropriate error message when master password is not set instead of ‘Crypt key missing’.
  • Issue #5775 - Display the ‘No menu available for this object’ message if the selected tree node does not have any options.
  • Issue #5824 - 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.
  • Issue #5833 - Fixed an issue where user MFA entry was not getting delete after deleting a user.
  • Issue #5834 - Fixed issue where pgAgent jobs were not getting dropped from properties tab.
  • Issue #5874 - Make “using” and “with check” fields a textarea in the RLS policy.
  • Issue #5894 - Use fetch instead of axios to close connections in SQLEditor, ERD, Schema Diff and Debugger to ensure it completes.
  • Issue #5904 - Fixed an issue where the count query should not be triggered when the estimated count is less than zero.
  • Issue #5907 - Validate user inputs provided in configuration files before starting pgadmin server.
  • Issue #5916 - Fix an issue in search objects where objects were unable to locate occasionally.
  • Issue #5919 - While restoring the database connections due to lost server connection, ensure that the databases which were previously connected are only reconnected.
  • Issue #5921 - Ensure that when pasting rows the rows are added right below the selected rows for copying.
  • Issue #5929 - Dashboard graph Y-axis width should increase with label.
  • Issue #5934 - Ensure that default values are set only for insert statement if user does not provide any values, in case of updating existing values to blank it should be set to null.
  • Issue #5941 - Fixed an issue where migration on external database is not working.
  • Issue #5943 - Use http for SVG namespace URLs which were changed to https for SonarQube fixes.
  • Issue #5952 - Ensure that the schema diff tool should not allow comparison between Postgres Server and EDB Postgres Advanced Server.
  • Issue #5953 - Fixed error while executing continue in debugging session after some time of debug execution.
  • Issue #5955 - Fix an issue where query tool is stuck when running query after discarding changed data.
  • Issue #5958 - Fix an issue where new dashboard graphs are partially following theme colors.
  • Issue #5959 - Fix an issue where Backup, Restore, and Maintenance not working if connection timeout is set in the server dialog.
  • Issue #6018 - Change the foreground color of the code mirror text for Dark Theme.
  • Issue #6093 - Fix the dependents SQL of Roles which is throwing a type casting error on PostgreSQL 15.
  • Issue #6100 - Fixed the LDAP authentication issue for the simultaneous login attempts.(CVE-2023-1907)
  • Issue #6109 - Fixed asyncio random task error messages in Query tool.
  • Issue #6122 - Fixed CSV export from Query Tool results does not include all columns for multiple CTEs.

New in pgAdmin 4 6.21 (Mar 9, 2023)

  • New features:
  • Issue #5832 - Allow changing cardinality notation in ERD to use Chen notation.
  • Issue #5842 - Add additional logging for successful logins and user creation.
  • Housekeeping:
  • Bug fixes:
  • Issue #5269 - Ensure that the schema diff tool should pick up the change in the column grants.
  • Issue #5685 - Ensure that Grant column permission to a view is visible in the SQL tab.
  • Issue #5747 - Ensure that content on the DDL comparison panel should get refreshed on selecting the object using the up and down arrow keys.
  • Issue #5756 - Fix for query tool prompting for unsaved changes even if no changes have been made.
  • Issue #5758 - Fixed an issue where lock layout menu was not in sync with preferences.
  • Issue #5760 - Fixed an issue where query was not pasted to editor after trojan source warning.
  • Issue #5764 - Fix an issue where the maintenance dialog for Materialized View gives an error.
  • Issue #5773 - Fixed an issue where Clear Saved Password should be disabled if the password is already cleared.
  • Issue #5790 - Fixed an issue where the user can’t create trigger AFTER UPDATE OF.
  • Issue #5803 - Fix an issue where query tool is stripping spaces in grid cell.
  • Issue #5810 - Fix an issue where sequence owner is remove on sequence edit.
  • Issue #5822 - Do not allow to save invalid JSON in query tool JSON editor.
  • Issue #5847 - Fixed an issue where pgAdmin failed to connect when the Postgres password included special characters.
  • Issue #5870 - Ensure that the database migration does not fail with a NoSuchTableError exception.
  • Issue #5872 - Handle MERGE operation in query tool explain introduced in PostgreSQL 15.
  • Issue #5889 - Fixed an issue where the database server is not connected using a service file.
  • Issue #5909 - Fixed an issue where the file name in the query tool tab was not changing if another file is opened.

New in pgAdmin 4 6.20 (Feb 9, 2023)

  • New features:
  • Issue #4728 - Added support for setting PostgreSQL connection parameters.
  • Housekeeping:
  • Issue #4320 - Added bundled PG utilities in the release note.
  • Issue #5525 - Upgrade Flask-Migrate to 4.x.
  • Issue #5723 - Improve performance by removing signal-based zoom-in, zoom-out, etc functionality from the runtime environment.
  • Issue #5794 - Use uplot for Dashboard graphs to reduce CPU usage.
  • Bug fixes:
  • Issue #5532 - Fixed an issue where the client cert location was not stored on the shared servers.
  • Issue #5567 - Fix orphan database connections resulting in an inability to connect to databases.
  • Issue #5702 - Fix an issue where role is used as username for newly added servers when opening query tool.
  • Issue #5705 - Ensure that all parts of the application recommend and enforce the same length of passwords.
  • Issue #5732 - Fixed an issue where Kerberos authentication to the server is not imported/exported.
  • Issue #5733 - Ensure that the system columns should not visible in the import/export data.
  • Issue #5746 - Increase the length of the value column of the setting table.
  • Issue #5748 - Fixed console error while attaching the partition.
  • Issue #5751 - Fix failing import servers CLI due to vulnerability fix.
  • Issue #5761 - Fix an issue where drag and drop object names is not working.
  • Issue #5763 - Ensure that keyboard hotkey to open query tool and search object should work properly.
  • Issue #5781 - Fixed an issue where Query history is not getting loaded with external database.
  • Issue #5796 - Ensure nested menu items are shown in quick search result.

New in pgAdmin 4 6.19 (Jan 17, 2023)

  • New features:
  • Issue #5569 - Added support of AWS provider for BigAnimal cloud deployment.
  • Housekeeping:
  • Issue #5563 - Allow YouTube video demo links to be added to appropriate pgAdmin documentation.
  • Issue #5615 - Rewrite pgAdmin main menu bar to use React.
  • Bug fixes:
  • Issue #5487 - Fixed an issue where incorrect password used with shared server.
  • Issue #5541 - Ensure the browser tree does not freeze while rendering 10k+ nodes/objects.
  • Issue #5542 - Fixed an issue updating the schema node de-select the node in the tree if only one schema is present in the collection node.
  • Issue #5559 - Fixed tree flickering issue on scroll.
  • Issue #5577 - Fixed an issue where the default value of string for columns should wrap in quotes in the create script.
  • Issue #5586 - Fix the webserver and internal authentication setup issue.
  • Issue #5613 - Ensure the appbundle has correct permissions so that pgAdmin can be accessed by users other than owner.
  • Issue #5622 - Fixed an issue where the ignore owner flag is not working for some cases in the Schema Diff.
  • Issue #5626 - Fixed an issue where actions performed on the tree node should update the context menu options.
  • Issue #5627 - Ensure that the submenus under the trigger’s context menu are enabled/disabled correctly.
  • Issue #5640 - Update boto3 & botocore to the latest version.
  • Issue #5641 - Fixed an issue where Geometry viewer does not show popup when columns are less than 3.
  • Issue #5647 - Fixed an issue where row count notification was disappearing automatically.
  • Issue #5661 - Fix select dropdown border issue.
  • Issue #5666 - Fixed a missing “jwks_uri” in metadata error that occurred when logging in with an oAuth2 provider like Azure or Google.
  • Issue #5675 - Fixed an issue where rename panel was losing focus when trying to add name if input box is empty.
  • Issue #5734 - Ensure that the authenticated users can’t access each other’s directories and files by providing relative paths.(CVE-2023-0241)

New in pgAdmin 4 6.18 (Dec 20, 2022)

  • New features:
  • Issue #4088 - Enhancements to the ERD when selecting a relationship.
  • Issue #5503 - Added native menu support in desktop mode.
  • Bug fixes:
  • Issue #5453 - Fixed an issue where Transaction IDs were not found in session in the Query Tool.
  • Issue #5470 - Fixed an issue where tablespace was missing on partition tables in SQL.
  • Issue #5536 - Fixed an issue where properties tab was refreshing on tab change even if the selected node is same.
  • Issue #5551 - Fixed an issue with auto-complete not working as expected with double quotes.
  • Issue #5564 - Ensure that table statistics are sorted by size.
  • Issue #5598 - Fixed an issue while updating server node info removes the clear saved password menu.
  • Issue #5603 - Fixed an issue where master password was not set correctly with external config database.
  • Issue #5606 - Fixed an error in the collation create script for PG-15.
  • Issue #5629 - Fixed BigAnimal authentication aborted issue.
  • Issue #5637 - Ensure that the BigAnimal displays PG version 11-14 for Oracle compatible databases type.
  • Issue #5645 - Fixed a typo.

New in pgAdmin 4 6.17 (Dec 2, 2022)

  • Housekeeping:
  • Issue #5147 - Update the BigAnimal API version to V2.
  • Issue #5493 - Remove all traces of Backbone and Underscore.
  • Bug fixes:
  • Issue #5488 - Fixed an issue where the wrong schema is displayed for a foreign key in the schema diff tool.
  • Issue #5495 - Ensure that the query history date format in Desktop mode matches the format of the locale of the pgadmin server.
  • Issue #5505 - Fixed an issue where the CSV file would not download if the CSV quote character length exceeded 1.
  • Issue #5513 - Ensure that DATA_DIR dependent folders/files are automatically created inside the specified DATA_DIR if they are not specified separately in the configuration file.
  • Issue #5539 - Improved error message to make it easier for users to understand.
  • Issue #5548 - Fixed an issue where editor position was wrong when editing data from result grid.
  • Issue #5575 - Ensure the query tool is launched successfully for the servers registered with the PostgreSQL service.
  • Issue #5593 - Ensure that only authorized and authenticated users can validate binary paths (CVE-2022-4223).

New in pgAdmin 4 6.16 (Dec 2, 2022)

  • New features:
  • Issue #1832 - Added support for storing configurations of pgAdmin in an external database.
  • Issue #4756 - Added the ability to generate ERDs for tables.
  • Issue #5468 - Add the possibility to configure the Oauth2 claim which is used for the pgAdmin username.
  • Bug fixes:
  • Issue #2174 - Ensure that the browser tree should auto scroll to the selected node when expanding the server node.
  • Issue #4841 - Use SocketIO instead of REST for schema diff compare.
  • Issue #5066 - Ensure that users can use custom characters as CSV field separators/CSV quotes when downloading query results.
  • Issue #5058 - Ensure that the save button should be disabled by default on the Sort/Filter dialog in the query tool.
  • Issue #5098 - Fix an issue where the save button is enabled when the table properties dialog is opened.
  • Issue #5122 - Ensure that the spinner should be visible on the browser tree on node refresh.
  • Issue #5149 - Ensure the Generate ERD option is hidden if the connection to the database is not allowed.
  • Issue #5206 - Reposition the select dropdown when the browser is resized.
  • Issue #5281 - Ensure that autocomplete works properly with objects starting with double quotes.
  • Issue #5344 - Ensure that pgAdmin routes should have the SCRIPT_NAME prefix.
  • Issue #5424 - Ensure that the appropriate permissions are set on the key file before trying an SSL connection with the server in server mode.
  • Issue #5429 - Fixed an issue where parameters for roles were not visible.
  • Issue #5452 - The container deployment document should include the server.json file format.
  • Issue #5455 - Fixed an issue where the dependents tab wasn’t working for PG 15.
  • Issue #5458 - Ensure that the browser path column in the search object shows the complete path.
  • Issue #5463 - Fixed an issue where the result grid was not working properly while trying to edit data by hitting Enter key.
  • Issue #5465 - Fixed an issue where the screen was freezing while closing the wcDocker panel.
  • Issue #5473 - Fixed an issue where AutoComplete was not working correctly due to incorrect regex.
  • Issue #5475 - Fixed an issue where the ‘Confirm on close or refresh’ setting was ignored when closing the query/ERD tool opened in the new tab.
  • Issue #5507 - Fixed an issue where pgadmin does not respect reverse proxy any more.
  • Issue #5521 - Fixed SocketIO calls when pgAdmin 4 server is running from a sub directory.
  • Issue #5522 - Ensure that the load file paths are children of the storage directory.
  • Issue #5533 - Use the shared server username when opening query tool.
  • Issue #5535 - Fixed an issue where the ‘save_password’ column threw an error for the shared server when using an external database.
  • Issue #5537 - Ensure that the correct error message in ERD for permission denied should be shown.

New in pgAdmin 4 6.15 (Oct 20, 2022)

  • New features:
  • Issue #3491 - Added support for IAM token based authentication for AWS RDS or Azure DB.
  • Issue #4392 - Added support to specify the background fill color to the table nodes in the ERD tool.
  • Issue #4994 - Allow reordering table columns using drag and drop in ERD Tool.
  • Issue #4997 - Add option to generate SQL with DROP table DDL in ERD Tool.
  • Issue #5304 - Added high availability options to AWS deployment.
  • Issue #5390 - Expose the Gunicorn limit_request_line parameter in the container, with the default set to the maximum 8190.
  • Housekeeping:
  • Issue #5065 - Use SocketIO instead of REST for fetching database tables data in ERD.
  • Issue #5293 - Ensure that the tooltips are consistent throughout the entire application.
  • Issue #5357 - Remove Python’s ‘Six’ package completely.
  • Bug fixes:
  • Issue #5101 - Ensure consistent orderings for ACLS when comparing schemas in the schema diff.
  • Issue #5132 - Ensure that the result grid column should take width as pre preferences setting on first execution.
  • Issue #5133 - Fixed an exception occur while taking backup and SSL certificates/keys are not found in the specified path.
  • Issue #5145 - Fixed intermittent error shown while OAuth2 login.
  • Issue #5167 - Ensure that the path to the psqlrc file is correct when multiple users open the PSQL tool at the same time.
  • Issue #5188 - Ensure that the continue/start button should be disabled if the user stops the Debugger for the procedures.
  • Issue #5210 - Ensure that the query tool creates a new tab with the appropriate user when pressing Alt+Shift+Q.
  • Issue #5212 - Added the close button for all the notifications of the notistack.
  • Issue #5249 - Added the ability to display the selected text from the query tool in the find/replace box.
  • Issue #5261 - Ensure that the search filter should be cleared when a new row is added to the user management.
  • Issue #5262 - Ensure that the user management dialog should not allow the same email addresses with different letter casings when creating users.
  • Issue #5277 - Fixed XSS vulnerability issues.
  • Issue #5296 - Ensure that the scroll position should be preserved for the result set in the query tool on tab change.
  • Issue #5308 - Ensure that the default value for a column should be used if it is made empty.
  • Issue #5327 - Fixed an issue where user was unable to select privileges in Safari.
  • Issue #5332 - Fixed console warning shown while updating database node from browser tree.
  • Issue #5338 - Fixed an issue where the prompt is not visible when clicking on the ‘save results to file’ button on the large data.
  • Issue #5352 - Fixed error occurring while LDAP authentication for a user with multiple email attributes.
  • Issue #5364 - Fixed an issue where notifications disappeared quickly.
  • Issue #5367 - Ensure that the correct value should be returned if an exception occurs while decoding the password.
  • Issue #5368 - Fixed the issue while downloading the file from the file manager.
  • Issue #5386 - Ensure that the login form is hidden if the authentication source is OAuth2 or Kerberos.
  • Issue #5397 - Fixed an issue where the password recovery link was not working.
  • Issue #5402 - Ensure that scroll bar on browser tree should be visible on windows resize.
  • Issue #5405 - Fixed the cross-site scripting vulnerability.
  • Issue #5427 - Fixed an issue where filtered rows were not working.

New in pgAdmin 4 6.14 (Sep 22, 2022)

  • New features:
  • Housekeeping:
  • Issue #4059 - Port schema diff to React. (RM #6133)
  • Issue #4060 - Remove Backgrid and Backform. (RM #6134)
  • Issue #5035 - Port the remaining components of the ERD Tool to React. (RM #7343)
  • Issue #5120 - Updated keyboard shortcut documentation. (RM #7446)
  • Issue #5260 - Remove Alertify from pgAdmin completely. (RM #7619)
  • Issue #5263 - Port search object dialog to React. (RM #7622)
  • Bug fixes:
  • Issue #5144 - Ensure that if big animal authentication is aborted, API calls should be stopped. (RM #7472)
  • Issue #5209 - Fixed an issue where pgAdmin failed to start due to bin path migration. (RM #7557)
  • Issue #5230 - Fixed an issue where backup does not work due to parameter ‘preexec_fn’ no longer being supported. (RM #7580)
  • Issue #5250 - Ensure that the browser tree should be refreshed after changing the ownership. (RM #7607)
  • Issue #5274 - Fixed the error message displayed when clicking the cloud server for which deployment is in progress. (RM #7636)
  • Issue #5275 - Fixed an issue where the wrong SQL displayed in difference if the user create an RLS policy on the table without a column. (RM #7637)
  • Issue #5282 - Ensure that the dump servers functionality works from setup.py. (RM #7644)
  • Issue #5284 - Ensure that the Import/Export server menu option is visible. (RM #7646)
  • Issue #5286 - Fixed API test case for change password in the server mode. (RM #7648)
  • Issue #5287 - Fixed an issue with the non-visibility of columns added prior to import/export data. (RM #7649)
  • Issue #5292 - Fixed an issue where textarea of the JSON Editor does not resize with dialog. (RM #7656)
  • Issue #5299 - Fixed ModuleNotFoundError when running setup.py to load/dump servers. (RM #7663)
  • Issue #5323 - Replace the language selection ‘Brazilian’ with ‘Portuguese (Brazilian). (RM #7693)
  • Issue #5325 - Fixed an issue where server names with special characters are not displayed correctly in the process tab. (RM #7695)
  • Issue #5333 - Fixed an issue where ERD throws an error if variable is added to the column. (RM #7709)
  • Issue #5342 - Fixed an error while saving changes to the ERD table.
  • Issue #5343 - Fixes a redirect vulnerability when the user opens the pgAdmin URL.

New in pgAdmin 4 6.13 (Aug 25, 2022)

  • New features:
  • Issue #3709 - Added support to show all background processes in separate panel.
  • Issue #7387 - Added support to create triggers from existing trigger functions in EPAS.
  • Housekeeping:
  • Issue #7344 - Port Role Reassign dialog to React.
  • Issue #7345 - Port User Management dialog to React.
  • Issue #7404 - Port process watcher to React.
  • Issue #7462 - Remove the SQL files for the unsupported versions of the database server.
  • Issue #7567 - Port About dialog to React.
  • Issue #7568 - Port change user password and 2FA dialog to React.
  • Issue #7590 - Port change ownership dialog to React.
  • Issue #7595 - Update the container base image to Alpine 3.16 (with Python 3.10.5).
  • Issue #7602 - Fixed improper parsing of HTTP requests in Pallets Werkzeug v2.1.0 and below (CVE-2022-29361).
  • Bug fixes:
  • Issue #7452 - Ensure that an error is thrown if clipboard access is not provided and change the copy rows shortcut.
  • Issue #7468 - Fixed an issue where the History tab is getting blank and showing an error after some queries are executed.
  • Issue #7481 - Fixed an issue where OWNED BY was incorrectly set to NONE when adding user privileges on the sequence.
  • Issue #7497 - Fixed an issue with the error message being displayed at the right place for Azure deployments.
  • Issue #7521 - Fixed an issue where the Query Editor loses focus when saving a query (Alt+s).
  • Issue #7527 - Fixed API test cases for Postgres 14.4.
  • Issue #7540 - Ensure that rename panel should work on view/edit panels.
  • Issue #7563 - Fixed an issue where autocomplete is not working after clearing the query editor.
  • Issue #7573 - Ensure that autocomplete does not appear when navigating code using arrow keys.
  • Issue #7575 - Fixed an issue where Alt-Shift-Q didn’t work after creating a new query.
  • Issue #7579 - Fixed an issue where copy and pasting a row in the results grid doesn’t set the default for boolean.
  • Issue #7586 - Fixed an issue with rendering geometry when selecting a complete column.
  • Issue #7587 - Ensure that the children of information_schema and pg_catalog node should be displayed.
  • Issue #7591 - Fixed column “none” does not exist issue, while comparing schema objects.
  • Issue #7596 - Fixed an issue where schema diff did not pick up the change in RLS policy.
  • Issue #7608 - Fixed an issue where the cloud deployment wizard creates the cluster with the High Availability even if that option is not selected.
  • Issue #7611 - Ensure that schema diff maintains view ownership when view definitions are modified.
  • Issue #7614 - Fixed crypt key is missing issue when logout from the pgAdmin.
  • Issue #7616 - Ensure that the next button should be disabled if the password did not match for Azure deployment.
  • Issue #7617 - Fixed an issue where Azure cloud deployment failed.
  • Issue #7625 - Fixed Spanish translations typo.
  • Issue #7630 - Ensure that If the trigger function definition is changed, drop and recreate the trigger in the schema diff.
  • Issue #7632 - Fixed an issue where a user could not authenticate using Azure CLI on OSX.
  • Issue #7633 - Ensure that the autofocus is on the input control for the master password and server password dialogs.
  • Issue #7641 - Pin Flask-SocketIO

New in pgAdmin 4 6.12 (Jul 28, 2022)

  • This release contains a number of bug fixes and new features since the release of pgAdmin 4 v6.11.
  • New features:
  • Issue #4488 - Added option to trigger autocomplete on key press in the query tool.
  • Issue #4607 - Allow users to delete files/folders from the storage manager.
  • Issue #7389 - Allow users to search within the file/storage manager.
  • Issue #7486 - Added support for visualizing the graphs using Stacked Line, Bar, and Stacked Bar charts in the query tool.
  • Issue #7487 - Added support for visualise the graph using a Pie chart in the query tool.
  • Housekeeping:
  • Issue #7313 - Port the file/storage manager to React.
  • Issue #7341 - Port change password dialog to React.
  • Issue #7342 - Port Master Password dialog to React.
  • Issue #7492 - Removing dynamic module loading and replacing it with static loading.
  • Issue #7546 - Port named restore point dialog to React.
  • Bug fixes:
  • Issue #7428 - Preserve the settings set by the user in the import/export data dialog.
  • Issue #7471 - Ensure that the splash screen can be moved.
  • Issue #7508 - Fixed an issue where comments on indexes are not displayed.
  • Issue #7512 - Ensure that notices should not disappear from the messages tab.
  • Issue #7517 - Enable the start debugging button once execution is completed.
  • Issue #7518 - Ensure that dashboard graph API is not called after the panel has been closed.
  • Issue #7519 - Ensure that geometry should be shown for all the selected cells.
  • Issue #7520 - Fixed the JSON editor issue of hiding the first record.
  • Issue #7522 - Added support for Azure PostgreSQL deployment in server mode.
  • Issue #7523 - Fixed typo error for Statistics on the table header.
  • Issue #7524 - Fixed an issue where new folders cannot be created in the save dialog.

New in pgAdmin 4 6.11 (Jun 30, 2022)

  • New features:
  • Issue #2647 - Added mouse over indication for breakpoint area in the Debugger.
  • Issue #2648 - Added search text option to the Debugger panel.
  • Issue #7178 - Added capability to deploy PostgreSQL servers on Microsoft Azure.
  • Issue #7332 - Added support for passing password using Docker Secret to Docker images.
  • Issue #7351 - Added the option ‘Show template databases?’ to display template databases regardless of the setting of ‘Show system objects?’.
  • Issue #7485 - Added support for visualise the graph using a Line chart in the query tool.
  • Housekeeping:
  • Issue #6132 - Port Debugger to React.
  • Issue #7315 - Updates documentation for the Traefik v2 container deployment.
  • Issue #7411 - Update pgcli to latest release 3.4.1.
  • Issue #7469 - Upgrade Chartjs to the latest 3.8.0.
  • Bug fixes:
  • Issue #7423 - Fixed an issue where there is no setting to turn off notifications in the Query Tool.
  • Issue #7440 - Fixed an issue where passwords entered in the ‘Connect To Server’ dialog were truncated.
  • Issue #7441 - Ensure that the Query Editor should be focused when switching between query tool tabs.
  • Issue #7443 - Fixed and issue where ‘Use spaces’ not working in the query tool.
  • Issue #7453 - Fixed an issue where the Database restriction is not working.
  • Issue #7460 - Fixed an issue where pgAdmin stuck while creating a new index.
  • Issue #7461 - Fixed an issue where the connection wasn’t being closed when the user switched to a new connection and closed the query tool.
  • Issue #7468 - Skip the history records if the JSON info can’t be parsed instead of showing ‘No history’.
  • Issue #7502 - Fixed an issue where an error message is displayed when creating the new database.
  • Issue #7506 - Fixed permission denied error when deploying PostgreSQL in Azure using Docker.

New in pgAdmin 4 6.10 (Jun 2, 2022)

  • New features:
  • Issue #7364 - Added the ability to resize columns on dashboard tables.
  • Housekeeping:
  • Issue #7283 - PG 15 compatibility issues fixed.
  • Issue #7337 - Port connect server password dialog to React.
  • Bug fixes:
  • Issue #6962 - Fixed the browser tree overlapping nodes and expansion issue.
  • Issue #7002 - Added the ability to detect and warn users about bidirectional Unicode characters.
  • Issue #7347 - Ensure that when Authentication buttons are disabled their text is visible in the Dark and High contrast theme.
  • Issue #7368 - Ensure that unwanted APIs should not be getting called for BigAnimal.
  • Issue #7372 - Tell Docker to always pull the latest base images when building containers.
  • Issue #7373 - Fixed an issue with geometry window zoom mouse scroll not working.
  • Issue #7374 - Fixed an issue when switching between connections in the Query Tool dropdown, the background and foreground colors should be changed.
  • Issue #7376 - Fixed an issue where a popup for unsaved changes appears when clicking on the open file button for a blank query editor.
  • Issue #7380 - Added support for multi-cell selection in the query tool grid.
  • Issue #7383 - Fixed an issue where Preferences are not saved when the dialog is maximized.
  • Issue #7388 - Fixed an issue where an error message fills the entire window if the query is long.
  • Issue #7393 - Ensure that the editor position should not get changed once it is opened.
  • Issue #7394 - Fixed an issue where geometry is not visible when a single cell is selected.
  • Issue #7399 - Added missing toggle case keyboard shortcuts to the query tool.
  • Issue #7402 - Ensure that Dashboard graphs should be refreshed on changing the node from the browser tree.
  • Issue #7403 - Fixed an issue where comments on domain constraints were not visible when selecting a domain node.
  • Issue #7405 - Ensure that null values are accepted for the numeric columns in react-data-grid.
  • Issue #7408 - Fixed an issue when a table has a column with an array type with length or precision, the column type is not selected while editing the table.

New in pgAdmin 4 6.9 (May 13, 2022)

  • New features:
  • Issue #3253 - Added status bar to the Query Tool.
  • Issue #3989 - Ensure that row numbers should be visible in view when scrolling horizontally.
  • Issue #6830 - Relocate GIS Viewer Button to the Left Side of the Results Table.
  • Issue #7179 - Added capability to deploy PostgreSQL servers on EDB BigAnimal.
  • Issue #7282 - Added options ‘Ignore owner’ and ‘Ignore whitespace’ to the schema diff panel.
  • Issue #7325 - Added support for Azure AD OAUTH2 authentication.
  • Housekeeping:
  • Issue #6131 - Port query tool to React.
  • Issue #6746 - Improve the Kerberos Documentation.
  • Issue #7255 - Ensure the database and schema restriction controls are not shown as a drop-down.
  • Issue #7340 - Port data filter dialog to React.
  • Bug fixes:
  • Issue #6725 - Fixed an issue where the Query tool opens on minimum size if the user opens multiple query tool Window quickly.
  • Issue #6958 - Only set permissions on the storage directory upon creation.
  • Issue #7026 - Fixed an issue where the Browser panel is not completely viewable.
  • Issue #7168 - Improvement to the Geometry Viewer popup to change the size of the result tables when column names are quite long.
  • Issue #7187 - Fixed an issue where the downloaded ERD diagram was 0 bytes.
  • Issue #7188 - Fixed an issue where the connection bar is not visible.
  • Issue #7231 - Don’t strip binaries when packaging them in the server RPM as this might break cpython modules.
  • Issue #7252 - Ensure that Columns should always be visible in the import/export dialog.
  • Issue #7260 - Fixed an issue where an Empty message popup after running a query.
  • Issue #7262 - Ensure that Autocomplete should work after changing the connection.
  • Issue #7294 - Fixed an issue where the copy and paste row does not work if the first column contains no data.
  • Issue #7296 - Ensure that after deleting multiple objects from the properties panel, the browser tree should be refreshed.
  • Issue #7299 - Fixed sorting issue in the statistics panel.
  • Issue #7305 - Fixed an issue where the Dashboard Server Activity was showing old queries as active.
  • Issue #7307 - Fixed an issue where the table showed duplicate columns when creating multiple sequences on the same column.
  • Issue #7308 - Ensure that sorting should be preserved on refresh for Server Activity.
  • Issue #7322 - Fixed an issue while creating a new database throwing an error that failed to retrieve data.
  • Issue #7333 - Fixed an issue where the drag and drop table in ERD throws an error.
  • Issue #7339 - Ensure that the Dashboard column sort order should be remembered when the refresh button is clicked.

New in pgAdmin 4 5.3 (May 20, 2021)

  • Features:
  • Connect PostgreSQL servers using Kerberos authentication
  • This feature provides the user to connect to the database servers using Kerberos authentication. Make sure 'kerberos' must be set as AUTHENTICATION_SOURCES in the config file. Added ‘Kerberos authentication?’ switch control in the server dialog if it is set to True then the user can connect to the database server using Kerberos authentication.
  • Auto width of columns by content size in the data output window.
  • This feature provides the user to set the auto width option of the columns by content size. Added ‘Resize by data?’ option in the preferences. If set to True then data columns will auto-size to the maximum width of the data in the column as loaded in the first batch. If False, the column will be sized to the widest of the data type or column name.
  • Bugs/Housekeeping:
  • Fixed an issue where data is displayed in the wrong order when executing the query repeatedly.
  • Fixed an issue where the wrong SQL is showing for the child partition tables.
  • Fixed an issue where CSV download quotes the numeric columns.
  • Ensure that pgAdmin should not allow opening external files that are dragged into it.
  • Fixed an issue where schema diff does not create DROP DEFAULT statement for columns.
  • Fixed an issue where the filter 'Include/Exclude By Selection' not working for null values.
  • Added support for the creation of Nested Table and Varying Array Type for Advanced Server.
  • Fixed ModuleNotFoundError when running setup.py from outside of the root.
  • Fixed an issue where the current debug line is not visible in the 'Dark' theme.
  • Fixed an issue where duplicate columns are visible in the browser tree if dependent on multiple sequences.
  • Ensure that pgAdmin4 shut down completely on the Quit command.

New in pgAdmin 4 5.2 (May 20, 2021)

  • Bugs/Housekeeping:
  • Ensure that the query tool tab should be closed after server disconnection when auto-commit/auto-rollback is set to false.
  • Fixed flickering issue of the input box on check constraints.
  • Corrected the syntax for 'CREATE TRIGGER', use 'EXECUTE FUNCTION' instead of 'EXECUTE PROCEDURE' from v11 onwards.
  • Ensure that the strings in the LDAP auth module are translatable.
  • Ensure that while comparing domains check function dependencies should be considered in schema diff.
  • Added missing dependency 'xdg-utils' for the desktop packages in RPM and Debian.
  • Fixed cannot unpack non-iterable response object error when selecting any partition.
  • Mark the Apache HTTPD config file as such in the web DEB and RPM packages.
  • Fixed an issue where users are unable to see data of the partitions using the View/Edit data option.
  • Fixed an issue where foreign data wrapper properties are not visible if the host option contains two host addresses.
  • Fixed an issue where a connection warning should be displayed on the user clicks on explain or explain analyze and the database server is disconnected from the browser tree.

New in pgAdmin 4 5.1 (May 20, 2021)

  • Features:
  • Zoom scaling options with keyboard shortcuts in runtime:
  • This feature includes the zoom scaling (Zoom In, Zoom Out, Actual Size) options along with Enter/Exit Full Screen mode. We have added the options in Menu as well as using keyboard shortcuts users can perform the desired operation.
  • Show the login roles that are members of a group role be shown when examining a group role.
  • Added '--replace' option in Import server to replace the list of servers with the newly imported one.
  • Make the container distribution a multi-arch build with x86_64 and Arm64 support.
  • Make 'kerberos' an optional feature in the Python wheel, to avoid the need to install MIT Kerberos on the system by default.
  • Bugs/Housekeeping:
  • Fixed an issue where hanging symlinks in a directory caused the select file dialog to break.
  • Make the 'Save Data Changes' icon to be more intuitive.
  • Ensure that cell content being auto selected when editing the cell data.
  • Ensure that SQL formatter should not add extra tabs and format the SQL correctly.
  • Ensure that SQL formatter should not use tab size if 'Use spaces?' set to false.
  • Fixed encoding issue when database encoding set to SQL_ASCII and name of the column is in ASCII character.
  • Ensure that the user should be able to kill the session from Dashboard if the user has a 'pg_signal_backend' role.
  • Ensure PGADMIN_DEFAULT_EMAIL looks sane when initialising a container deployment.
  • Fixed an issue where the user is not able to change the connection in Query Tool when any SQL file is opened.
  • Fixed an issue where copy/paste rows in view data paste the wrong value for boolean type.
  • Ensure that toggle buttons are accessible by most screen readers.

New in pgAdmin 4 5.0 (Feb 26, 2021)

  • Features:
  • New Desktop Runtime (Using NWjs):
  • The Desktop Runtime is now based on NWjs which integrates a browser and the Python server creating a standalone application. By implementing it using NWjs we get rid of the separate server application and the independent browser. We also get rid of QT and C++ runtime logic.
  • There are two minor known issues with this feature (6255 and 6258), both of which are due to bugs in NWjs itself; Users on macOS should use the application menu to exit pgAdmin, rather than quitting from the Dock icon to avoid the first issue. The second issue may cause Windows users to see a red square instead of the normal application icon in some circumstances.
  • Logical Replication support:
  • Logical replication uses a publish and subscribe model with one or more subscribers subscribing to one or more publications on a publisher node. We have added support for logical replication by introducing new treeview nodes and dialogues with which users can easily create/alter/delete publications and subscriptions. Support is also included in the Schema Diff tool.
  • Quick Search functionality:
  • Added a quick search option in the Help menu to search menu items and help articles. Type at least three characters to display all the matching possibilities under Menu items and the relevant documents under Help articles.
  • Make Statistics, Dependencies, Dependants tabs closable. Users can add them back using the 'Add panel' option on the context menu for the tab strip.
  • When running in Docker/Kubernetes, ensure logs are not stored in the container, and only sent to the console.
  • Bugs/Housekeeping:
  • Use cheroot as the default production server for pgAdmin4.
  • Updated Javascript dependencies to the latest versions.
  • Fixed an issue where the focus is not properly set on the filter text editor after closing the error dialog.
  • Fixed an issue where the dependencies tab shows multiple owners for the objects having shared dependencies.
  • Fixed an issue where the Zoom to fit button in the ERD Tool only works if the diagram is larger than the canvas.
  • Fixed an issue where the user was unable to change the background color for a server.
  • Fixed an issue where external utility jobs (backup, maintenance etc.) are failing when the log level is set to DEBUG.
  • Ensure DEB/RPM packages depend on the same version of each other.
  • Fixed an autocomplete issue where it is not showing any suggestions if the schema name contains escape characters.

New in pgAdmin 4 4.29 (Dec 11, 2020)

  • New features:
  • Housekeeping:
  • Issue #5328 - Improve code coverage and API test cases for Foreign Tables.
  • Issue #5337 - Improve code coverage and API test cases for Views and Materialized Views.
  • Issue #5343 - Improve code coverage and API test cases for Debugger.
  • Issue #6062 - Ensure that code coverage should cover class and function declarations.
  • Bug fixes:
  • Issue #5886 - Fixed false error is shown while adding a new foreign key from the table dialog when a foreign key already exists with Auto FK Index set to true.
  • Issue #5943 - Ensure that folder rename should work properly in Storage Manager.
  • Issue #5974 - Fixed an issue where the debugger’s custom tab title not applied when opened in the new browser tab.
  • Issue #5978 - Fixed an issue where dynamic tab title has not applied the first time for debugger panel.
  • Issue #5982 - Fixed documentation issue where JSON is not valid.
  • Issue #5983 - Added the appropriate server icon based on the server type in the new connection dialog.
  • Issue #5985 - Fixed an issue where the process watcher dialog throws an error for the database server which is already removed.
  • Issue #5991 - Ensure that dirty indicator (*) should not be visible when renaming the tabs.
  • Issue #5992 - Fixed an issue where escape character is shown when the server/database name has some special characters.
  • Issue #5998 - Fixed an issue where schema diff doesn’t show the result of compare if source schema has tables with RLS.
  • Issue #6003 - Fixed an issue where an illegal argument is showing for trigger SQL when a trigger is created for View.
  • Issue #6022 - Fixed an issue where shared servers import is failing.
  • Issue #6072 - Fixed DLL load failed while importing bcrypt.

New in pgAdmin 4 4.28 (Nov 13, 2020)

  • New features:
  • Issue #3318 - Added support to download utility files at the client-side.
  • Issue #4230 - Added support to rename query tool and debugger tabs title.
  • Issue #4231 - Added support for dynamic tab size.
  • Issue #4232 - Added tab title placeholder for Query Tool, View/Edit Data, and Debugger.
  • Issue #5891 - Added support to compare schemas and databases in schema diff.
  • Housekeeping:
  • Issue #5938 - Documentation of Storage Manager.
  • Bug fixes:
  • Issue #4639 - Ensure that some fields should be disabled for the trigger in edit mode.
  • Issue #5736 - Fixed an issue where the validation error message is shown twice.
  • Issue #5760 - Ensure that non-superuser should be able to debug the function.
  • Issue #5842 - Ensure that query history should be listed by date/time in descending order.
  • Issue #5858 - Ensure that search object functionality works with case insensitive string.
  • Issue #5895 - Fixed an issue where the suffix for Toast table size is not visible in the Statistics tab.
  • Issue #5911 - Ensure that macros should be run on the older version of Safari and Chrome.
  • Issue #5914 - Fixed an issue where a mismatch in the value of ‘Estimated row’ for functions.
  • Issue #5919 - Added security related enhancements.
  • Issue #5923 - Fixed an issue where non-closeable tabs are getting closed.
  • Issue #5950 - Fixed an issue where a long file name is not visible on the process watcher dialog.
  • Issue #5953 - Fixed an issue where connection to the server is on wait state if a different user is provided.
  • Issue #5959 - Ensure that Grant Wizard should include foreign tables.

New in pgAdmin 4 4.27 (Oct 16, 2020)

  • Bug fixes:
  • Issue #5858 - Ensure that search object functionality works with case insensitive string.
  • Issue #5911 - Ensure that macros should be run on the older version of Safari and Chrome.

New in pgAdmin 4 4.26 (Sep 17, 2020)

  • New features:
  • Issue #2042 - Added SQL Formatter support in Query Tool.
  • Issue #4059 - Added a new button to the query tool toolbar to open a new query tool window.
  • Issue #4979 - Added shared server support for admin users.
  • Issue #5772 - Warn the user when connecting to a server that is older than pgAdmin supports.
  • Housekeeping:
  • Issue #5332 - Improve code coverage and API test cases for Columns and Constraints (Index, Foreign Key, Check, Exclusion).
  • Issue #5344 - Improve code coverage and API test cases for Grant Wizard.
  • Issue #5774 - Improve code coverage and API test cases for Tables.
  • Issue #5792 - Added documentation for shared server support.
  • Bug fixes:
  • Issue #4216 - Ensure that schema names starting with ‘pg’ should be visible in browser tree when standard_conforming_strings is set to off.
  • Issue #5426 - Adjusted the height of jobstep code block to use maximum space.
  • Issue #5652 - Modified the ‘Commit’ and ‘Rollback’ query tool button icons.
  • Issue #5722 - Ensure that the user should be able to drop the database even if it is connected.
  • Issue #5732 - Fixed some accessibility issues.
  • Issue #5734 - Update the description of GIN and GiST indexes in the documentation.
  • Issue #5746 - Fixed an issue where –load-server does not allow loading connections that use pg_services.
  • Issue #5748 - Fixed incorrect reverse engineering SQL for Foreign key when creating a table.
  • Issue #5751 - Enable the ‘Configure’ and ‘View log’ menu option when the server taking longer than usual time to start.
  • Issue #5754 - Fixed an issue where schema diff is not working when providing the options to Foreign Data Wrapper, Foreign Server, and User Mapping.
  • Issue #5764 - Fixed SQL for Row Level Security which is incorrectly generated.
  • Issue #5765 - Fixed an issue in the query tool when columns are having the same name as javascript object internal functions.
  • Issue #5766 - Fixed string indices must be integers issue for PostgreSQL < 9.3.
  • Issue #5773 - Fixed an issue where the application ignores the fixed port configuration value.
  • Issue #5775 - Ensure that ‘setup-web.sh’ should work in Debian 10.
  • Issue #5779 - Remove illegal argument from trigger function in trigger DDL statement.
  • Issue #5794 - Fixed excessive CPU usage by stopping the indefinite growth of the graph dataset.
  • Issue #5815 - Fixed an issue where clicking on the ‘Generate script’ button shows a forever spinner due to pop up blocker.
  • Issue #5816 - Ensure that the ‘CREATE SCHEMA’ statement should be present in the generated script if the schema is not present in the target database.
  • Issue #5820 - Fixed an issue while refreshing Resource Group.
  • Issue #5833 - Fixed an issue where custom sequences are not visible when show system objects are set to false.
  • Issue #5834 - Ensure that the ‘Remove Server Group’ option is available in the context menu.

New in pgAdmin 4 4.25 (Aug 21, 2020)

  • 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.

New in pgAdmin 4 4.24 (Jul 24, 2020)

  • New features:
  • Issue #5583 - Added support for schema level restriction.
  • Issue #5601 - Added RLS Policy support in Schema Diff.
  • Housekeeping:
  • Issue #5326 - Improve code coverage and API test cases for Domain and Domain Constraints.
  • Bug fixes:
  • Issue #3851 - Add proper indentation to the code while generating functions, procedures, and trigger functions.
  • Issue #4235 - Fixed tab indent issue on a selection of lines is deleting the content when ‘use spaces == true’ in the preferences.
  • Issue #5287 - Fixed dark theme-related CSS and modify the color codes.
  • Issue #5470 - Fixed backgrid row hover issue where on hover background color is set for edit and delete cell only.
  • Issue #5530 - Ensure that the referenced table should be displayed on foreign key constraints.
  • Issue #5621 - Remove extra brackets from reverse engineering SQL of RLS Policy.
  • Issue #5629 - Fixed an issue where the user is able to edit properties when some of the collection nodes are selected.
  • Issue #5630 - Fixed an issue where installation of pgadmin4 not working on 32-bit Windows.
  • Issue #5631 - Fixed ‘cant execute empty query’ issue when remove the value of ‘USING’ or ‘WITH CHECK’ option of RLS Policy.

New in pgAdmin 4 4.23 (Jun 25, 2020)

  • New features:
  • Issue #5468 - Added option to ignore the whitespaces while comparing objects in schema diff.
  • Issue #5500 - Added server group name while selecting servers in schema diff.
  • Issue #5516 - Added support of Row Security Policies.
  • Issue #5576 - Improve error messaging if the storage and log directories cannot be created.
  • Housekeeping:
  • Issue #5325 - Improve code coverage and API test cases for Collations.
  • Issue #5574 - Cleanup Windows build scripts and ensure Windows x64 builds will work.
  • Issue #5581 - Documentation of Row Level Security Policies.
  • Bug fixes:
  • Issue #3591 - Ensure that the query tool should display the proper error message while terminating the active session.
  • Issue #3669 - Ensure that proper error should be displayed for the deleted node.
  • Issue #3787 - Disabled the Stop process button after clicking it and added a message ‘Terminating the process…’ to notify the user.
  • Issue #4226 - Fixed an issue where select all checkbox only selects the first 50 tables.
  • Issue #5416 - Ensure that the query tool panel gets closed when clicking on the ‘Don’t Save’ button.
  • Issue #5465 - Fixed an issue where the Edge browser version is showing wrong and warning message gets displayed.
  • Issue #5492 - Fixed an issue where the search object is unable to locate inherited tables and constraint filters are not working.
  • Issue #5507 - Fixed connection and version number detection issue when the database server is upgraded.
  • Issue #5521 - Fixed an issue when dumping servers from a desktop pgAdmin app by providing an option ‘–sqlite-path’.
  • Issue #5539 - Fixed typo in exception keyword.
  • Issue #5584 - Fixed an issue where two identical tables showing different by schema diff tool.
  • Issue #5592 - Ensure that pgadmin should be able to connect to the server which has password more than 1000 characters.

New in pgAdmin 4 4.22 (May 28, 2020)

  • New features:
  • Added connected pgAdmin user and connection name in the log file.
  • Show the startup log as well as the server log in the runtime’s log viewer.
  • Housekeeping:
  • Implement Selenium Grid to run multiple tests across different browsers, operating systems, and machines in parallel.
  • Improve code coverage and API test cases for Indexes.
  • Improve code coverage and API test cases for the Rules module.
  • Improve code coverage and API test cases for Triggers and Compound Triggers.
  • Remove support for Python 2.
  • Cleanup Python detection in the runtime project file.
  • Refactor pgAdmin4.py so it can be imported and is a lot more readable.
  • Search object UI improvements.
  • Cleanup and refactor the macOS build scripts.
  • Update dependencies in the Docker container.
  • Remove PG 9.4 utilities from the Docker container as it’s now out of support.
  • Bug fixes:
  • Gracefully informed the user that the database is already connected when they click on “Connect Database…”.
  • Fixed an issue where clicking on the cross button of the alert box on the login page is not working.
  • Fixed the SQL help issue for EDB Postgres Advanced Server.
  • Ensure that maintenance job should be worked properly for indexes under a materialized view.
  • Ensure that file browse “home” button should point to $HOME rather than /.
  • Ensure that ‘With OID’ option should be disabled while taking backup of database server version 12 and above.
  • Fixed invalid literal issue when removing the connection limit for the existing role.
  • Fixed internal server error when clicking on Triggers -> ‘Enable All’ for partitions.
  • Fixed generated SQL issue for auto vacuum options.
  • Ensure that the dependencies tab shows correct information for Synonyms.
  • Fixed an issue where the newly added table is not alphabetically added to the tree.
  • Fixed list sorting issue in the schema diff tool.
  • Fixed an issue while comparing the two identical schemas using the schema diff tool.
  • Fixed an issue when renaming the column not added in the proper order.
  • Correct ipv4 “all interfaces” address in the container docs, per Frank Limpert.
  • Fixed an issue where select2 hover is inconsistent for the SSL field in create server dialog.
  • Fixed post-login redirect location when running in server mode under a non-default root.
  • Fixed an issue where the background job creation fails if there is only a version-specific python binary available in PATH.
  • Fixed data truncation issue when updating the data of type character with length.
  • Fixed an issue where if LDAP_SEARCH_BASE_DN is not set then, the value for LDAP_BASE_DN will be considered.
  • Fixed an issue where clicking on Select All button, not selecting all the options in pgAgent job scheduler.
  • Clarify and correct the docs on enabling the pl/debugger plugin on the server.
  • Fixed Unicode decode error ‘utf-8’ codec can’t decode byte.

New in pgAdmin 4 4.21 (Apr 30, 2020)

  • New features:
  • Issue #2172 - Added search object functionality.
  • Issue #2186 - Added LDAP authentication support.
  • Issue #5184 - Added support for parameter toast_tuple_target and parallel_workers of the table.
  • Issue #5264 - Added support of Packages, Sequences and Synonyms to the Schema Diff.
  • Issue #5353 - Added an option to prevent a browser tab being opened at startup.
  • Bug fixes:
  • Issue #3645 - Ensure that the start and end date should be deleted when clear the selection for pgAgent Job.
  • Issue #4512 - Fixed calendar opening issue on the exception tab inside the schedules tab of pgAgent.
  • Issue #5180 - Fixed an issue where the autovacuum_enabled parameter is added automatically in the RE-SQL when the table has been created using the WITH clause.
  • Issue #5268 - Fixed generated SQL when any token in FTS Configuration or any option in FTS Dictionary is changed.
  • Issue #5275 - Fixed tab key navigation issue for parameters in table dialog.
  • Issue #5314 - Ensure that switch cell is in sync with switch control for accessibility.
  • Issue #5351 - Fixed compilation warnings while building pgAdmin.

New in pgAdmin 4 4.20 (Apr 2, 2020)

  • New features:
  • Issue #5261 - Added support of Collation, FTS Configuration, FTS Dictionary, FTS Parser and FTS Template to the Schema Diff.
  • Issue #5262 - Added support of Domain, Domain Constraints and Types to the Schema Diff.
  • Housekeeping:
  • Issue #5271 - Enhance the color of switch control for both light and dark theme.
  • Issue #5284 - Added and fixed gettext usage for better translation coverage.
  • Bug fixes:
  • Issue #4237 - Fix an issue where the user can not change the value of DateTime picker control using keyboard.
  • Issue #4608 - Fixed some accessibility issues in the dialogs.
  • Issue #4942 - Fixed chrome driver download utility issue for Ubuntu.
  • Issue #5128 - Change some colors and opacity to comply with WCAG color contrast standards.
  • Issue #5143 - Fix an accessibility issue to maximize the panel for all alertify dialog.
  • Issue #5221 - Improve logic to get the DDL statements as a part of the comparison.
  • Issue #5241 - Fixed tab key navigation issue for Grant Wizard.
  • Issue #5279 - Fixed Unicode character issue causing error on Python2 environment.
  • Issue #5292 - Fixed focus color issue for Alertify dialog buttons.

New in pgAdmin 4 4.19 (Mar 5, 2020)

  • New features:
  • Issue #5154 - Added accessibility support in AlertifyJS.
  • Issue #5170 - Added Czech language support.
  • Issue #5179 - Added Python 3.8 support.
  • Housekeeping:
  • Issue #5088 - Improve code coverage and API test cases for the Event Trigger module.
  • Issue #5133 - Improvements in the UI for both default and dark themes.
  • Issue #5176 - Enhance logging by tracking stdout and stderr of subprocess when log level set to DEBUG.
  • Issue #5185 - Added option to override the class name of a label tag for select2 control.
  • Bug fixes:
  • Issue #4955 - Changed the color of selected and hovered item for Select2 dropdown.
  • Issue #4996 - Improve the style of the highlighted code after query execution for Dark mode.
  • Issue #5058 - Ensure that AlertifyJS should not be visible as a title for alert dialog.
  • Issue #5077 - Changed background pattern for geometry viewer to use #fff for all themes.
  • Issue #5101 - Fix an issue where debugger not showing all arguments anymore after hitting SQL error while debugging.
  • Issue #5107 - Set proper focus on tab navigation for file manager dialog.
  • Issue #5115 - Fix an issue where command and statements were parsed incorrectly for Rules.
  • Issue #5142 - Ensure that all the transactions should be canceled before closing the connections when a server is disconnected using pgAdmin.
  • Issue #5184 - Fixed Firefox monospaced issue by updating the font to the latest version.
  • Issue #5214 - Update Flask-SQLAlchemy and SQLAlchemy package which is not working on Windows with Python 3.8.
  • Issue #5215 - Fix syntax error when changing the event type for the existing rule.

New in pgAdmin 4 4.18 (Feb 6, 2020)

  • New features:
  • Issue #2554 - Added support for a multi-level partitioned table.
  • Issue #3452 - Added a Schema Diff tool to compare two schemas and generate a diff script.
  • Issue #4762 - Allow screen-reader to read label & description of non-textable elements.
  • Issue #4763 - Allow screen-reader to identify the alert errors.
  • Issue #4770 - Added labels and titles after parsing and validating all the pgAdmin4 web pages for accessibility.
  • Issue #4993 - Set input controls as read-only instead of disabled will allow tab navigation in the properties tab and also allow screen readers to read it.
  • Housekeeping:
  • Issue #5049 - Improve code coverage and API test cases for the CAST module.
  • Issue #5050 - Improve code coverage and API test cases for the LANGUAGE module.
  • Issue #5071 - Improve the test framework to run for multiple classes defined in a single file.
  • Issue #5072 - Updated wcDocker package which includes aria-label accessibility improvements.
  • Issue #5096 - Replace node-sass with sass for SCSS compilation.
  • Bug fixes:
  • Issue #3812 - Ensure that path file name should not disappear when changing ext from the dropdown in file explorer dialog.
  • Issue #4410 - Fixed an issue while editing char[] or character varying[] column from View/Edit data throwing an error.
  • Issue #4511 - Fixed an issue where Grant wizard unable to handle multiple objects when the query string parameter exceeds its limit.
  • Issue #4601 - Added tab navigation on close buttons for all the panels and create/properties dialog.
  • Issue #4827 - Fix column resizable issue in the file explorer dialog.
  • Issue #5000 - Logout the pgAdmin session when no user activity of mouse move, click or keypress.
  • Issue #5025 - Fix an issue where setting STORAGE_DIR to empty should show all the volumes on Windows in server mode.
  • Issue #5065 - Updated the incorrect icon used for the cast node on refresh.
  • Issue #5066 - Fix an issue where refreshing a package results in the change in the object completely.
  • Issue #5074 - Fix an issue where select, insert and update scripts on tables throwing an error.
  • Issue #5076 - Ensure Postfix starts in the container, now it runs as non-root by default.
  • Issue #5116 - Fixed an issue where Save Password control disappears after clicking on it while creating a server.

New in pgAdmin 4 4.17 (Jan 9, 2020)

  • New features:
  • Issue #4764 - Allow screen-reader to read relationship attributes in nested elements.
  • Issue #5060 - Ensure all binaries are securely signed and linked with the hardened runtime in the macOS bundle
  • Housekeeping:
  • Issue #4988 - Refactored SQL of Table’s and it’s child nodes.
  • Issue #5023 - Refactored SQL of Views and Materialized Views.
  • Issue #5024 - Refactored SQL of Functions and Procedures.
  • Issue #5038 - Added support for on-demand loading of items in Select2.
  • Issue #5048 - Added code coverage tool for pgAdmin.
  • Bug fixes:
  • Issue #4198 - Fix syntax highlighting in code mirror for backslash and escape constant.
  • Issue #4506 - Fix an issue where clicking on an empty textbox like fill factor or comments, considers it as change and enabled the save button.
  • Issue #4633 - Added support to view multilevel partitioned tables.
  • Issue #4842 - Ensure that constraints, indexes, rules, triggers, and compound triggers should be created on partitions.
  • Issue #4943 - Added more information to the ‘Database connected/disconnected’ message.
  • Issue #4950 - Ensure that the user should be able to select/modify tablespace for the partitioned table on v12 and above.
  • Issue #4999 - Rename some internal environment variables that could conflict with Kubernetes.
  • Issue #5004 - Fix vulnerability issues reported by ‘yarn audit’. Replace the deprecated uglifyjs-webpack-plugin with a terser-webpack-plugin.
  • Issue #5008 - Ensure that the error message should not be displayed if Tablespace is not selected while creating the index.
  • Issue #5009 - Fix an issue where operator, access method and operator class is not visible for exclusion constraints.
  • Issue #5013 - Add a note to the documentation about the use of non-privileged ports on filesystems that don’t support extended attributes when running the container.
  • Issue #5047 - Added tab navigation for tabs under explain panel in query tool.
  • Issue #5068 - Fix an issue where the table is not created with autovacuum_enabled and toast.autovacuum_enabled for PG/EPAS 12.

New in pgAdmin 4 4.16 (Dec 12, 2019)

  • New features:
  • Issue #4396 - Warn the user on changing the definition of Materialized View about the loss of data and its dependent objects.
  • Issue #4435 - Allow drag and drop functionality for all the nodes under the database node, excluding collection nodes.
  • Issue #4711 - Use a ‘play’ icon for the Execute Query button in the Query Tool for greater consistency with other applications.
  • Issue #4772 - Added aria-label to provide an invisible label where a visible label cannot be used.
  • Issue #4773 - Added role=”status” attribute to all the status messages for accessibility.
  • Issue #4939 - Run pgAdmin in the container as a non-root user (pgadmin, UID: 5050)
  • Issue #4944 - Allow Gunicorn logs in the container to be directed to a file specified through GUNICORN_ACCESS_LOGFILE.
  • Issue #4990 - Changed the open query tool and data filter icons.
  • Housekeeping:
  • Issue #4696 - Add Reverse Engineered and Modified SQL tests for Materialized Views.
  • Issue #4807 - Refactored code of table and it’s child nodes.
  • Issue #4938 - Refactored code of columns node.
  • Bug fixes:
  • Issue #3538 - Fix issue where the Reset button does not get enabled till all the mandatory fields are provided in the dialog.
  • Issue #4220 - Fix scrolling issue in ‘Users’ dialog.
  • Issue #4516 - Remove the sorting of table headers with no labels.
  • Issue #4659 - Updated documentation for default privileges to clarify more on the grantor.
  • Issue #4674 - Fix query tool launch error if user name contains HTML characters. It’s a regression.
  • Issue #4724 - Fix network disconnect issue while establishing the connection via SSH Tunnel and it impossible to expand the Servers node.
  • Issue #4761 - Fix an issue where the wrong type is displayed when changing the datatype from timestamp with time zone to timestamp without time zone.
  • Issue #4792 - Ensure that the superuser should be able to create database, as the superuser overrides all the access restrictions.
  • Issue #4818 - Fix server connection drops out issue in query tool.
  • Issue #4836 - Updated the json file name from ‘servers.json’ to ‘pgadmin4/servers.json’ in the container deployment section of the documentation.
  • Issue #4878 - Ensure that the superuser should be able to create role, as the superuser overrides all the access restrictions.
  • Issue #4893 - Fix reverse engineering SQL issue for partitions when specifying digits as comments.
  • Issue #4923 - Enhance the logic to change the label from ‘Delete/Drop’ to ‘Remove’ for the server and server group node.
  • Issue #4925 - Shown some text on process watcher till the initial logs are loaded.
  • Issue #4926 - Fix VPN network disconnect issue where pgAdmin4 hangs on expanding the Servers node.
  • Issue #4930 - Fix main window tab navigation accessibility issue.
  • Issue #4933 - Ensure that the Servers collection node should expand independently of server connections.
  • Issue #4934 - Fix the help button link on the User Management dialog.
  • Issue #4935 - Fix accessibility issues.
  • Issue #4947 - Fix XSS issue in explain and explain analyze for table and type which contain HTML.
  • Issue #4952 - Fix an issue of retrieving properties for Compound Triggers. It’s a regression of #4006.
  • Issue #4953 - Fix an issue where pgAdmin4 unable to retrieve table node if the trigger is already disabled and the user clicks on Enable All.
  • Issue #4958 - Fix reverse engineering SQL issue for triggers when passed a single argument to trigger function.
  • Issue #4964 - Fix an issue where length and precision are not removed from table/column dialog.
  • Issue #4965 - Fix an issue where the Interval data type is not displayed in the properties dialog of table/column.
  • Issue #4966 - Fix ‘Could not find the object on the server.’ error while refreshing the check constraint.
  • Issue #4975 - Fix issue where the user can not switch the UI language. It’s a regression of #4348.
  • Issue #4976 - Fix reverse engineering SQL issue where when clause is not visible for PG/EPAS 12.
  • Issue #4978 - Fix pgAdmin4 failed to start issue after upgrading to version 4.15.
  • Issue #4982 - Added statistics and storage information in reverse engineering SQL of table/column.
  • Issue #4985 - Fix an issue where the inherited table name with quotes did not escape correctly.
  • Issue #4991 - Fix an issue where context menu is open along with submenu and the focus is not on context menu or submenu.

New in pgAdmin 4 4.15 (Nov 14, 2019)

  • New features:
  • Issue #1974 - Added encrypted password in reverse engineered SQL for roles.
  • Issue #3741 - Added Dark(Beta) UI Theme option.
  • Issue #4006 - Support Enable Always and Enable Replica on triggers.
  • Issue #4351 - Add an option to request confirmation before cancelling/resetting changes on a Properties dialog.
  • Issue #4348 - Added support for custom theme creation and selection.
  • Housekeeping:
  • Bug fixes:
  • Issue #3130 - Ensure create new object dialog should be opened when alt+shift+n key is pressed on the collection node.
  • Issue #3279 - Fixed issue where Drop and Disconnect connection menu points are too close to each other.
  • Issue #3789 - Ensure context menus never get hidden below the menu bar.
  • Issue #3859 - Rename the context menu from ‘Drop Server’ to ‘Remove Server’.
  • Issue #3913 - Ensure the correct “running at” agent is shown when a pgAgent job is executing.
  • Issue #3915 - Fix an issue in the Query Tool where shortcut keys could be ignored following a query error.
  • Issue #3999 - Fix the toggle case shortcut key combination.
  • Issue #4173 - Fix an issue where a black arrow-kind image is displaying at the background of browser tree images.
  • Issue #4191 - Ensure comments are shown in reverse engineered SQL for table partitions.
  • Issue #4242 - Handle NULL values appropriately when sorting backgrid tables.
  • Issue #4341 - Give appropriate error messages when the user tries to use an blank master password.
  • Issue #4451 - Remove arbitrary (and incorrect) requirement that composite types must have at least two members.
  • Issue #4459 - Don’t quote bigints when copying them from the Query Tool results grid.
  • Issue #4482 - Ensure compression level is passed to pg_dump when backing up in directory format.
  • Issue #4483 - Ensure the number of jobs can be specified when backing up in directory format.
  • Issue #4564 - Ensure Javascript errors during Query Tool execution are reported as such and not as Ajax errors.
  • Issue #4610 - Suppress Enter key presses in Alertify dialogues when the come from Select2 controls to allow item selection with Enter.
  • Issue #4647 - Ensure that units are respected when sorting by file size in the File dialog.
  • Issue #4730 - Ensure all messages are retained in the Query Tool from long running queries.
  • Issue #4734 - Updated documentation for the delete row button that only strikeout the row instead of deleting it.
  • Issue #4779 - Updated documentation for the query tool toolbar buttons.
  • Issue #4835 - Fixed an issue where psql of v12 throwing “symbol not found” error while running Maintenance and Import/Export.
  • Issue #4845 - Fixed potential error in the properties dialog for the Code tab.
  • Issue #4850 - Fixed an issue where Datetimepicker control opens when clicking on the label.
  • Issue #4895 - Fixed potential issue in reset function for nested objects.
  • Issue #4896 - Fixed an issue where escape key not working to close the open/save file dialog.
  • Issue #4906 - Fixed an issue where keyboard shortcut for context menu is not working when using Firefox on CentOS7.
  • Issue #4924 - Fixed docker container exit issue occurs due to change in Gunicorn’s latest version.

New in pgAdmin 4 4.14 (Oct 18, 2019)

  • New features:
  • Issue #3009 - Added Copy with headers functionality when copy data from Query Tool/View Data.
  • Issue #4778 - Implemeted the Query Plan Analyser.
  • Issue #4823 - Include PostgreSQL 12 binaries in the container.
  • Housekeeping:
  • Issue #4472 - Add Reverse Engineered and Modified SQL tests for Synonyms.
  • Issue #4628 - Add Reverse Engineered and Modified SQL tests for Unique Constraints.
  • Issue #4701 - Optimize Webpack to improve overall performance.
  • Bug fixes:
  • Issue #3386 - Ensure backup a partition table should not backup the whole database.
  • Issue #4199 - Ensure that ‘ENTER’ key in the data filter should not run the query.
  • Issue #4590 - Fix issue where backup fails for schema name that needs quoting.
  • Issue #4728 - Highlighted the color of closing or opening parenthesis when user select them in CodeMirror.
  • Issue #4751 - Fix issue where export job fails when deselecting all the columns.
  • Issue #4753 - Fix an error where ‘false’ string is displayed when we add a new parameter in the Parameters tab, also clear the old value when the user changes the parameter name.
  • Issue #4755 - Ensure that pgAdmin should work behind reverse proxy if the inbuilt server is used as it is.
  • Issue #4756 - Fix issue where pgAdmin does not load completely if loaded in an iframe.
  • Issue #4760 - Ensure the search path should not be quoted for Database.
  • Issue #4768 - Ensure pgAdmin should work behind reverse proxy on a non standard port.
  • Issue #4769 - Fix query tool open issue on Internet Explorer.
  • Issue #4777 - Fix issue where query history is not visible in the query history tab.
  • Issue #4780 - Ensure the search path should not be quoted for Function, Procedure and Trigger Function.
  • Issue #4791 - Fix issue where VALID foreign keys show as NOT VALID in the SQL tab for tables.
  • Issue #4817 - Ensure the MAC OSX app should be notarized for Catalina.

New in pgAdmin 4 4.13 (Sep 19, 2019)

  • New features:
  • Issue #2828 - Added Gather Merge, Named Tuple Store Scan and Table Function Scan icon for explain module.
  • Issue #4553 - Don’t wait for the database connection before rendering the Query Tool UI, for improved UX.
  • Issue #4651 - Allow configuration options to be set from the environment in the container distribution.
  • Issue #4667 - Ensure editable and read-only columns in Query Tool should be identified by icons and tooltips in the column header.
  • Issue #4691 - Add an Italian translation.
  • Issue #4752 - Refactor Dockerfile to avoid needing to run supporting scripts (i.e. ‘docker build .’ will work) and minimise layers.
  • Housekeeping:
  • Issue #4575 - Add Reverse Engineered SQL tests for Schemas.
  • Issue #4576 - Add Reverse Engineered SQL tests for Views.
  • Issue #4600 - Add Reverse Engineered SQL tests for Rules.
  • Issue #4616 - Add Reverse Engineered and Modified SQL tests for Foreign Keys.
  • Issue #4617 - Add Reverse Engineered and Modified SQL tests for Foreign Servers.
  • Issue #4618 - Add Reverse Engineered and Modified SQL tests for Foreign Tables.
  • Issue #4619 - Add Reverse Engineered and Modified SQL tests for FTS Templates.
  • Issue #4621 - Add Reverse Engineered and Modified SQL tests for Indexes.
  • Issue #4624 - Add Reverse Engineered and Modified SQL tests for Primary Keys.
  • Issue #4627 - Add Reverse Engineered and Modified SQL tests for User Mappings.
  • Issue #4690 - Add Modified SQL tests for Resource Group.
  • Bug fixes¶
  • Issue #2706 - Added ProjectSet icon for explain module.
  • Issue #3778 - Ensure Boolean columns should be editable using keyboard keys.
  • Issue #3936 - Further code refactoring to stabilise the Feature Tests.
  • Issue #4381 - Fix an issue where oid column should not be pasted when copy/paste row is used on query output containing the oid column.
  • Issue #4408 - Fix display of validation error message in SlickGrid cells.
  • Issue #4412 - Fix issue where Validated switch option is inverted for the Foreign Key.
  • Issue #4419 - Fix a debugger error when using Python 2.7.
  • Issue #4461 - Fix error while importing data to a table using Import/Export dialog and providing “Not null columns” option.
  • Issue #4486 - Ensure View should be created with special characters.
  • Issue #4487 - Ensure Boolean columns should be editable in View/Edit data and Query Tool.
  • Issue #4577 - Fix an error that could be seen when click on any system column of a table.
  • Issue #4584 - Unescape HTML entities in database names in the Query Tool title bar.
  • Issue #4631 - Add editor options for plain text mode and to disable block folding to workaround rendering speed issues in CodeMirror with very large scripts.
  • Issue #4642 - Ensure port and username should not be mandatory when a service is provided.
  • Issue #4643 - Fix Truncate option deselect issue for compound triggers.
  • Issue #4644 - Fix length and precision enable/disable issue when changing the data type for Domain node.
  • Issue #4650 - Fix SQL tab issue for Views. It’s a regression of compound triggers.
  • Issue #4657 - Fix PGADMIN_SERVER_JSON_FILE environment variable support in the container.
  • Issue #4663 - Fix exception in query history for python 2.7.
  • Issue #4674 - Fix query tool launch error if user name contain html characters.
  • Issue #4681 - Increase cache control max age for static files to improve performance over longer run.
  • Issue #4698 - Fix SQL issue of length and precision when changing the data type of Column.
  • Issue #4702 - Fix modified SQL for Index when reset the value of Fill factor and Clustered?.
  • Issue #4703 - Fix reversed engineered SQL for btree Index when provided sort order and NULLs.
  • Issue #4726 - Ensure sequence with negative value should be created.
  • Issue #4727 - Fix issue where EXEC script doesn’t write the complete script for Procedures.
  • Issue #4736 - Fix query tool and view data issue with the Italian language.
  • Issue #4742 - Ensure Primary Key should be created with Index.
  • Issue #4750 - Fix query history exception for Python 3.6.

New in pgAdmin 4 4.12 (Aug 22, 2019)

  • New features:
  • Issue #4144 - Add support of Compound Triggers for EPAS 12+.
  • Issue #4333 - Add support for planner support functions in PostgreSQL 12+ functions.
  • Issue #4334 - Add support for generated columns in Postgres 12+.
  • Issue #4540 - Use the full tab space for CodeMirror instances on dialogues where appropriate.
  • Issue #4549 - Allow a banner to be displayed on the login and other related pages showing custom text.
  • Issue #4566 - Allow enhanced cookie protection to be disabled for compatibility with dynamically addressed hosting environments.
  • Issue #4570 - Add an optimisation to the internal code responsible for searching for treeview nodes.
  • Issue #4574 - Display the row count in the popup message when counting table rows, not just in the properties list.
  • Issue #4612 - Add support in query history to show internal queries generated by pgAdmin during save data operations.
  • Housekeeping:
  • Issue #4546 - Add Reverse Engineered SQL tests for Columns.
  • Issue #4554 - Add Reverse Engineered SQL tests for Trigger Functions.
  • Issue #4555 - Add Reverse Engineered SQL tests for Exclusion Constraint.
  • Issue #4560 - Add a –modules option to the RE-SQL test suite to allow testing of specific object types.
  • Bug fixes:
  • Issue #3605 - Fix issue where Deleting N number of rows makes first N number of rows disable.
  • Issue #4179 - Fix generation of reverse engineered SQL for tables with Greenplum 5.x.
  • Issue #4229 - Update wcDocker to allow the browser’s context menu to be used except in tab strips and panel headers.
  • Issue #4401 - Ensure type names are properly encoded in the results grid.
  • Issue #4414 - Fix generation of reverse engineered SQL for partition table, partitions were shown as a child of indexes.
  • Issue #4489 - Update wcDocker to prevent window state loading creating blank dialogues.
  • Issue #4490 - Fix accessibility issue for checkbox in IE11.
  • Issue #4492 - Ensure the Query Tool doesn’t throw an error when viewing the contents of a table with no columns.
  • Issue #4496 - Ensure columns can be created when they are IDENTITY fields with the CYCLE option enabled.
  • Issue #4497 - Ensure purely numeric comments can be saved on new columns.
  • Issue #4508 - Fix accessibility issue for Datetime cell in backgrid.
  • Issue #4520 - Ensure the query tool will work with older versions of psycopg2 than we officially support, albeit without updatable resultsets.
  • Issue #4525 - Ensure command tags are shown in the messages tab of the Query Tool.
  • Issue #4536 - Fix load on demand in View/Edit data mode.
  • Issue #4552 - Fix some errors thrown on the JS console when dragging text in the Query Tool.
  • Issue #4559 - Ensure triggers should be updated properly for EPAS server.
  • Issue #4565 - Fix the reverse engineered SQL for trigger functions with the WINDOW option selected.
  • Issue #4578 - Ensure enable trigger menu should be visible when trigger is disabled.
  • Issue #4581 - Ensure the comment on a Primary Key constraint can be edited under the Table node.
  • Issue #4582 - Fix console error when changing kind(SQL/BATCH) for pgAgent job step.
  • Issue #4585 - Fix double click issue to expand the contents of a cell if the resultset was not editable.
  • Issue #4586 - Fix generation of reverse engineered SQL for Rules.
  • Issue #4635 - Ensure compound triggers for event should be updated properly.
  • Issue #4638 - Ensure compound triggers should be displayed under Views.
  • Issue #4641 - Ensure Truncate option should be available for Compound Triggers.

New in pgAdmin 4 4.11 (Jul 25, 2019)

  • New Features:
  • Issue #1760 - Add support for editing of resultsets in the Query Tool, if the data can be identified as updatable.
  • Issue #4318 - Set the mouse cursor appropriately based on the layout lock state.
  • Issue #4335 - Add EXPLAIN options for SETTINGS and SUMMARY.
  • Housekeeping¶
  • Issue #4415 - Add Reverse Engineered SQL tests for Roles and Resource Groups.
  • Issue #4441 - Add Reverse Engineered SQL tests for FDWs.
  • Issue #4452 - Add Reverse Engineered SQL tests for Languages.
  • Issue #4453 - Add Reverse Engineered SQL tests for Extensions.
  • Issue #4454 - Add Reverse Engineered SQL tests for FTS Configurations.
  • Issue #4456 - Add Reverse Engineered SQL tests for Packages.
  • Issue #4460 - Add Reverse Engineered SQL tests for FTS Dictionaries.
  • Issue #4463 - Add Reverse Engineered SQL tests for Domains.
  • Issue #4464 - Add Reverse Engineered SQL tests for Collations.
  • Issue #4468 - Add Reverse Engineered SQL tests for Types.
  • Issue #4469 - Add Reverse Engineered SQL tests for Sequences.
  • Issue #4471 - Add Reverse Engineered SQL tests for FTS Parsers.
  • Issue #4475 - Add Reverse Engineered SQL tests for Constraints.
  • Bug fixes¶
  • Issue #3919 - Allow keyboard navigation of all controls on subnode grids.
  • Issue #3996 - Fix dropping of pgAgent schedules through the Job properties.
  • Issue #4224 - Prevent flickering of large tooltips on the Graphical EXPLAIN canvas.
  • Issue #4389 - Fix an error that could be seen when editing column privileges.
  • Issue #4393 - Ensure parameter values are quoted when needed when editing roles.
  • Issue #4395 - EXPLAIN options should be Query Tool instance-specific.
  • Issue #4427 - Fix an error while retrieving json data from the table.
  • Issue #4428 - Fix ‘malformed array literal’ error when updating a pgAgent job.
  • Issue #4429 - Ensure drag/drop from the treeview works as expected on Firefox.
  • Issue #4437 - Fix table icon issue when updating any existing field.
  • Issue #4442 - Ensure browser should not be started by Selenium when feature tests are excluded from a test run.
  • Issue #4446 - Use ROLE consistently when generating RE-SQL for roles, not USER.
  • Issue #4448 - Fix an error seen when updating a connection string in a pgAgent job step.
  • Issue #4450 - Fix reverse engineered sql for Foreign Data Wrapper created on EPAS server in redwood mode.
  • Issue #4462 - Fix some minor UI issues on IE11.
  • Issue #4470 - Fix sequence reverse engineered SQL generation with quoted names on PG/EPAS 10+.
  • Issue #4484 - Fix an issue where Explain and Explain Analyze are not working, it’s regression of #1760.
  • Issue #4485 - Fix an issue where Filter toolbar button is not working in view/edit data, it’s regression of keyboard navigation.

New in pgAdmin 4 4.10 (Jul 4, 2019)

  • New features:
  • Feature #4139 - Allow some objects to be dragged/dropped into the Query Tool to insert their signature into the query text.
  • Feature #4400 - Allow the path to /pgadmin4/servers.json to be overridden in the container distribution.
  • Bug fixes:
  • Bug #4403 - Ensure the browser close confirmation is only shown when closing a Query Tool which is running in a separate browser tab.
  • Bug #4404 - Prevent an error that may occur when editing data with an integer primary key.
  • Bug #4407 - Fix a quoting issue that caused a blank UI to be displayed when running in French.
  • Bug #4421 - Ensure the version comparision should be correct for windows installer.

New in pgAdmin 4 4.9 (Jun 27, 2019)

  • New features:
  • Feature #3174 - Visually distinguish simple tables from tables that are inherited and from which other tables are inherited.
  • Feature #4202 - Add a framework for testing reversed engineered SQL and CRUD API endpoints.
  • Bug fixes:
  • Bug #3994 - Fix issue where the dependencies tab for inherited tables/foreign keys shows partial text.
  • Bug #4036 - Allow editing of data where a primary key column includes a % sign in the value.
  • Bug #4171 - Fix issue where reverse engineered SQL was failing for foreign tables, if it had “=” in the options.
  • Bug #4195 - Fix keyboard navigation in “inner” tabsets such as the Query Tool and Debugger.
  • Bug #4228 - Ensure the correct label is used in panel headers when viewing filtered rows.
  • Bug #4253 - Fix issue where new column should be created with Default value.
  • Bug #4283 - Initial support for PostgreSQL 12.
  • Bug #4288 - Initial support for PostgreSQL 12.
  • Bug #4290 - Initial support for PostgreSQL 12.
  • Bug #4255 - Prevent the geometry viewer grabbing key presses when not in focus under Firefox, IE and Edge.
  • Bug #4306 - Prevent the “Please login to access this page” message displaying multiple times.
  • Bug #4310 - Ensure that the Return key can be used to submit the Master Password dialogue.
  • Bug #4317 - Ensure that browser auto-fill doesn’t cause Help pages to be opened unexpectedly.
  • Bug #4320 - Fix issue where SSH tunnel connection using password is failing, it’s regression of Master Password.
  • Bug #4329 - Fix an initialisation error when two functions with parameters are debugged in parallel.
  • Bug #4343 - Fix issue where property dialog of column should open properly for EPAS v12.
  • Bug #4345 - Capitalize the word ‘export’ used in Import/Export module.
  • Bug #4349 - Ensure strings are properly encoded in the Query History.
  • Bug #4350 - Ensure we include the CSRF token when uploading files.
  • Bug #4357 - Fix connection restoration issue when pgAdmin server is restarted and the page is refreshed.
  • Bug #4360 - Ensure the debugger control buttons are only enabled once initialisation is complete.
  • Bug #4362 - Remove additional “SETOF” included when generating CREATE scripts for trigger functions.
  • Bug #4365 - Fix help links for backup globals and backup server.
  • Bug #4367 - Fix an XSS issue seen in View/Edit data mode if a column name includes HTML.
  • Bug #4378 - Ensure Python escaping matched JS escaping and fix a minor XSS issue in the Query Tool that required superuser access to trigger.
  • Bug #4380 - Ensure that both columns and partitions can be edited at the same time in the table dialog.
  • Bug #4386 - Fix an XSS issue when username contains XSS vulnerable text.

New in pgAdmin 4 4.8 (Jun 4, 2019)

  • New features:
  • Allow the UI layout to be fully locked or to prevent docking changes.
  • Bug fixes:
  • Omit the geometry viewer in the Query Tool from layout saving.
  • Improve the performance of explain plan by embedding the images only when downloading it.
  • Fix the issue of accessing the SQL for Views and Materialized Views. Regression of pluralisation of folder names.

New in pgAdmin 4 4.7 (May 30, 2019)

  • Bug fixes:
  • Bug #3377 - In server mode, update all the saved server credentials when user password is changed.
  • Bug #3885 - Fix the responsive layout of the main menu bar.
  • Bug #4162 - Fix syntax error when adding more than one column to the existing table.
  • Bug #4164 - Fix file browser path issue which occurs when client is on Windows and server is on Mac/Linux.
  • Bug #4184 - Added Master Password to increase the security of saved passwords.
  • Bug #4194 - Fix accessibility issue for menu navigation.
  • Bug #4208 - Update the UI logo.
  • Bug #4217 - Fixed CSRF security vulnerability issue, per Alvin Lindstam
  • Bug #4218 - Properly assign dropdownParent in Select2 controls.
  • Bug #4219 - Ensure popper.js is installed when needed.
  • Bug #4227 - Fixed Tab key navigation for Maintenance dialog.
  • Bug #4244 - Fix Tab key issue for Toggle switch controls and button on the dialog footer in Safari browser.
  • Bug #4245 - Ensure that element should get highlighted when they get focus on using Tab key.
  • Bug #4246 - Fixed console error when subnode control is used in panels.
  • Bug #4261 - Stop using application/x-javascript as a mime type and use the RFC-compliant application/javascript instead.
  • Bug #4262 - Fixed error on displaying table properties of a table partitioned by list having a default partition.
  • Bug #4263 - Fix handling of JSON in the Query Tool with NULL elements.
  • Bug #4269 - Fix navigation of switch cells in grids.
  • Bug #4275 - Clarify wording for the NO INHERIT option on constraints, per Michel Feinstein.
  • Bug #4276 - Relax the permission check on the directory containing the config database, as it may fail in some environments such as OpenShift.
  • Bug #4278 - Prevent Backgrid Password cells from losing focus if the browser opens an autocomplete list.
  • Bug #4284 - Fix syntax error when creating a table with a serial column.

New in pgAdmin 4 4.6 (May 2, 2019)

  • Features:
  • Feature #4165 - Depend on psycopg2-binary in the Python wheel, rather than psycopg2.
  • Bug fixes:
  • Bug #2392 - Ensure that on clicking Delete button should not delete rows immediately from the database server, it should be deleted when Save button will be clicked.
  • Bug #3327 - Ensure that newly added row in backgrid should be visible.
  • Bug #3582 - Ensure that JSON strings as comments should be added properly for all the objects.
  • Bug #3605 - Fix an issue where Deleting N number of rows makes first N number of rows disable.
  • Bug #3938 - Added support for Default Partition.
  • Bug #4087 - Fix an issue where ‘GRANT UPDATE’ sql should be displayed for default sequence privileges.
  • Bug #4101 - Ensure that confirmation dialog should be popped up before reload of query tool or debugger if it is opened in a new browser tab.
  • Bug #4104 - Ensure that record should be add/edited for root partition table with primary keys.
  • Bug #4121 - Fixed alignment issue of columns in definition section of Index node.
  • Bug #4134 - Fixed ‘Location cannot be empty’ error when open Tablespace properties.
  • Bug #4138 - Fix an issue where the dropdown becomes misaligned/displaced.
  • Bug #4154 - Ensure the treeview shows all sequences except those used to implement IDENTITY columns (which can be edited as part of the column). Show all if Show System Objects is enabled.
  • Bug #4160 - Fixed ‘Increment value cannot be empty’ error for existing tables.
  • Bug #4161 - Ensure that parameters of procedures for EPAS server 10 and below should be set/reset properly.
  • Bug #4163 - Prevent duplicate columns being included in reverse engineered SQL for tables.
  • Bug #4182 - Ensure sanity of the permissions on the storage and session directories and the config database.

New in pgAdmin 4 4.5 (Apr 10, 2019)

  • Bug fixes:
  • Bug #2214 - Fixed ‘Change Password’ issue for SCRAM authentication.
  • Bug #3656 - Ensure that two consecutive SELECT statements should work properly.
  • Bug #4131 - Relabel the Save button on the datagrid text editor to avoid confusion with the actual Save button that updates the database.
  • Bug #4142 - Added recommended ESLinter checks.
  • Bug #4143 - Ensure that pgAdmin4 should work properly with psycopg2 v2.8

New in pgAdmin 4 4.4 (Apr 4, 2019)

  • Features:
  • Feature #2001 - Add support for reverse proxied setups with Gunicorn, and document Gunicorn, uWSGI & NGINX configurations.
  • Feature #4017 - Make the Query Tool history persistent across sessions.
  • Feature #4018 - Remove the large and unnecessary dependency on React and 87 other related libraries.
  • Feature #4030 - Add support for IDENTITY columns.
  • Feature #4075 - Add an ePub doc build target.
  • Bug fixes:
  • Bug #1269 - Fix naming inconsistency for the column and FTS parser modules.
  • Bug #2627 - Include inherited column comments and defaults in reverse engineered table SQL.
  • Bug #3104 - Improve a couple of German translations.
  • Bug #3887 - Use the user’s full email address (not just the username part) as the basis for the storage directory name.
  • Bug #3968 - Update wcDocker to fix the issue where the Scratch Pad grows in size if the results panel is resized.
  • Bug #3995 - Avoid ‘bogus varno’ message from Postgres when viewing the SQL for a table with triggers.
  • Bug #4019 - Update all Python and JavaScript dependencies.
  • Bug #4037 - Include comment SQL for inherited columns in reverse engineered table SQL.
  • Bug #4050 - Make the WHEN field a CodeMirror control on the Event Trigger dialogue.
  • Bug #4052 - Fix the online help button on the resource group dialogue.
  • Bug #4053 - Enable the online help button on the index dialogue.
  • Bug #4054 - Handle resultsets with zero columns correctly in the Query Tool.
  • Bug #4058 - Include inherited columns in SELECT scripts.
  • Bug #4060 - Fix the latexpdf doc build.
  • Bug #4062 - Fix handling of numeric arrays in View/Edit Data.
  • Bug #4063 - Enlarge the grab handles for resizing dialogs etc.
  • Bug #4069 - Append the file suffix to filenames when needed in the File Create dialogue.
  • Bug #4071 - Ensure that Firefox prompts for a filename/location when downloading query results as a CSV file.
  • Bug #4073 - Change the CodeMirror active line background colour to $color-danger-lighter so it doesn’t conflict with the selection colour.
  • Bug #4081 - Fix the RE-SQL syntax for roles with a VALID UNTIL clause.
  • Bug #4082 - Prevent an empty error message being shown when “downloading” a CREATE script using the CSV download.
  • Bug #4084 - Overhaul the layout saving code so it includes the Query Tool and Debugger, and stores the layout when change events are detected rather than (unreliably) on exit.
  • Bug #4085 - Display errors during CSV download from the Query Tool in the UI rather than putting them in the CSV file.
  • Bug #4090 - Improve the German translation for Backup Server.
  • Bug #4096 - Ensure the toolbar buttons are properly reset following a CSV download in the Query Tool.
  • Bug #4099 - Fix SQL help for EPAS 10+, and refactor the URL generation code into a testable function.
  • Bug #4100 - Ensure sequences can be created with increment, start, minimum and maximum options set.
  • Bug #4105 - Fix an issue where JSON data would not be rendered in the Query Tool.
  • Bug #4109 - Ensure View/Materialized View node should be visible after updating any property.
  • Bug #4110 - Fix custom autovacuum configuration for Materialized Views.

New in pgAdmin 4 4 3.2 (Aug 21, 2018)

  • Features:
  • Feature #2136 - Added version number for URL’s to ensure that files are only cached on a per-version basis.
  • Feature #2214 - Add support for SCRAM password changes (requires psycopg2 >= 2.8).
  • Feature #3074 - Add support for reset saved password.
  • Feature #3397 - Add support for Trigger and JIT stats in the graphical query plan viewer.
  • Feature #3412 - Add support for primary key, foreign key, unique key, indexes and triggers on partitioned tables for PG/EPAS 11.
  • Feature #3506 - Allow the user to specify a fixed port number in the runtime to aid cookie whitelisting etc.
  • Feature #3510 - Add a menu option to the runtime to copy the appserver URL to the clipboard.
  • Bug fixes:
  • Bug #3185 - Fix the upgrade check on macOS.
  • Bug #3191 - Fix a number of debugger execution issues.
  • Bug #3294 - Infrastructure (and changes to the Query Tool, Dashboards and Debugger) for realtime preference handling.
  • Bug #3309 - Fix Directory format support for backups.
  • Bug #3316 - Support running on systems without a system tray.
  • Bug #3319 - Cleanup and fix handling of Query Tool Cancel button status.
  • Bug #3363 - Fix restoring of restore options for sections.
  • Bug #3371 - Don’t create a session when the /misc/ping test endpoint is called.
  • Bug #3446 - Various procedure/function related fixes for EPAS/PG 11.
  • Bug #3448 - Exclude system columns in Import/Export.
  • Bug #3457 - Fix debugging of procedures in EPAS packages.
  • Bug #3458 - pgAdmin4 should work with python 3.7.
  • Bug #3468 - Support SSH tunneling with keys that don’t have a passphrase.
  • Bug #3471 - Ensure the SSH tunnel port number is honoured.
  • Bug #3511 - Add support to save and clear SSH Tunnel password.
  • Bug #3526 - COST statement should not be automatically duplicated after creating trigger function.
  • Bug #3527 - View Data->Filtered Rows dialog should be displayed.

New in pgAdmin 4 4 2.1 (Jan 14, 2018)

  • Features:
  • Feature #1383 - Allow connections to be coloured in the treeview and query tool
  • Feature #1489 - Improve user interface for selection query in Data Filter window
  • Feature #2368 - Improve data entry in Query Tool
  • Feature #2781 - Allow configuration of CSV and clipboard formatting of query results
  • Feature #2802 - Allow connections to be coloured in the treeview and query tool.
  • Feature #2810 - Allow files to be opened by double clicking on them within Query Tool
  • Feature #2845 - Make the “Save Changes” prompts in the query tool optional
  • Feature #2849 - Add support for editing data in tables with OIDs but no primary keys and updates the editor to retrieve all row values on save, thus immediately showing default values and allowing subsequent editing without a refresh
  • Bug fixes:
  • Bug #1365 - Prevent the Windows installer accepting paths containing invalid characters
  • Bug #1366 - Fix /NOICONS switch in the windows installer
  • Bug #1436 - Fix issue with debugger which is failing for sub - procedure on PPAS 9.6
  • Bug #1749 - Fixes in pgAgent module including; 1) allowing start date earlier than end date when scheduling job, 2) Datetime picker not displaying in grid and 3) validation error not displaying propertly for Datetime control
  • Bug #2094 - Display relevant error messages when access is denied creating a schema
  • Bug #2098 - Cleanup some inconsistent error dialog titles
  • Bug #2258 - Fix handling of DATERANGE[] type
  • Bug #2278 - Display long names appropriately in dialogue headers
  • Bug #2443 - Confirm with the user before exiting the runtime
  • Bug #2524 - Fix debugging of self-referencing functions
  • Bug #2566 - Fix the Pause/Resume Replay of WAL files for PostgreSQL 10
  • Bug #2624 - Ensure the switch animation is consistent on the table dialogue and avoid displaying an error incorrectly
  • Bug #2651 - Ensure estimated rows are included correctly in CREATE script for functions
  • Bug #2679 - Getting started links does not open second time if User open any URL and Click on Close button with cross bar
  • Bug #2705 - User can add expirty date on Windows
  • Bug #2715 - Ensure we can download large files and keep the user informed about progress
  • Bug #2720 - Ensure password changes are successful if authenticating using a pgpass file
  • Bug #2726 - Ensure the auto-complete selection list can display longer names
  • Bug #2738 - Ensure line numbers form CodeMirror don’t appear on top of menus
  • Bug #2748 - Format JSON/JSONB nicely when displaying it in the grid editor pop-up
  • Bug #2760 - When selecting an SSL cert or key, update only the expected path in the UI, not all of them
  • Bug #2765 - Do not decrypt the password when the password is ‘None’. This should avoid the common but harmless exception “ValueError: IV must be 16 bytes long while decrypting the password.”
  • Bug #2768 - Only allow specification of a pgpass file if libpq >= 10
  • Bug #2769 - Correct keyboard shortcut. Don’t un-comment code with alt+. in the query tool. It’s only supposed to respond to ctrl/cmd+
  • Bug #2772 - Remove external links from Panel’s context menu
  • Bug #2778 - Ensure the datatype cache is updated when a domain is added
  • Bug #2779 - Ensure column collation isn’t lost when changing field size
  • Bug #2780 - Ensure auto-indent honours the spaces/tabs config setting
  • Bug #2782 - Re-hash the way that we handle rendering of special types such as arrays
  • Bug #2787 - Quote the owner name when creating types
  • Bug #2806 - Attempt to decode database errors based on lc_messages
  • Bug #2811 - Display process output as it happens
  • Bug #2820 - Logs available when executing backup and restore
  • Bug #2821 - Attempt to decode database errors based on lc_messages
  • Bug #2822 - Re-hash the way that we handle rendering of special types such as arrays.
  • Bug #2824 - Fix a number of graphical explain rendering issues
  • Bug #2836 - Fix counted rows display in table properties
  • Bug #2842 - Fix a number of graphical explain rendering issues
  • Bug #2846 - Add an option to manually count rows in tables to render the properties
  • Bug #2854 - Fix utility output capture encoding
  • Bug #2859 - Allow form validation messages to be close in case the eclipse anything on the form
  • Bug #2866 - Ensure we don’t show the full path on the server when using virtual filesystem roots in server mode for SSL certs
  • Bug #2875 - Ensure the scroll location is retains in the query tool data grid if the user changes tab and then returns
  • Bug #2877 - Remove the artificial limit of 4000 characters from text areas
  • Bug #2880 - Honour whitespace properly in the data grid
  • Bug #2881 - Fix support for time without timezone
  • Bug #2886 - Resolve issue where Insert failed when tried with default primary key value
  • Bug #2891 - Allow changing of the users password without leaving the app
  • Bug #2892 - Refuse password changes (and tell the user) if the notification email cannot be sent
  • Bug #2908 - Fix bundle creation on Windows which was failing due to rn line endings in code mirror
  • Bug #2918 - Add missing init.py to backports.csv when building the MSVC windows build
  • Bug #2920 - Push HTTPD logs to container stdout/stderr as appropriate
  • Bug #2921 - Fixes in pgAgent module including; 1) allowing start date earlier than end date when scheduling job, 2) Datetime picker not displaying in grid and 3) validation error not displaying propertly for Datetime control
  • Bug #2922 - Don’t login the user with every request in desktop mode. Just do it once
  • Bug #2923 - Prevent the user pressing the select button in the file manager when it is supposed to be disabled
  • Bug #2924 - Cleanup the layout of the filter data dialogue
  • Bug #2928 - Prevent multiple connections to new slow-to-respond servers being initiated in error
  • Bug #2934 - Fix a reference before assignment error in the file dialogue
  • Bug #2937 - Prevent attempts to select directories as files in the file dialogue
  • Bug #2945 - Ensure invalid options can’t be selected on triggers on views
  • Bug #2949 - Display complete SQL for FTS dictionaries
  • Bug #2952 - Don’t try to render security URLs in desktop mode
  • Bug #2954 - Allow selection of validation error text
  • Bug #2974 - Clear the messages tab when running EXPLAIN/EXPLAIN ANALYZE
  • Bug #2993 - Fix view data for views/mat views

New in pgAdmin 4 4 2.0 (Oct 5, 2017)

  • Features:
  • Feature #1918 - Add a field to the Server Dialogue allowing users to specify a subset of databases they’d like to see in the treeview
  • Feature #2135 - Significantly speed up loading of the application
  • Feature #2556 - Allow for slow vs. fast connection failures
  • Feature #2579 - Default the file browser view to list, and make it configurable
  • Feature #2597 - Allow queries to be cancelled from the dashboard and display additional info in the subnode control
  • Feature #2649 - Support use of SSL certificates for authentication
  • Feature #2650 - Support use of pgpass files
  • Feature #2662 - Ship with pre-configured paths that can work in both Server and Desktop modes out of the box
  • Feature #2689 - Update icons with new designs and remove from menus to de-clutter the UI
  • Bug fixes:
  • Bug #1165 - Prevent continual polling for graph data on the dashboard if the server is disconnected
  • Bug #1697 - Update CodeMirror version
  • Bug #2043 - Properly handle trigger functions with parameters
  • Bug #2074 - Make $ quoting consistent
  • Bug #2080 - Fix issue where Browser hangs/crashes when loading data (using sql editor) from table which contains large blob data
  • Bug #2153 - Fix handline of large file uploads and properly show any errors that may occur
  • Bug #2168 - Update CodeMirror version
  • Bug #2170 - Support SSL in the regression tests
  • Bug #2324 - Fix PostGIS Datatypes in SQL tab, Create / Update dialogues for Table, Column, Foreign Table and Type node
  • Bug #2447 - Update CodeMirror version
  • Bug #2452 - Install pgadmin4-v1 1.5 on Centos7
  • Bug #2501 - Fix collation tests on Windows, replace use of default ‘POSIX’ collation with ‘C’ collation for testing
  • Bug #2541 - Fix issues using special keys on MacOS
  • Bug #2544 - Correct malformed query generated when using custom type
  • Bug #2551 - Show tablespace on partitions
  • Bug #2555 - Fix issue in query tool where messages were not displaying from functions/procedures properly
  • Bug #2557 - Tidy up tab styling
  • Bug #2558 - Prevent the tab bar being hidden when detached tabs are being closed
  • Bug #2559 - Stop tool buttons from changing their styling unexpectedly
  • Bug #2560 - Fix View ‘CREATE Script’ Problem
  • Bug #2562 - Update CodeMirror version
  • Bug #2563 - Fix paths under non-standard virtual directories
  • Bug #2566 - Fix Pause/Resume Replay of WAL files for PostgreSQL 10
  • Bug #2567 - Use the proper database connection to fetch the default priviledges in the properties tab of the database
  • Bug #2582 - Unset compression ratio if it is an empty string in Backup module
  • Bug #2586 - Cleanup feature tests
  • Bug #2590 - Allow navigation of query history using the arrow keys
  • Bug #2592 - Stop Flask from initialising service twice in Debug mode
  • Bug #2593 - Ensure babel-polyfill is loaded in older qWebKits
  • Bug #2594 - Fix disconnection of new databases
  • Bug #2596 - Define the proper NODE_ENV environment during running the webpack
  • Bug #2606 - Ensure role names are escaped in the membership control
  • Bug #2616 - Domain create dialog do not open and Font size issue in Security label control
  • Bug #2617 - Add missing pgagent file in webpack.config.js
  • Bug #2619 - Fix quoting of index column names on tables
  • Bug #2620 - Set database name to blank(‘’) when job type is set to batch, while creating pgAgent job
  • Bug #2631 - Change mapping of cell from ‘numeric’ to ‘integer’ for integer control as numeric cell has been removed from the code
  • Bug #2633 - Fix pgAgent job step issues
  • Bug #2634 - Add New Server through Quick links
  • Bug #2637 - Fix Copy so it still works after query results have been copied
  • Bug #2641 - User management issues - styling and inability to edit users properly
  • Bug #2644 - Fix alertify notification messages where checkmark box disconnected from frame
  • Bug #2646 - Fix the path reference of load-node.gif which was referencing to vendor directory
  • Bug #2654 - Update datetime picker
  • Bug #2655 - Fix connection string validation for pgAgent jobs
  • Bug #2656 - Change Datetimepicker to expand from bottom in pgAgent so calendar does not get hidden
  • Bug #2657 - Fix syntax error while saving changes for start/end time, weekdays, monthdays, month, hours, minutes while updating the pgAgent Job
  • Bug #2659 - Fix issue where unable to add/update variables for columns of a table
  • Bug #2660 - Not able to select rows in History Tab
  • Bug #2668 - Fix RE-SQL for triggers with a single arg
  • Bug #2670 - Improve datamodel validations for default Validator if user (developer) does not implement validate function in datamodel
  • Bug #2671 - Fix array data type formating for bigint, real, float, double precision
  • Bug #2681 - Reset query tool options before running tests
  • Bug #2684 - Fix layout of password prompt dialogue
  • Bug #2691 - View data option is missing from pgAdmin4 2.0 version
  • Bug #2692 - Base type is missing for Domain on pgAdmin4
  • Bug #2693 - User list is not available on User mapping pgAdmin4
  • Bug #2698 - User can not create function due to missing return type
  • Bug #2699 - Filtered Rows issue on pgAdmin4
  • Bug #2700 - Cancel button is visible after query executed succesfully
  • Bug #2707 - Disable trigger button does not work on pgAdmin4
  • Bug #2708 - Tablespace name should displayed instead of %s(new_tablespace)s with Move Objects to another tablespace
  • Bug #2709 - Display user relations in schema prefixed by ‘pg’
  • Bug #2713 - Fix an exception seen sometimes when the server is restarted
  • Bug #2742 - Ensure using an alternate role to connect to a database doesn’t cause an error when checking recovery state.

New in pgAdmin 4 2.0 RC 2 (Sep 23, 2017)

  • Features:
  • Feature #1918 - Add a field to the Server Dialogue allowing users to specify a subset of databases they’d like to see in the treeview
  • Feature #2135 - Significantly speed up loading of the application
  • Feature #2556 - Allow for slow vs. fast connection failures
  • Feature #2579 - Default the file browser view to list, and make it configurable
  • Feature #2597 - Allow queries to be cancelled from the dashboard and display additional info in the subnode control
  • Feature #2662 - Ship with pre-configured paths that can work in both Server and Desktop modes out of the box
  • Feature #2689 - Update icons with new designs and remove from menus to de-clutter the UI
  • Bug fixes:
  • Bug #1165 - Prevent continual polling for graph data on the dashboard if the server is disconnected
  • Bug #1697 - Update CodeMirror version
  • Bug #2043 - Properly handle trigger functions with parameters
  • Bug #2074 - Make $ quoting consistent
  • Bug #2080 - Fix issue where Browser hangs/crashes when loading data (using sql editor) from table which contains large blob data
  • Bug #2153 - Fix handline of large file uploads and properly show any errors that may occur
  • Bug #2168 - Update CodeMirror version
  • Bug #2170 - Support SSL in the regression tests
  • Bug #2324 - Fix PostGIS Datatypes in SQL tab, Create / Update dialogues for Table, Column, Foreign Table and Type node
  • Bug #2447 - Update CodeMirror version
  • Bug #2452 - Install pgadmin4-v1 1.5 on Centos7
  • Bug #2501 - Fix collation tests on Windows, replace use of default ‘POSIX’ collation with ‘C’ collation for testing
  • Bug #2541 - Fix issues using special keys on MacOS
  • Bug #2544 - Correct malformed query generated when using custom type
  • Bug #2551 - Show tablespace on partitions
  • Bug #2555 - Fix issue in query tool where messages were not displaying from functions/procedures properly
  • Bug #2557 - Tidy up tab styling
  • Bug #2558 - Prevent the tab bar being hidden when detached tabs are being closed
  • Bug #2559 - Stop tool buttons from changing their styling unexpectedly
  • Bug #2560 - Fix View ‘CREATE Script’ Problem
  • Bug #2562 - Update CodeMirror version
  • Bug #2563 - Fix paths under non-standard virtual directories
  • Bug #2566 - Fix Pause/Resume Replay of WAL files for PostgreSQL 10
  • Bug #2567 - Use the proper database connection to fetch the default priviledges in the properties tab of the database
  • Bug #2582 - Unset compression ratio if it is an empty string in Backup module
  • Bug #2586 - Cleanup feature tests
  • Bug #2590 - Allow navigation of query history using the arrow keys
  • Bug #2592 - Stop Flask from initialising service twice in Debug mode
  • Bug #2593 - Ensure babel-polyfill is loaded in older qWebKits
  • Bug #2594 - Fix disconnection of new databases
  • Bug #2596 - Define the proper NODE_ENV environment during running the webpack
  • Bug #2606 - Ensure role names are escaped in the membership control
  • Bug #2616 - Domain create dialog do not open and Font size issue in Security label control
  • Bug #2617 - Add missing pgagent file in webpack.config.js
  • Bug #2619 - Fix quoting of index column names on tables
  • Bug #2620 - Set database name to blank(‘’) when job type is set to batch, while creating pgAgent job
  • Bug #2631 - Change mapping of cell from ‘numeric’ to ‘integer’ for integer control as numeric cell has been removed from the code
  • Bug #2633 - Fix pgAgent job step issues
  • Bug #2634 - Add New Server through Quick links
  • Bug #2637 - Fix Copy so it still works after query results have been copied
  • Bug #2644 - Fix alertify notification messages where checkmark box disconnected from frame
  • Bug #2646 - Fix the path reference of load-node.gif which was referencing to vendor directory
  • Bug #2654 - Update datetime picker
  • Bug #2655 - Fix connection string validation for pgAgent jobs
  • Bug #2656 - Change Datetimepicker to expand from bottom in pgAgent so calendar does not get hidden
  • Bug #2657 - Fix syntax error while saving changes for start/end time, weekdays, monthdays, month, hours, minutes while updating the pgAgent Job
  • Bug #2659 - Fix issue where unable to add/update variables for columns of a table
  • Bug #2668 - Fix RE-SQL for triggers with a single arg
  • Bug #2670 - Improve datamodel validations for default Validator if user (developer) does not implement validate function in datamodel
  • Bug #2681 - Reset query tool options before running tests
  • Bug #2684 - Fix layout of password prompt dialogue

New in pgAdmin 4 4 1.6 (Jul 14, 2017)

  • Features:
  • Feature #1344 - Allow the Query Tool, Debugger and web browser tabs to be moved to different monitors as desired
  • Feature #1533 - Set focus on the first enabled field when a dialogue is opened
  • Feature #1535 - Teach dialogues about Escape to cancel, Enter to Save/OK, and F1 for help
  • Feature #1971 - Retain column sizing in the query tool results grid when the same query is re-run multiple times in a row
  • Feature #1972 - Prompt the user to save dirty queries rather than discard them for a more natural workflow
  • Feature #2137 - On-demand loading for the query tool results
  • Feature #2191 - Add support for the hostaddr connection parameter. This helps us play nicely with Kerberos/SSPI and friends
  • Feature #2282 - Overhaul the query history tab to allow browsing of the history and full query text
  • Feature #2379 - Support inserting multiple new rows into a table without clicking Save for each row
  • Feature #2485 - Add a shortcut to reset the zoom level in the runtime
  • Feature #2506 - Allow the user to close the dashboard panel
  • Feature #2513 - Add preferences to enable brace matching and brace closing in the SQL editors
  • Bug fixes:
  • Bug #1126 - Various FTS dictionary cleanups
  • Bug #1229 - Fix default values and SQL formatting for event triggers
  • Bug #1466 - Prevent attempts to debug procedures with variadic arguments
  • Bug #1525 - Make $ quoting consistent
  • Bug #1575 - Properly display security labels on EPAS 9.2+
  • Bug #1795 - Fix validation for external and range types
  • Bug #1813 - List packages in PPAS 9.2-9.4 when creating synonyms
  • Bug #1831 - Fix server stats display for EPAS 9.2, where inet needs casting to text for concatenation
  • Bug #1851 - Reverse engineer SQL for table-returning functions correctly
  • Bug #1860 - Ensure default values are honoured when adding/editing columns
  • Bug #1888 - Fix various issues with pgAgent job steps and schedules
  • Bug #1889 - Fix various issues with pgAgent job steps and schedules
  • Bug #1890 - Fix various issues with pgAgent job steps and schedules
  • Bug #1920 - Ensure saved passwords are effective immediately, not just following a restart when first saved
  • Bug #1928 - Fix the handling of double precision[] type
  • Bug #1934 - Fix import/export to work as expected with TSV data
  • Bug #1999 - Handle warning correctly when saving query results to an unmounted USB drive
  • Bug #2013 - Increase the default size of the Grant Wizard to enable it to properly display privileges at the default size on smaller displays
  • Bug #2014 - To fix unexpected behaviour displayed if user stops debugging on package/procedure fire_emp
  • Bug #2043 - Properly handle trigger functions with parameters
  • Bug #2078 - Refresh the SQL editor view on resize to ensure the contents are re-rendered for the new viewport
  • Bug #2086 - Allow editing of the WITH ADMIN option of role membership
  • Bug #2113 - Correct the validation logic when modifying indexes/exclusion constraints
  • Bug #2116 - Enable dialogue help buttons on Language and Foreign Table dialogues
  • Bug #2142 - Fix canceling of Grant Wizard on Windows
  • Bug #2155 - Fix removal of sizes from column definitions
  • Bug #2162 - Allow non-superusers to debug their own functions and prevent them from setting global breakpoints
  • Bug #2242 - Fix an issue in NodeAjaxControl caching with cache-node field and add cache-node field in Trigger & Event trigger node so that whenever the user creates new Trigger Function we get new data from server in NodeAjaxControl
  • Bug #2280 - Handle procedure flags (IMMUTABLE STRICT SECURITY DEFINER PARALLEL RESTRICTED) properly in RE-SQL on EPAS
  • Bug #2324 - Fix the PostGIS Datatypes in SQL tab, Create / Update dialogues for Table, Column, Foreign Table and Type node
  • Bug #2344 - Fix issue with ctrl-c / ctrl-v not working in query tool
  • Bug #2348 - Fix issue when resizing columns in Query Too/View Data where all row/colums will select/deselect
  • Bug #2355 - Properly refresh the parent node when renaming children
  • Bug #2357 - Cache statistics more reliably
  • Bug #2381 - Fix the RE-SQL for for views to properly qualify trigger function names
  • Bug #2386 - Display and allow toggling of trigger enable/disable status from the trigger dialogue
  • Bug #2398 - Bypass the proxy server for local addresses on Windows
  • Bug #2400 - Cleanup handling of default/null values when data editing
  • Bug #2414 - Improve error handling in cases where the user tries to rename or create a server group that would duplicate an existing group
  • Bug #2417 - Order columns in multi-column pkeys correctly
  • Bug #2422 - Fix RE-SQL for rules which got the table name wrong in the header and DROP statement
  • Bug #2425 - Handle composite primary keys correctly when deleting rows in the Edit Grid
  • Bug #2426 - Allow creation of ENUM types with no members
  • Bug #2427 - Add numerous missing checks to ensure objects really exist when we think they do
  • Bug #2435 - Pass the database ID to the query tool when using the Script options
  • Bug #2436 - Ensure the last placeholder is included when generating UPDATE scripts for tables
  • Bug #2448 - Ensure that boolean checkboxes cycle values in the correct order
  • Bug #2450 - Fix error on the stats tab with PG10. Also, rename the 10.0_plus template directory to 10_plus to match the new versioning
  • Bug #2461 - Allow users to remove default values from columns properly
  • Bug #2468 - Fix issue where function create script won’t compile
  • Bug #2470 - Fix an intermittent error seen during result polling
  • Bug #2476 - Improvements to the Query Results grid including improvements to the UI and allow copy/paste from sets of rows, columns or arbitrary blocks of cells
  • Bug #2477 - Ensure text editors render in an appropriate place on the results grid
  • Bug #2479 - No need for the menu icon to link to the homepage, as pgAdmin is a SPA
  • Bug #2482 - Use a more sensible name for Query Tool tabs
  • Bug #2486 - Ensure the feature tests use the correct test settings database
  • Bug #2487 - Maintain a client-side cache of preference values, populated using an async call
  • Bug #2489 - Fix clipboard handling with large datasets
  • Bug #2492 - Ensure the initial password is properly hashed during setup in web mode
  • Bug #2498 - Properly handle bytea[], and ‘infinity’::real/real[]
  • Bug #2502 - Properly handle bytea[], and ‘infinity’::real/real[]
  • Bug #2503 - Handle missing/dropped synonyms gracefully
  • Bug #2504 - Update MatView and pgAgent modules to work with recent integer/numeric changes
  • Bug #2507 - Ensure revoked public privileges are displayed in the RE-SQL for functions
  • Bug #2518 - Fix encoding issue when saving servers
  • Bug #2522 - Improve speed of Select All in the results grid
  • Bug #2527 - Fix deletion of table rows with the column definition having NOT NULL TRUE and HAS NO DEFAULT VALUE
  • Bug #2528 - Allow breakpoints to be set on triggers on views
  • Bug #2529 - Resolve a number of issues with domains and domain constraints
  • Bug #2532 - Refresh nodes correctly when there is a single child that is updated
  • Bug #2534 - Fix handling of CREATE TABLE OF
  • Bug #2535 - Fix clear history functionality
  • Bug #2540 - Ensure the save password option is enabled when creating a server

New in pgAdmin 4 4 1.5 (Jun 8, 2017)

  • Features:
  • Feature #2216 - Allow column or row selection in the query tool
  • Bug fixes:
  • Bug #2225 - Hide menu options for creating objects, if the object type is set to hidden. Includes Jasmine tests
  • Bug #2253 - Fix various issues in CSV file download feature
  • Bug #2257 - Improve handling of nulls and default values in the data editor
  • Bug #2271 - Don’t change the trigger icon back to “enabled” when the trigger is updated when it’s disabled
  • Bug #2284 - Allow creation of tables with pure numeric names
  • Bug #2292 - Only reconnect to databases that were previously connected
  • Bug #2314 - Fix various issues in CSV file download feature
  • Bug #2315 - Fix sorting of sizes on the statistics views by sorting raw values and prettifying on the client side. Includes Jasmine tests for the prettyfying function
  • Bug #2318 - Order foreign table columns correctly
  • Bug #2331 - Fix binary search algorithm so new treeview nodes are added in the correct position
  • Bug #2336 - Update inode info when refreshing treeview nodes.
  • Bug #2339 - Ensure the treeview can be scrolled horizontally
  • Bug #2350 - Fix handling of default parameters ordering in functions
  • Bug #2354 - Fix the Backup module where it was not working if user changes its preference language other than English
  • Bug #2356 - Ensure errors thrown when deleting rows in the query tool in edit mode are shown properly
  • Bug #2360 - Fix various issues in CSV file download feature
  • Bug #2369 - Support loading files with Unicode BOMs
  • Bug #2377 - Update psycopg2 version for PostgreSQL 10 compatibility
  • Bug #2379 - Make various improvements to the NULL/DEFAULT handling in the data editor
  • Bug #2405 - Ensure object names are properly escaped for external process management
  • Bug #2410 - Fix PostgreSQL 10.0 compatibility issues

New in pgAdmin 4 4 1.4 (Apr 14, 2017)

  • 30 bug fixes and improvements.

New in pgAdmin 4 4 1.3 (Mar 13, 2017)

  • Includes over 30 bug fixes and improvements.

New in pgAdmin 4 1.22.1 (Apr 16, 2016)

  • Don't barf when connecting to Greenplum or Greenplum HAWQ [Andreas 'ads' Scherbaum]
  • Fix selection of conversion functions in the CREATE CONVERSION dialogue [Dmitry Voronin]
  • Properly quote type names in the Type dialogue, and ensure range information is displayed for existing types [Akshay Joshi]
  • Fix selection of cast functions in the Cast dialogue [Sanket Mehta]

New in pgAdmin 4 1.22.0 (Jan 10, 2016)

  • Resolved an issue related to check options selection in the view properties dialog with the check option. [Reported by: Sebastian Albert, Patched by: Neel Patel]
  • Merged the libssh2 to the latest version. [Akshay Joshi]
  • Properly detect serial columns as such when identifiers have been truncated.
  • Fixes an issue related to the column inheritance information properly, when one (or, more) common columns are inherited from multiple tables. [Reported by: Liu Yuanyuan, Patched by: Akshay Joshi]
  • Ensure the correct syntax used for moving the objects from one tablespace to another. [Sanket Mehta]
  • Ensure the correct line endings are used when copying from the SQL Pane [Nikolai Zhubr]
  • Toolbar icons, and menu items for Commit and Rollback actions. [John Obaterspok]
  • Display the connection details for the current browser object in the status bar [Adam Scott]
  • Fixed an issue related to different menus enabling in the Query Tool on Ubunutu unity. [Reported by: Vahdet Mert]
  • Reset the position (x, y) for dialog(s), and frame(s) to 0 (if found negative), while saving its position and size. [Reported By: Mark, Patch: Sanket Mehta, Reworked, and Reviewed: Ashesh]
  • Fixes an issue identifying the return type to TABLE in some cases, using pg_get_function_result(..) for the same instead of format_type(..) [Reported By: Guillermo E. Villanueva, PATCH:Sanket Mehta]
  • Honour PGPASSFILE environment variable for saving, retrieving the password instead of always works with pgpass.conf (on windows)/.pgpass (on non-windows) [PATCH: Prasad Somwanshi, Reworked by: Sanket Mehta, Reviewed by: Ashesh Vashi, Sanket Mehta]
  • Fix a segfault occurs while detecting transaction section requirement, when autocommit has been disabled. [Reported by John Obaterspok, Patch by Sanket Mehta]
  • Format execution time in a more readable manner [John Obaterspok]
  • Improve sorting in Data editor [J. F. Oster, Reviewed by Sanket Mehta]
  • Allow to format the selecte SQL using external tools in Query Editor [J. F. Oster]
  • Allow to set auto-commit mode to on/off in the query editor [Sanket Mehta]

New in pgAdmin 4 1.20.0 (Feb 20, 2015)

  • Resolving the inconsistency of preservation of modified information of the columns, while adding/editing a table from the table dialog [Reported by Jasmine Liu, Patch from Sanket Mehta, and reviewed by Akshay Joshi and me]
  • Add missing nodes to graphical explain plan [J.F. Oster]
  • Fix the Resource Groups dialog - separated the statements, which can not be ran in single transaction [Akshay Joshi]
  • Support for Slony-I 2.2+ with PostgreSQL 9.3+ [Neel Patel, Akshay Joshi, Sanket Mehta, Ashesh Vashi]
  • Support smallserial columns in Edit Data Window [J.F. Oster]
  • Restore the user specified size on the grid (which contains the result) in Query windows to fix an issue related to the column size is too narrow on subsequent Explain execution [J.F. Oster]
  • Empty the Undo/Redo history everytime new file is opened [J.F. Oster]
  • Added accelerator F8 for 'Execute to file' in the Query window [Mads Jensen]
  • Beautify the query shown in the SQL pane for the functions having multiple arguments by adding new lines with small modification by me [J.F. Oster]
  • Check for the columnlist for the UPDATE OF syntax on trigger also works with PPAS 9.5+ [Sanket Mehta]
  • Proper saving of columns width in the server status window [Dmitriy Olshevskiy]
  • Fix support for triggers with inline code on PPAS [Sanket Mehta]
  • CHECK OPTION is applicable to the views only, and not the materialized views
  • Prevent a crash during the update of the macro or favourite list [Dmitriy Olshevskiy]
  • Allow quick injectection of favourites by name [J.F. Oster]
  • Fix handling of saving macros after pasting a query in the box [Dmitriy Olshevskiy]
  • Fix SQL for GRANT on a sequence. Report from liuyuanyuan.
  • Fix handling of char()[] columns in the Edit Grid [Dmitriy Olshevskiy]
  • Support the new check_option parameter of views
  • Handle the 9.4 MOVE clause of ALTER TABLESPACE
  • Add a new action menu to refresh a materialized view
  • Support the new 9.4 columns in pg_stat_activity
  • Save search options for next time [Dimitriy Olshevskiy]
  • Ensure Favourite queries are only saved when the OK button is pressed [Dmitriy Olshevskiy]
  • Fix an issue refreshing functions in PPAS packages [Akshay Joshi]
  • Improve handling of lost connections [Ashesh Vashi]
  • Allow searching for database objects by comment and definition content [J.F. Oster]
  • Add support for Resource Groups in PPAS 9.4 [Akshay Joshi]
  • Add Save and Exit shortcut keys to the edit grid [Fredrik de Vibe]

New in pgAdmin 4 1.18.0 (Sep 12, 2013)

  • Fix a layout bug in the graphical explain renderer that could render nodes on top of each other.
  • Fix Slony's DDL Script support [Akshay Joshi].
  • Add support for Event Triggers in 9.3+ [Dinesh Kumar].
  • Avoid using a Help cache file that needs to be world writeable, and ensure sed is happy when post-processing helpfiles.
  • Fix the help path on the import dialogue and improve the error handling [Akshay Joshi].
  • Fix path the the Search Objects help doc [Dhiraj Chawla].
  • Fix UTF-8 display for guru hints [Marek Cernocky].
  • Prevent a crash when creating a stored procedure in PPAS [Dinesh Kumar].
  • Disable the Favourites menu items if there is no favourites file path (per a comment from Michael Shapiro).
  • Make No the default button on the Truncate confirmation dialog (per request from Humberto Cereser Ibanez).
  • Support Materialized Views [Neel Patel].
  • Avoid a possible crash on Linux when using the "Script" options of the Query Tool [aditsu].
  • Fix comments on constraints [Thom Brown].
  • Fix schema prefixes in cast definitions in the browser.
  • Treat sequences as first class objects in the Grant Wizard. Support USAGE and remove obsolete RULE permissions [Dhiraj Chawla].
  • Set the default backup type to "Custom".
  • Improve the copy handling on the Edit Grid so that it works more consistently and predictably.
  • Fix comments on columns.
  • Remove the "Apply" buttons from the function, view package and external table dialogues. Their use is discouraged, and the code is fragile, complex and very buggy.
  • Fix a crash that could occur if the browser fails to detect that an object has been changed by another session.
  • Change the default SQL box font to a slightly smaller size on GTK based platforms.
  • Don't prompt the user for a password if they're using a client certificate.
  • Ensure global backups use the mintenance database to avoid access issue with postgres or template1.
  • Fix SSL certificate authentication.
  • Fix renaming and schema changes for stored procedures in PPAS [Dinesh Kumar].
  • Add SSH tunnelling support to allow connections to be made to hosts via an SSH server [Akshay Joshi].
  • Display the index validity in the properties list for indexes and index-based constraints [Gabrielle Roth].
  • Add an option to include column headers when copying from the query tool results [Jasmin Dizdarevic].
  • Allow the decimal mark displayed by the query tool to be configured as the thousands separator can [Jasmin Dizdarevic].
  • Ensure the Query Tool's maximum column length setting is honoured.
  • Handle default privileges to PUBLIC correctly. [Dhiraj Chawla].
  • Add tab option in the Import dialog. Per a request from Jeff Janes.
  • Add smallserial handling. Per a request from Matthew Syphus.
  • Fix the editing of pg_hba.conf files [Dhiraj Chawla].
  • Fix the display of extension owner names.
  • Add a title to the backup and restore windows. Per request from Bastiaan Olij.
  • Fix a bug that could cause a NOTICE to be displayed when rendering FTS Configurations in the tree.
  • Don't try to display dependents or dependencies for pgAgent jobs, schedules or steps.
  • Fix the handling of expiry times when modifying roles.
  • Prevent foreign keys being recreated unnecessarily when modifying tables [Michael Banck]
  • Prevent Cmd+S adding characters to the Query Tool when the Save button is disabled.
  • Fix handling of Greenplum partitions [Lubomir Petrov]
  • Add -V/--version CLI option.
  • Add actions menu to the serverstatus tool.
  • Fix the database SQL when reseting a configuration parameter. Per a report from Bartosz Dmytrak.
  • Refresh the toolbar buttons when a list has been updated. Per a report from Evan Martin.
  • Fix the "NO INHERIT" query. Report from Thomas Joseph.
  • Display default privs. Report from Nathan Alden.
  • Sort references by schema name and relation name in dlgForeignKey. Report from Michal Kozusznik.
  • Fix the change of the superuser attribute. Report from Michal Kozusznik.
  • Prevent a crash when using Cmd-A on a file loaded into the Query Tool when opened with Cmd-E on Mac.
  • Fix the queries used to get object comments to allow for duplicate OIDs that may be present following use of pg_upgrade.

New in pgAdmin 4 1.16.0 (Oct 3, 2012)

  • Move references table textbox to the third tab in dlgForeignKey.

New in pgAdmin 4 1.14.3 (Jun 8, 2012)

  • Don't reset breakpoints when folding code
  • Fix crashes by limiting the size of explainPopup.
  • Various fixes on indexes, per Colin Beckingham.
  • Fix constraint triggers SQL, per Michael Brux.
  • Fix line offsets in the debugger when used with 9.1 servers [Heikki Linnakangas].
  • Fix domains over array types [Thom Brown].
  • Fix SQL query to get types for function return and arguments. Per a report from Erwin Brandstetter.
  • Fix RE of options in foreign tables. Report from Regina.
  • Fix handling of parameter handling for edbspl functions and package procedures/functions.
  • Fix server reconnect option when the browser becomes disconnected from the server.
  • Fix the SQL when adding a new index without a name, but with a comment or a CLUSTER. Per report from Bartosz Dmytrak.
  • Fix the reverse-engineered SQL for SQL/MED server. Per report from Bartosz Dmytrak.
  • Drop autovacuum ANALYZE parameters for TOAST tables. Per report from Bartosz Dmytrak.
  • Fix deleting lines in frmEditGrid with 64bit systems [Steven Elliott]
  • Fix the reverse-engineered SQL of an operator. Per report from Bartosz Dmytrak.
  • Fix handling of DEFAULT ACLs in the restore dialog [Dharmendra Goyal]
  • Fix the restore of a window position when using multiscreen. Per report from Steffen Decker.
  • Fix the SQL when a user changes a trigger. Per report from Bartosz Dmytrak.
  • Make sure that queries use LIKE with _ escaped.
  • Fix enabling the OK button of the view dialog. Per report from Colin Beckingham.
  • Fix the trigger SQL. Per report from Attila.
  • Another fix on the autovacuum widgets in the table dialog. Report from Bartosz Dmytrak.
  • Fix setting the connection for pgScript, per report from Charles Gutjahr.
  • Extensions have no owner. Per report from James B. Byrne.
  • Fix the handling of empty strings in the histoqueries file. Per report from Bartosz Dmytrak.

New in pgAdmin 4 1.14.2 (Feb 28, 2012)

  • Fix the SQL for existing triggers, per report from Bartosz Dmytrak.
  • Fix the SQL for existing extensions.
  • Correctly save the position of a pgDialog.
  • Fix the copy of a query when application_name is unset.
  • Fix query handling on the frmStatus window, per report from Aren Cambre.
  • Record a password in .pgpass only if not empty. Per complaint from Michael Shapiro, and Vik Reykja.
  • Fix the reverse-engineered SQL for types.
  • Fix dlgType minimum size.
  • Fix enabling/disabling trigger with the trigger contextual menu. Report from Bartosz Dmytrak.
  • Fix the autovacuum widgets in the table dialog when using a language other than english. Report from Bartek.
  • Highlight the log pane widgets at the frmStatus startup.
  • Ensure job steps and schedules are listed properly on the Job dialogue, and avoid defaulting empty end dates to today on the schedule dialogue.
  • Fix the default column widths of the list controls on the main window on Linux [Dhiraj Chawla]
  • Increase the size of the label on the password dialog to avoid text being obscured with longer server descriptions [Dharmendra Goyal]
  • Fix the "drop object?" warning on Slony objects and PPAS synonyms [Dhiraj Chawla].
  • Fix comment modification on Slony Clusters [Akshay Joshi]
  • Fix loss of column changes through table properties when re-editing. Report from Thom Brown.
  • Show columns' variable in the SQL pane of a table. Report from Thom Brown.
  • Fix the refresh on frmMain. Per report from Bartek.
  • Fix the constraint trigger query.
  • Allow SSL use.
  • Fix reading the histoquery file because of wrong file.
  • Fix constraints handling on the table properties dialog, per report from Vjacheslav Vjacheslav.
  • Avoid crashing when working with objects with % in the name.
  • Fix VARIADIC handling with DEFAULT value, per report from Regina.
  • Fix DEFAULT clause handling in ALTER FUNCTION, per report from Regina.
  • Fix compilation on Debian Sid, per report from Philippe Rimbault, and Gerfried Fuchs.
  • Fix handling of EXTENSIONs in the restore dialogue.

New in pgAdmin 4 1.10.0 (Sep 11, 2009)

  • Highlights of the new release include a graphical query builder, a scripting engine in the query tool and support for PostgreSQL 8.4.

New in pgAdmin 4 1.8.4 (Oct 28, 2008)

  • Fix potential crash bug in the query tool logging code, per Erwin.

New in pgAdmin 4 1.8.2 (Feb 9, 2008)

  • Size of the column label of SQLGrid was made variable.
  • Prevent a crash when viewing databases with % in the name.
  • Don't try to force new databases into a specific tablespace as this will error as non-superusers default to pg_default.
  • Correct the SQL generation for EDB inline triggers.
  • Generate function signatures correctly if the first parameters are OUT only.
  • Remove the confusing and near-useless sequence combo box from the column dialog per discussion on support list.
  • Fix the WITH ADMIN membership option when creating roles.
  • Refresh Views correctly on EnterpriseDB.
  • Fix the privilege editor on the Language dialogue, per Bborie Park.
  • Correctly identify the schema of trigger functions that are in system catalogs as can be the case with integrated full text search.
  • Warn the user if a file cannot be saved in the default encoding.
  • Undecorated out-param types must be included in EDB-SPL function signatures when altering comments or privileges or dropping functions or procedures.
  • Ensure enums are offered as datatypes for columns.
  • Fix column dialogue to allow proper modification of array columns per Erwin.
  • Newer build of EnterpriseDB consistently strip trailing semi-colons from package headers and bodies. Update reverse engineering allow for this.
  • Ensure the properties dialogues will work sanely with objects named " " (!).
  • EDB-SPL functions require NULL to be passed in out-params when debugging.
  • Ensure that EDB-SPL trigger DDL code is appropriately formatted on newer builds of EnterpriseDB.
  • Ensure the password and confirmed password always match when adding or editing roles or users.