VirtualBox Extension Pack 歷史版本列表
更新時間：2021-10-21
更新細節：
What's new in this version:
New features:
- Added support for indent guides in the browser tree
- Added support for advanced table fields like the foreign key, primary key in the ERD tool
- Added support to allow tables to be dragged to ERD Tool
- Added index creation when generating SQL in the ERD tool
- Added support for authentication via the webserver (REMOTE_USER)
- Added support to enable/disable rules
- Housekeeping
Fixed:
- Fixed OAuth2 integration redirect issue
- Ensure that query highlighting color in the query tool should be less intensive
- Changed the label ‘Inherits Tables?’ to ‘Is inherited?’ as it misleading in the properties panel
- Fixed an issue where the user is unable to create an index with concurrently keyword
- Remove an extra blank line at the start of the SQL for function, procedure, and trigger function
- Fixed the issue of editing triggers for advanced servers
- Fixed an issue where the tree is not scrolling to the object selected from the search result
- Fixed object delete issue from the properties tab for the collection nodes
- Ensure that the Dashboard should get updated after connecting to the server
- Fixed an issue where the browser tree doesn’t show all contents on changing resolution
- Ensure that columns should be displayed in the order of creation instead of alphabetical order in the browser tree
- Fixed background colour issue in the browser tree
- Added support for composite foreign keys in the ERD tool
- Fixed an issue where exclusion constraint cannot be created from table dialog if the access method name is changed once
- Fixed an issue where the users are unable to load the databases behind an HTTP reverse proxy
- Fixed an issue where each click to refresh the collection node, the number of objects decreasing by tens or more
- Fixed browser tree sort order regression issue
- Fixed an issue where the blank string is stored instead of NULL in the server table of SQLite database
- Ensure that the master password should be prompt when MASTER_PASSWORD_REQUIRED is set to True and AUTHENTICATION_SOURCES is webserver
- Ensure that only the table node should be allowed to drop on the ERD tool
- Fixed an issue where the existing server group is disappeared on rename it
- Fixed an issue where the wrong SQL is generated when deleting and renaming table columns together
更新時間：2021-10-07
更新細節：
What's new in this version:
New features:
- Added support for OWNED BY Clause for sequences
Housekeeping:
- Revisit all the CREATE and DROP DDL’s to add appropriate ‘IF EXISTS’, ‘CASCADE’ and ‘CREATE OR REPLACE’
- Port browser tree to React
- Port object nodes and properties dialogs to React
- Port Grant Wizard to react
- Remove GPDB support completely
Fixed:
- Fixed an issue where grant wizard is unresponsive if the database size is huge
- Added support to create the Partitioned table using COLLATE and opclass
- Ensure that in the Query History tab, query details should be scrollable
- Fixed an issue where collapse and expand arrows mismatch in case of nested IF
- Fixed an issue where the last message is not visible in the Debugger
- Updated query error row selection color as per dark theme style guide
- Fixed an issue where the drop cascade button enables for Databases
- Fixed an issue where Refresh view options are not working for materialized view
- Fixed keyerror issue in schema diff for ‘attnum’ and ‘edit_types’ parameter
- Ensure that RLS names should not be editable in the collection node of properties tab
- Fixed an issue where Execute button of the query tool gets disabled once we change anything in the data grid
- Ensure that SQL help should work for EPAS servers
更新時間：2021-09-09
更新細節：
What's new in this version:
New:
- Added support for the truncate table with restart identity
- Make code folding case insensitive in the code mirror
- Added database and server information on the Maintenance process watcher dialog
- Allow the referenced table to be the same as the local table in one to many relationship for ERD Tool
- Make closing tabs to be smarter by focusing on the appropriate tab when the user closed a tab
- Set PSQLRC and PSQL_HISTORY env vars to apt. user storage path in the server mode
- Housekeeping
Fixed:
- an issue where privileges were revoked using SQL query on objects like tables that do not correctly show in SQL tab
- an issue where the user can not paste the updated table header in safari 12 and 13 browsers
- Ensure that trigger function SQL should have ‘create or replace function’ instead of ‘create function’ only
- blank screen issue on windows and also made changes to use NWjs manifest for remembering window size
- the export image issue where relation lines are over the nodes
- width limitation issue in PSQL tool window
- an issue where columns with sequences get altered unnecessarily with a schema diff tool
- Ensure that the lock panel should not be blocked for larger records
- Partially fixes the data output panel display issue
- an issue where whitespace in function bodies was not applied while generating the script using Schema Diff
- Introduced OAUTH2_SCOPE variable for the Oauth2 scope configuration
- Enables pgAdmin to retrieve user permissions in case of nested roles which helps to terminate the session for AWS RDS
- no attribute ‘_asdict’ error when connecting the database server
- errors related to HTML tags shown in the error message for JSON editor
- UnboundLocalError where local variable ‘user_id’ referenced before assignment
- Renamed ‘Auto rollback?’ to ‘Auto rollback on error?’
- the JSON editor issue of hiding the first record
- Ensure that deleting a database should not automatically connect to the next database
- Ensure that pgAdmin should not fail at login due to a special character in the hostname
- an issue where multiple query tool tabs getting closed for the single close event
更新時間：2021-08-13
更新細節：
What's new in this version:
New features:
- Added support to copy SQL from main window to query tool
- Added support for formatted JSON viewer/editor when interacting with data in a JSON column
Housekeeping:
- Rename the “Resize by data?” to “Columns sized by” and disabled the ‘Maximum column width’ button if ‘Columns sized by’ is set to ‘Column data’
Fixed:
- Ensure that the login account should be locked after N number of attempts. N is configurable using the ‘MAX_LOGIN_ATTEMPTS’ parameter
- CSRF errors for stale sessions by increasing the session expiration time for desktop mode
- an issue in the search object when searching in ‘all types’ or ‘subscription’ if the user doesn’t have access to the subscription
- an issue where paste is not working through Right-Click option on PSQL
- TypeError ‘NoneType’ object is not sub scriptable
- incorrect tablespace options in the drop-down for move objects dialog
- an issue where the titles in query tabs are different
- incorrect binary path issue when the user deletes the binary path from the preferences
- Ensure that all the required options should be loaded when the Range data type is selected while creating a custom data type
- dashboard server activity issue when active_since parameter is None
- an issue where even if the user is locked, he can reset the password and can login into pgAdmin
更新時間：2021-07-16
更新細節：
What's new in this version:
New:
- Highlighted long running queries on the dashboards
- Added support for Reassign/Drop Owned for login roles
- Do not block the query editor window when running a query
- Added support for OAuth 2 authentication
- Added option to provide maximum width of the column when ‘Resize by data?’ option in the preferences is set to True
Housekeeping:
Fixed:
- Ensure that the Data Output panel can be snapped back after it is detached
- Fixed replace keyboard shortcut issue in the query tool on the normal keyboard layout
- Fixed an issue where detaching the query editor panel gives a blank white panel
- Remove leading whitespace and replace it with ‘[…] ‘ in the Query Tool data grid so cells don’t look empty
- Fixed an issue in the search object when searching in ‘all types’ or ‘subscription’ if the user doesn’t have access to the subscription
- Fixed an issue where Execute/Refresh button should not be disabled when we run the empty query
- Fixed an issue where the New Connection Drop Down has lost default maintenance database, auto-select, and tab-through functionality
- Fixed directory selection issue with the folder dialog
- Ensure that setting ‘Open in new browser tab’ should be visible, it should not be based on the value of ‘ENABLE_PSQL’
- Fixed copy/paste issues for PSQL tool terminal
- Disable email deliverability check that was introduced in flask-security-too by default to maintain backwards compatibility
- Fixed Czech translation string for ‘Login’ keyword
- Fixed an issue where incorrect column name listed in the properties of Index
更新時間：2021-06-17
更新細節：
What's new in this version:
New features:
- Added browse button to select the binary path in the Preferences
- Added Grant Wizard option under Package node
- Added support to launch PSQL for the connected database server
- Added window maximize/restore functionality for properties dialog
- Added support to set the binary path for the different database server versions
- Added OS, Browser, Configuration details in the About dialog
- Added support for rotating the pgAdmin log file on the basis of size and age
- Support non-admin installation on Windows
Housekeeping:
- Added RESQL/MSQL test cases for Table and its child nodes
- Updated Flask-Security-Too to the latest v4
- Added a mechanism to detect a corrupt/broken config database file
Fixed:
- Fixed the issue of renaming the database by another user
- Ensure that the Query Tool connection string should not be changed as per the ‘Query Tool tab title’
- Ensure that the user should be able to add members in Login/Role group while creating it
- Ensure that the calendar control should be disabled in the properties panel for Role
- Disable browser password saving in the runtime
- Fixed duplicate SQL issue for tables with more than one partition
- Fixed an issue where the Foreground Color property of server dialog does not work
- Fixed an issue where pgAdmin does not open after password reset in server mode
- Fixed an issue where a decimal number is appended for character varying fields while downloading the data in CSV format
更新時間：2021-05-20
更新細節：
What's new in this version:
New features:
- Added support to set auto width of columns by content size in the data output window
- Added support to connect PostgreSQL servers via Kerberos authentication
- Added “IF NOT EXISTS” clause while creating tables and partition tables which is convenient while using the ERD tool
Fixed:
- Fixed an issue where drag and drop object is not correct in codemirror for properties dialog
- Added support for cache bust webpack chunk files
- Fixed an issue where data is displayed in the wrong order when executing the query repeatedly
- Ensure that while connecting to the server using SSPI login, it should not prompt for the password
- Fixed an issue where the wrong SQL is showing for the child partition tables
- Fixed an issue where CSV download quotes the numeric columns
- Ensure that pgAdmin should not allow opening external files that are dragged into it
- Fixed an issue where schema diff does not create DROP DEFAULT statement for columns
- Ensure that Backup and Restore should work on shared servers
- Fixed an issue where the filter ‘Include/Exclude By Selection’ not working for null values
- Ensure that the user should not be able to add duplicate panels
- Added support for the creation of Nested Table and Varying Array Type for Advanced Server
- Fixed ModuleNotFoundError when running setup.py from outside of the root
- Fixed an issue where the current debug line is not visible in the ‘Dark’ theme
- Fixed an issue where duplicate columns are visible in the browser tree, which is owned by two sequences
- Fixed an issue where the Help message not displaying correctly on Login/Group role
- Added comment column in the properties panel for View and Materialized View collection node
- Fixed an issue where query editor is not being closed if the user clicks on the ‘Don’t Save’ button
- Ensure that pgAdmin4 shut down completely on the Quit command
- Fixed an issue where file dialog showing incorrect files for the selected file types
- Fixed an issue where the user is not warned if Kerberos ticket expiration is less than 30 min while initiating a global backup
- Ensure that proper identification should be there when the server is connected using Kerberos or without Kerberos
更新時間：2021-04-22
更新細節：
What's new in this version:
New features:
Housekeeping:
- Improve code coverage and API test cases for Server module
Fixed:
- Updated docs and screenshots to cover the Notifications tab on the Query Tool
- Ensure that the query tool tab should be closed after server disconnection when auto-commit/auto-rollback is set to false
- Fixed an issue where shortcut keys are not working with manage macro
- Fixed an issue where correct error not thrown while importing servers and JSON file has incorrect/insufficient keys
- Ensure that the user should not be to change the connection when a long query is running
- Fixed flickering issue of the input box on check constraints
- Fixed an issue where the cursor shifts its focus to the wrong window for all the query tool related model dialogs
- Corrected the syntax for ‘CREATE TRIGGER’, use ‘EXECUTE FUNCTION’ instead of ‘EXECUTE PROCEDURE’ from v11 onwards
- Ensure that the strings in the LDAP auth module are translatable
- Fixed an issue where the procedure creation is failed when providing the Volatility option
- Fixed an issue while selecting the row which was deleted just before the selection operation
- Ensure that the file format for the storage manager should be ‘All files’ and for other dialogs, it should remember the last selected format
- Ensure that while comparing domains check function dependencies should be considered in schema diff
- Fixed sizing issue of help dialog for Query Tool and ERD Tool when open in the new browser tab
- Fixed SQL panel black screen issue when detaching it in runtime
- Added missing dependency ‘xdg-utils’ for the desktop packages in RPM and Debian
- Fixed cannot unpack non-iterable response object error when selecting any partition
- Mark the Apache HTTPD config file as such in the web DEB and RPM packages
- Fixed an issue where the Save button is enabled by default when open the table’s properties dialog on PG 9.5
- Fixed an issue where users are unable to see data of the partitions using the View/Edit data option
- Fixed an issue where a connection warning should be displayed on the user clicks on explain or explain analyze and the database server is disconnected from the browser tree
- Fixed an issue where foreign data wrapper properties are not visible if the host option contains two host addresses
- Ensure that Backup and Restore should work on shared servers
更新時間：2021-03-26
更新細節：
What's new in this version:
New features:
- Show the login roles that are members of a group role be shown when examining a group role
- Make the container distribution a multi-arch build with x86_64 and Arm64 support
- Make ‘kerberos’ an optional feature in the Python wheel, to avoid the need to install MIT Kerberos on the system by default
- Added ‘–replace’ option in Import server to replace the list of servers with the newly imported one
- Added zoom scaling options with keyboard shortcuts in runtime
Housekeeping:
- Use schema qualification while accessing the catalog objects
- Make the ‘Save Data Changes’ icon to be more intuitive
Fixed:
- Fixed alignment issue under preferences for the German language
- Fixed color issue on the statistics tab for collection node in the safari browser
- Fixed an issue where adding/updating records fails if the table name contains percent sign
- Ensure that autovacuum and analyze scale factors should be editable with more than two decimals
- Fixed an issue where % displayed twice in explain analyze for query and table
- Rename text ‘table’ with ‘relation’ in the statistic tab for explain analyze
- Fixed an issue where the properties tab for collection nodes is unresponsive after switching the tabs
- Fixed an issue where the Save button is enabled for functions/procedures by default when open the properties dialog
- Fixed an issue where hanging symlinks in a directory cause select file dialog to break
- Allow underscores in the Windows installation path
- Remove the “launch now” option in the Windows installer, as UAC could cause it to run as an elevated user
- Ensure that cell content being auto selected when editing the cell data
- Ensure that SQL formatter should not add extra tabs and format the SQL correctly
- Fixed encoding issue when database encoding set to SQL_ASCII and name of the column is in ASCII character
- Ensure that the user should be able to kill the session from Dashboard if the user has a ‘pg_signal_backend’ role
- Ensure that the view/edit data panel should not be opened for unsupported nodes using the keyboard shortcut
- Ensure PGADMIN_DEFAULT_EMAIL looks sane when initialising a container deployment
- Improve the web setup script for Linux to make the platform detection more robust and overrideable
- Ensure that SQL formatter should not use tab size if ‘Use spaces?’ set to false
- Fixed an issue where the user is unable to create a subscription if the host/IP address for connection is 127.0.0.1
- Ensure that proper error message should be shown on the properties and statistics tab in case of insufficient privileges for a subscription
- Fixed an issue where the ‘Create Slot’ option is disabled in case of the same IP/host provided but the port is different
- Ensure the Python interpreter used by the runtime ignores user site-packages
- Fixed an issue where the user is not able to change the connection in Query Tool when any SQL file is opened
- Ensure that the venv activation scripts have the correct path in them on Linux
- Fixed an issue where schema diff showing wrong SQL when comparing triggers with different when clause
- Ensure that the template database should be visible while creating the database
- Fixed string index out of range error where the dependent tab is in focus and selecting any publication or table
- Fixed an issue where the dependent tab throwing an error when selecting any login/group role
- Fixed an issue where the incorrect values visible in the dependents tab for publication
- Fixed an issue where copy/paste rows in view data paste the wrong value for boolean type
- Ensure that the primary key should be visible properly in the table dialog
- Ensure that toggle buttons are accessible by most screen readers
- Fixed an issue where the top menu disappears when entering into the full screen for minimum screen resolution
- Ensure that the grantor name should be visible properly for the security tab in the table dialog
更新時間：2021-02-26
更新細節：
What's new in this version:
Features:
New Desktop Runtime (Using NWjs):
- The Desktop Runtime is now based on NWjs which integrates a browser and the Python server creating a standalone application. By implementing it using NWjs we get rid of the separate server application and the independent browser. We also get rid of QT and C++ runtime logic.
- There are two minor known issues with this feature (6255 and 6258), both of which are due to bugs in NWjs itself; Users on macOS should use the application menu to exit pgAdmin, rather than quitting from the Dock icon to avoid the first issue. The second issue may cause Windows users to see a red square instead of the normal application icon in some circumstances.
Logical Replication support:
- Logical replication uses a publish and subscribe model with one or more subscribers subscribing to one or more publications on a publisher node. We have added support for logical replication by introducing new treeview nodes and dialogues with which users can easily create/alter/delete publications and subscriptions. Support is also included in the Schema Diff tool.
Quick Search functionality:
- Added a quick search option in the Help menu to search menu items and help articles. Type at least three characters to display all the matching possibilities under Menu items and the relevant documents under Help articles.
- Make Statistics, Dependencies, Dependants tabs closable. Users can add them back using the 'Add panel' option on the context menu for the tab strip
- When running in Docker/Kubernetes, ensure logs are not stored in the container, and only sent to the console
Bugs/Housekeeping:
- Use cheroot as the default production server for pgAdmin4
- Updated Javascript dependencies to the latest versions
- Fixed an issue where the focus is not properly set on the filter text editor after closing the error dialog
- Fixed an issue where the dependencies tab shows multiple owners for the objects having shared dependencies
- Fixed an issue where the Zoom to fit button in the ERD Tool only works if the diagram is larger than the canvas
- Fixed an issue where the user was unable to change the background color for a server
- Fixed an issue where external utility jobs (backup, maintenance etc.) are failing when the log level is set to DEBUG
- Ensure DEB/RPM packages depend on the same version of each other
- Fixed an autocomplete issue where it is not showing any suggestions if the schema name contains escape characters