PEM v7.10

Release date: 2019-10-09

Features

Issue #PEM-952 - Allow to configure and manage the BART server through PEM (limited functionalities)
Issue #PEM-2088 - Allow a banner to be displayed on the login and other related pages showing custom text. (869690)
Issue #PEM-2152 - Allow to manage and monitor PostgreSQL 12 and EDB Postgres Advanced Server 12.
Issue #3009 - Added Copy with headers functionality when copy data from Query Tool/View Data.
Issue #4144 - Add support of Compound Triggers for EPAS 12+.
Issue #4139 - Allow some objects to be dragged/dropped into the Query Tool to insert their signature into the query text.
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 #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.
Issue #4667 - Ensure editable and read-only columns in Query Tool should be identified by icons and tooltips in the column header.

Housekeeping

Issue #4472 - Add Reverse Engineered and Modified SQL tests for Synonyms.
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.
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 #4628 - Add Reverse Engineered and Modified SQL tests for Unique Constraints.
Issue #4690 - Add Modified SQL tests for Resource Group.

Bug fixes

Issue #PEM-706 - Changed the label from “Blocked Users” to “Blocked Sessions” on User Activity chart. (661653)
Issue #PEM-2492 - Ensure parameter values are quoted when needed when editing roles. (876762)
Issue #PEM-2581 - Error when changing kind(SQL/BATCH) for pgAgent job step. (893794)
Issue #PEM-2727 - Upgrading SNMP to fix the agent crash issue (913881)
Issue #2706 - Added ProjectSet icon for explain module.
Issue #2828 - Added Gather Merge, Named Tuple Store Scan and Table Function Scan icon for explain module.
Issue #3605 - Fix issue where Deleting N number of rows makes first N number of rows disable.
Issue #3778 - Ensure Boolean columns should be editable using keyboard keys.
Issue #3936 - Further code refactoring to stabilise the Feature Tests.
Issue #4179 - Fix generation of reverse engineered SQL for tables with Greenplum 5.x.
Issue #4199 - Ensure that ‘ENTER’ key in the data filter should not run the query.
Issue #4229 - Update wcDocker to allow the browser’s context menu to be used except in tab strips and panel headers.
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 #4401 - Ensure type names are properly encoded in the results grid.
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 #4414 - Fix generation of reverse engineered SQL for partition table, partitions were shown as a child of indexes.
Issue #4419 - Fix a debugger error when using Python 2.7.
Issue #4429 - Ensure drag/drop from the treeview works as expected on Firefox.
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 #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 #4577 - Fix an error that could be seen when click on any system column of a table.
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 #4584 - Unescape HTML entities in database names in the Query Tool title bar.
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 #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 #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.
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 #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 #4742 - Ensure Primary Key should be created with Index.
Issue #4750 - Fix query history exception for Python 3.6.
Issue #4756 - Fix issue where PEM/pgAdmin does not load completely if loaded in an iframe.
Issue #4777 - Fix issue where query history is not visible in the query history tab.