Release date: 2017-02-10

This release contains a number of features and fixes reported since the release of pgAdmin4 1.1.

Features

Feature #1375 - Migrate the runtime to QtWebEngine from QtWebKit
Feature #1765 - Find and replace functionality with regexp and group replacement
Feature #1789 - Column width of data output panel should fit to data (as pgAdmin III)
Feature #1790 - [Web] Support setting a field’s value to "null"
Feature #1848 - macOS appbundle is missing postgresql binaries for import etc.
Feature #1910 - Remember last used directory in the file manager
Feature #1911 - Direct path navigation in the file manager
Feature #1922 - Improve handling of corrupt configuration databases
Feature #1963 - Add a Chinese (Simplified) translation
Feature #1964 - Create a docs tarball along with the source tarball
Feature #2025 - Allow the SQL Editors to word-wrap
Feature #2124 - Create a template loader to simplify SQL template location, and remove duplicate templates

Bug fixes

Bug #1227 - Display improved error message for Debugger listener starting error and reset between executions
Bug #1267 - Fix issue where MINIFY_HTML doesn’t work with the docs
Bug #1364 - Ensure dialogue control buttons are consistent
Bug #1394 - Fix Table dialogue column specification issues
Bug #1432 - Enhanced OSX File Browser
Bug #1585 - Cannot save scripts to the network
Bug #1599 - Ensure the grant wizard works with objects with special characters in the name
Bug #1603 - Fix quoting of objects names for external utilities.
Bug #1679 - Re-engineer the background process executor to avoid using sqlite as some builds of components it relies on do not support working in forked children
Bug #1680 - Render column headers at the correct width in the query tool under Firefox
Bug #1729 - Improve display of role options
Bug #1730 - Improve the display of role membership on both the properties panel and role dialogue
Bug #1745 - Ensure breakpoints are cleared properly when working with Debugger
Bug #1747 - Add newly created triggers to the treeview
Bug #1780 - Properly size the SQL Editor gutter as the width of the line numbers increases
Bug #1792 - List files and folders alphabetically
Bug #1800 - Handle the template property on databases appropriately
Bug #1801 - Handle databases with datallowconn == false
Bug #1807 - Properly detect when files have changed in the query tool and set flag accordingly
Bug #1830 - Fix a SQL error when reverse-engineering ROLE SQL on EPAS servers
Bug #1832 - Prevent attempts to access what may be an empty list in Dependancies tab
Bug #1840 - Enable/disable NULLs and ASC/DESC options for index columns and exclusion constraints appropriately
Bug #1842 - Show index columns in the correct order in RE-SQL
Bug #1855 - Ensure dialogue panels show their errors themselves, and not in the properties panel when creating Trigger Function
Bug #1865 - Properly schema qualify domains when reverse engineering SQL
Bug #1874 - Add file resources to the windows runtime
Bug #1893 - Fix refreshing of Unique constraints
Bug #1896 - Use the correct OID for retrieving properties of freshly created exclusion constraints
Bug #1899 - Properly quote role names when specifying function ownership
Bug #1909 - Handle startup errors more gracefully in the runtime
Bug #1912 - Properly format arguments passed by triggers to functions
Bug #1919 - Ensure all changes to rows are stored in the data editor
Bug #1924 - Ensure the check_option is only set when editing views when appropriate
Bug #1936 - Don’t strip rn from "Download as CSV" batches of rows, as it leads to malformed data
Bug #1937 - Generate mSQL for new schemas correctly
Bug #1938 - Fix sorting of numerics in the statistics grids
Bug #1939 - Updated dynamic default for the window size (90% x 90%)
Bug #1949 - Ensure trigger function names are schema qualified in trigger RE-SQL
Bug #1951 - Fix issue where nnable to browse table columns when oid values exceeed max int
Bug #1953 - Add display messages and notices received in the query tool
Bug #1961 - Fix upgrade check on Python 3
Bug #1962 - Ensure treeview collection nodes are translated in the UI
Bug #1967 - Store layout changes on each adjustment
Bug #1976 - Prevent users selecting elements of the UI that shouldn’t be selectable
Bug #1979 - Deal with Function arguments correctly in the properties dialogue
Bug #1986 - Fix various encoding issues with multibyte paths and filenames resulting in empty file save
Bug #1992 - Quote identifiers correctly in auto-complete
Bug #1994 - Update to show modifications in edit grid
Bug #2000 - Allow setting of effective_io_concurrency on tablespaces in 9.6+
Bug #2005 - Fix various mis-spellings of VACUUM
Bug #2006 - Fix error when modifying table name or set schema on tables with postgis geometry column
Bug #2007 - Correctly sort rows by the pkey when viewing first/last 100
Bug #2009 - Reset the column list properly if the access method is changed on an index to ensure error handling works correctly
Bug #2012 - Prevent attempts to create server groups with no name
Bug #2015 - Enable trigger option when user tries to change Row trigger value through properties section
Bug #2024 - Properly handle setting comments and other options on databases with allowconn = False
Bug #2026 - Improve detection of the pldbgapi extension and functions before allowing debugging
Bug #2027 - Fix inconsistent table styling
Bug #2028 - Fix display of double scrollbars on the grant wizard
Bug #2032 - Fix time formatting on dashboards
Bug #2033 - Show icons for unique and exclusion constraints in the dependency/dependents panels
Bug #2045 - Update copyright year on doc page
Bug #2046 - Fix error when setting up regression on Windows for pgadmin4
Bug #2047 - Ensure dialogues cannot be moved under the navbar
Bug #2061 - Enable/disable NULLs and ASC/DESC options for index columns and exclusion constraints appropriately
Bug #2065 - Improve display of columns of exclusion contraints and foreign keys in the properties lists
Bug #2069 - Correct tablespace displayed in table properties
Bug #2076 - Handle sized time/timestamp columns correctly
Bug #2109 - Update copyright year
Bug #2110 - Handle saved directories that no longer exist gracefully
Bug #2112 - Enable comments on Initial database through right Click
Bug #2133 - Fix display of graphical query plans for UPDATE/DELETE queries
Bug #2138 - Fix display of zeros in read-only grid editors
Bug #2139 - Fixed issue causing Message (Connection to the server has been lost.) displayed with Materialized view and view under sql tab
Bug #2152 - Fix handling of "char" columns
Bug #2156 - Added compatibility fixes for newer versions of Jinja2 (e.g. 2.9.5+)