PEM v7.9

Release date: 2019-07-31

Features

Issue #PEM-2525 - Send SMTP notification on the completion of a scheduled task
Issue #PEM-2526 - Schedule a SHELL/BATCH script, SQL based jobs at agent level
Issue #PEM-2048 - Allow to configure pem-server without disabling the selinux on RHLE/CentOS (883342)
Issue #1760 - Add support for editing of resultsets in the Query Tool, if the data can be identified as updatable.
Issue #2653 - Allow the UI layout to be fully locked or to prevent docking changes.
Issue #3174 - Visually distinguish simple tables from tables that are inherited and from which other tables are inherited.
Issue #4283 - Initial support for PostgreSQL 12.
Issue #4288 - Initial support for PostgreSQL 12.
Issue #4290 - Initial support for PostgreSQL 12.
Issue #4318 - Set the mouse cursor appropriately based on the layout lock state.
Issue #4335 - Add EXPLAIN options for SETTINGS and SUMMARY.

Housekeeping

Issue #4202 - Add a framework for testing reversed engineered SQL and CRUD API endpoints.
Issue #4415 - Add Reverse Engineered SQL tests for Roles and Resource Groups.
Issue #4441 - Add Reverse Engineered SQL tests for FDWs.
Issue #4450 - Fix reverse engineered sql for Foreign Data Wrapper created on EPAS server in redwood mode.
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.

Bug fixes

Issue #PEM-2459 - Tuning wizard shows wrong original value for ‘max_wal_size’ parameter [Support Ticket #880186]
Issue #PEM-2499 - Index Advisor is not suggesting index on PEM UI. [Support Ticket #891318]
Issue #PEM-2503 - Issue while scheduling the pgAgent job on PEM UI. [Support Ticket #891220]
Issue #3919 - Allow keyboard navigation of all controls on subnode grids.
Issue #3994 - Fix issue where the dependencies tab for inherited tables/foreign keys shows partial text.
Issue #3996 - Fix dropping of pgAgent schedules through the Job properties.
Issue #4036 - Allow editing of data where a primary key column includes a % sign in the value.
Issue #4162 - Fix syntax error when adding more than one column to the existing table.
Issue #4169 - Omit the geometry viewer in the Query Tool from layout saving.
Issue #4171 - Fix issue where reverse engineered SQL was failing for foreign tables, if it had “=” in the options.
Issue #4195 - Fix keyboard navigation in “inner” tabsets such as the Query Tool and Debugger.
Issue #4224 - Prevent flickering of large tooltips on the Graphical EXPLAIN canvas.
Issue #4228 - Ensure the correct label is used in panel headers when viewing filtered rows.
Issue #4253 - Fix issue where new column should be created with Default value.
Issue #4255 - Prevent the geometry viewer grabbing key presses when not in focus under Firefox, IE and Edge.
Issue #4284 - Fix syntax error when creating a table with a serial column.
Issue #4320 - Fix issue where SSH tunnel connection using password is failing, it’s regression of Master Password.
Issue #4329 - Fix an initialisation error when two functions with parameters are debugged in parallel.
Issue #4343 - Fix issue where property dialog of column should open properly for EPAS v12.
Issue #4345 - Capitalize the word ‘export’ used in Import/Export module.
Issue #4349 - Ensure strings are properly encoded in the Query History.
Issue #4350 - Ensure we include the CSRF token when uploading files.
Issue #4360 - Ensure the debugger control buttons are only enabled once initialisation is complete.
Issue #4362 - Remove additional “SETOF” included when generating CREATE scripts for trigger functions.
Issue #4365 - Fix help links for backup globals and backup server.
Issue #4367 - Fix an XSS issue seen in View/Edit data mode if a column name includes HTML.
Issue #4378 - Ensure Python escaping matched JS escaping and fix a minor XSS issue in the Query Tool that required superuser access to trigger.
Issue #4380 - Ensure that both columns and partitions can be edited at the same time in the table dialog.
Issue #4386 - Fix an XSS issue when username contains XSS vulnerable text.
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 #4403 - Ensure the browser close confirmation is only shown when closing a Query Tool which is running in a separate browser tab.
Issue #4404 - Prevent an error that may occur when editing data with an integer primary key.
Issue #4407 - Fix a quoting issue that caused a blank UI to be displayed when running in French.
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 #4437 - Fix table icon issue when updating any existing field.
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 #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.