- Update to pgadmin4 4.3
- Features
* Install a script to start pgAdmin (pgadmin4) from the command
line when installed from the Python wheel.
* Add a “scratch pad” to the Query Tool to hold text snippets
whilst editing.
* Add Commit and Rollback buttons to the Query Tool.
* Allow X-FRAME-OPTIONS to be set for security. Default to
SAMEORIGIN.
* Automatically expand child nodes as well as the selected node
on the treeview if there is only one.
* Include multiple versions of the PG utilties in containers.
* Update Alpine Linux version in the docker container.
* Support double-click on Query Tool result grid column resize
handles to auto-size to the content.
- Bug fixes
* Ensure size stats are prettified on the statistics tab when
the UI language is not English.
* Handle display of roles with expiration set to infinity
correctly.
* Allow editing of values in columns with the oid datatype
which are not an actual row OID.
* Make the Query Tool tab titles more concise and useful.
* Fix support for bigint’s in JSONB data.
* Update CodeMirror to 5.43.0 to resolve issues with
auto-indent.
* Ensure JSON data isn’t modified in-flight by psycopg2 when
using View/Edit data.
* Modify the Download as CSV option to use the same connection
as the Query Tool its running in so temporary tables etc.
can be used.
* Fix context sub-menu alignment on Safari.
* Update documentation screenshots as per new design.
* Fix alignment of Close and Maximize button of Grant Wizard.
* Add full support and testsfor all PG server side encodings.
* Fix editing of table data with a JSON primary key.
* Ignore exceptions in the logger.
* Close connections gracefully when the user logs out of
pgAdmin.
* Fix alignment of checkbox to drop multiple schedules of
pgAgent job.
* Don’t exclude SELECT statements from transaction management
in the Query Tool in case they call data-modifying functions.
* Optimise display of Dependencies and Dependents, and use
on-demand loading of rows in batches of 100.
* Fix alignment of import/export toggle switch.
* Prevent an error when closing the Sort/Filter dialogue with
an empty filter string.
* Fix alignment of Connection type toggle switch of pgagent.
* Fix the query to set bytea_output so that read-only standbys
don’t consider it a write query.
* Add full support and testsfor all PG server side encodings.
* Don’t embed docs and external sites in iframes, to allow the
external sites to set X-FRAME-OPTIONS = DENY for security.
* Add full support and testsfor all PG server side encodings.
* Custom-encode forward slashes in URL parameters as Apache
HTTPD doesn’t allow them in some cases.
* Update CodeMirror to 5.43.0 to resolve issues with tab indent
with use spaces enabled.
* Ensure long queries don’t cause errors when downloading CSV
in the Query Tool.
* Disable the editor and execute functions whilst queries are
executing.
* Fix an issue where importing servers fails if a group already
exists for a different user.