Softpedia >Linux >Database >Administrative Frontends >PgAdmin IV >  Changelog

PgAdmin IV Changelog

What's new in PgAdmin IV 4.14

Oct 31, 2019
  • Added Copy with headers functionality when copy data from Query Tool/View Data.
  • Implemented the Query Plan Analyser.
  • Include PostgreSQL 12 binaries in the container.
  • Ensure the MAC OSX app should be notarized for Catalina.
  • Optimize Webpack to improve overall performance.
  • Ensure backup a partition table should not backup the whole database.
  • Ensure that 'ENTER' key in the data filter should not run the query.
  • Highlighted the color of closing or opening parenthesis when user select them in CodeMirror.
  • Ensure that pgAdmin should work behind reverse proxy if the inbuilt server is used as it is.
  • Ensure the search path should not be quoted for Database.
  • Ensure the search path should not be quoted for Function, Procedure and Trigger Function.
  • Fix issue where VALID foreign keys show as NOT VALID in the SQL tab for tables.

New in PgAdmin IV 4.8 (Jun 8, 2019)

  • Allow the UI layout to be fully locked or to prevent docking changes.
  • Fix the issue of accessing the SQL for Views and Materialized Views. Regression of pluralisation of folder names.
  • Omit the geometry viewer in the Query Tool from layout saving.
  • Improve the performance of explain plan by embedding the images only when downloading it.

New in PgAdmin IV 4.3 (Mar 19, 2019)

  • Add a "scratch pad" to the Query Tool to hold text snippets whilst editing.
  • Add Commit and Rollback buttons to the Query Tool.
  • 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.
  • Allow X-FRAME-OPTIONS to be set for security. Default to SAMEORIGIN.
  • Install a script to start pgAdmin (pgadmin4) from the command line when installed from the Python wheel.
  • Close connections gracefully when the user logs out of pgAdmin.

New in PgAdmin IV 1.20.0 (Dec 25, 2014)

  • Resolving the inconsistency of preservation of modified information of the columns, while adding/editing a table from the table dialog
  • Add missing nodes to graphical explain plan
  • Fix the Resource Groups dialog - separated the statements, which can not be ran in single transaction
  • Support for Slony-I 2.2+ with PostgreSQL 9.3+
  • Support smallserial columns in Edit Data Window
  • Restore the user specified size on the grid (which contains the result) in Query windows to fix an issue related to the column size is too narrow on subsequent Explain execution
  • Empty the Undo/Redo history everytime new file is opened
  • Added accelerator F8 for 'Execute to file' in the Query window
  • Beautify the query shown in the SQL pane for the functions having multiple arguments by adding new lines with small modification by me
  • Check for the columnlist for the UPDATE OF syntax on trigger also works with PPAS 9.5+
  • Proper saving of columns width in the server status window
  • Fix support for triggers with inline code on PPAS
  • CHECK OPTION is applicable to the views only, and not the materialized views
  • Prevent a crash during the update of the macro or favourite list
  • Allow quick injectection of favourites by name
  • Fix handling of saving macros after pasting a query in the box
  • Fix SQL for GRANT on a sequence
  • Fix handling of char()[] columns in the Edit Grid
  • Support the new check_option parameter of views
  • Handle the 9.4 MOVE clause of ALTER TABLESPACE
  • Add a new action menu to refresh a materialized view
  • Support the new 9.4 columns in pg_stat_activity
  • Save search options for next time
  • Ensure Favourite queries are only saved when the OK button is pressed
  • Fix an issue refreshing functions in PPAS packages
  • Improve handling of lost connections
  • Allow searching for database objects by comment and definition content
  • Add support for Resource Groups in PPAS 9.4
  • Add Save and Exit shortcut keys to the edit grid

New in PgAdmin IV 1.18.1 (Jan 8, 2014)

  • Allow the dump of pg schemas
  • Prevent a crash on Windows when dropping a column or a constraint on a table
  • Ensure DDLScript will work with Slony 2.2+ which has a new SQL level API
  • Fix ordering of object types in the display options and add Event Triggers which were missing
  • Ensure the debugger can cope with functions that have an OUT parameter as the first
  • Fix the quoting of user mapping objects
  • Ensure that materialised views are available as targets for synonyms
  • Fix the query used to find tables in a Slony replication set
  • Prevent a crash if a user starts an external process such as a backup, and then immediately hits cancel
  • Fix a memory leak in the Event Trigger code

New in PgAdmin IV 1.10.2 (Mar 11, 2010)

  • Correctly save the position of a pgFrame, per a report from Andreas Laggner and Dan Halbert.
  • Fix the reverse engineering of a function, per a report from Kieran McCusker.
  • Fix the xmlTextWriterEndDocument check when saving a favorite.
  • Fix an SQL error when changing a parameter for a database, role/user and a function.
  • Fix the display of a type with a specific typmod.
  • Select the server choosen with the /s command-line argument.
  • Fix the call to the Slony-I storenode function.
  • Fix display of the date/time chooser.

New in PgAdmin IV 1.10.0 (Sep 11, 2009)

  • Highlights of this release include a graphical query builder, a scripting engine in the query tool, and support for PostgreSQL 8.4.
  • Many other changes were made.