PEM v7.12

Release date: 2019-12-02

Features

PEM-2477 - Allow the pemAgent to create a password-less SSH authentication between two linux systems. User can now choose to create it from the database server properties dialog, and backup restore dialog.
PEM-2848 - Allow the pemAgent to set/override the ‘archive_command’ of the database server configuration using ‘BART INIT’ command. User can choose to set/override the ‘archive_command’ from the database server properties dialog.
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 changes on a Properties dialog.
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 #4990 - Changed the open query tool and data filter icons.

Housekeeping

Issue #4696 - Add Reverse Engineered and Modified SQL tests for Materialized Views.
Issue #4701 - Optimize Webpack to improve overall performance.
Issue #4807 - Refactored code of table and it’s child nodes.
Issue #4938 - Refactored code of columns node.

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 #3538 - Fix issue where the Reset button does not get enabled till all the mandatory fields are provided in the dialog.
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 #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 #4516 - Remove the sorting of table headers with no labels.
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 #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 #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 #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 #4779 - Updated documentation for the query tool toolbar buttons.
Issue #4792 - Ensure that the superuser should be able to create database, as the superuser overrides all the access restrictions.
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 #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 #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 #4930 - Fix main window tab navigation accessibility issue.
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 PEM 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 #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.