------------------------------------------------------------------- Thu Dec 11 17:43:48 UTC 2025 - Antonio Larrosa - Update to 9.11 * Supported Database Servers - PostgreSQL: 13, 14, 15, 16, 17 and 18 - EDB Advanced Server: 13, 14, 15, 16, 17 and 18 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 18.0 * New features - Add support of DEPENDS/NO DEPENDS ON EXTENSION for INDEX. - Add support of DEPENDS/NO DEPENDS ON EXTENSION for MATERIALIZED VIEW. - Add support for showing the column data type beside column name in the object explorer. - Added Ubuntu 25.10 and Fedora 43 - Add conditional TLS support for the Ingress in the Helm chart. * Bug fixes - Fixed an issue on type casting of default string function/procedure arguments in debugger tool. - Fix pkg_resources deprecation warning by migrating Docker base image to python:3-alpine from alpine:latest. - Fixed an issue where EXPLAIN should run on query under cursor if no text is selected. - Fixed an issue where opening file in Query Tool does not retain file name in tab. - Fixed an issue where connection is failing via Query Tool/PSQL Tool workspaces. - Plain SQL restore runs with ‘restrict’ option to prevent harmful psql meta-commands (CVE-2025-13780). - Fixed an issue where copying highlighted text in the query tool data output cell editor would copy the complete string. - Fixed an issue where copying a single cell should not add quoting. - Fix the Helm chart server definition and change the app version. - Specify the correct hostname placeholder for the Password Exec command. - Ensure the proper handling of extra volume mount configurations in the Helm deployment template by correcting the configuration value references. - Update to 9.10 * Supported Database Servers - PostgreSQL: 13, 14, 15, 16, 17 and 18 - EDB Advanced Server: 13, 14, 15, 16, 17 and 18 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 18.0 * New features - Added the ability to search for tables and automatically bring them into view in the ERD tool. - Add support of DEPENDS/NO DEPENDS ON EXTENSION for PROCEDURE. - Add support for setting image download resolution in the ERD tool. - Add support for displaying detailed Citus query plans instead of 'Custom Scan' placeholder. - Add support for formatting .pgerd ERD project file. * Housekeeping - Migrate pgAdmin UI to use React 19. * Bug fixes - Fixed an issue where data output column resize is not sticking in Safari. - Fixed an issue where Schema Diff does not ignore Tablespace for indexes. - Fixed an issue where the 2FA window redirected to the login page after session expiration. - Fixed an issue where the Select All option on the columns tab of import/export data was not working in languages other than English. - Fixed an issue where the Debian build process failed with a "Sphinx module not found" error when using a Python virtual environment. - Fixed an issue where the last used storage directory was reset to blank, leading to access denied errors during backup or restore operations. - Fixed an issue that prevented assigning multiple users to an RLS policy. - Fixed remote code execution vulnerability when restoring PLAIN-format SQL dumps in server mode (CVE-2025-12762, bsc#1253474). - Fixed Command injection vulnerability allowing arbitrary command execution on Windows (CVE-2025-12763). - Fixed LDAP authentication flow vulnerable to TLS certificate verification bypass (CVE-2025-12765). - Fixed LDAP injection vulnerability in LDAP authentication flow (CVE-2025-12764). - Update to 9.9 * Supported Database Servers - PostgreSQL: 13, 14, 15, 16, 17 and 18 - EDB Advanced Server: 13, 14, 15, 16 and 17 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 17.5 * New features - Add support of DEPENDS/NO DEPENDS ON EXTENSION for ALTER FUNCTION. - Added "MULTIRANGE_TYPE_NAME" option while creating a Range Type. - Added "SUBSCRIPT" option while creating a External Type. - Added option to skip the password dialog when using an identity file. - Added 'failover' and 'two_phase' parameter support in CREATE/ALTER SUBSCRIPTION for PostgreSQL v17+. - Add support for initializing the pgAdmin4 Kubernetes Helm chart. * Bug fixes - Fixed an issue where the query tool displayed 'default' instead of 'null' for null text data in the data output. - Fixed an issue where the pgAdmin configuration database wasn't being created on a fresh install when an external database was used for the configuration. - Fixed an issue where shortcuts are not working as expected on multiple keyboard layouts. - Fixed an issue where saving the newly changed preferences was not reflecting on the preferences tab. - Merge package_deps.patch into package_git_local.patch as suggested by Scott Bradnick. - Remove patch: * package_deps.patch - Rebase patch: * package_git_local.patch - Update vendored packages. - Add a README.devel text file with instructions to update the package to a new version. ------------------------------------------------------------------- Wed Oct 8 06:33:57 UTC 2025 - Antonio Larrosa - Add node_modules.sums as source in the spec file ------------------------------------------------------------------- Thu Oct 2 09:44:25 UTC 2025 - Antonio Larrosa - update to 9.8: * Supported Database Servers - PostgreSQL: 13, 14, 15, 16 and 17 - EDB Advanced Server: 13, 14, 15, 16 and 17 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 17.5 * New features - Add menu items for truncating foreign tables. - Added Debian Trixie as a supported platform for pgAdmin. - Allow user to configure security related gunicorn parameters. - Change the default pgAdmin theme to System. * Housekeeping - Remove usage of BrowserFS as it is deprecated. * Bug fixes - Pin Paramiko to version 3.5.1 to fix the DSSKey error introduced in the latest release. - Fixed an issue where pgAdmin config migration was failing while upgrading to v9.7. - Fixed Cross-Origin Opener Policy (COOP) vulnerability in the OAuth 2.0 authentication flow (CVE-2025-9636, bsc#1249151). - Fixed an issue where editor shortcuts fail when using Option key combinations on macOS, due to macOS treating Option+Key as a different key input. - Fixed an issue where the pgAdmin configuration database wasn't being created on a fresh install when an external database was used for the configuration. - update to 9.7: * Supported Database Servers - PostgreSQL: 13, 14, 15, 16 and 17 - EDB Advanced Server: 13, 14, 15, 16 and 17 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 17.2 * New features - Add support for automatic updates in the pgAdmin 4 Desktop application on macOS. - Added GENERIC_PLAN, MEMORY, SERIALIZE option to EXPLAIN/EXPLAIN ANALYZE command. - Add support for changing cursor blink rate within the editors. - Add support for server tag-based filtering in the Object Explorer. - Added support for builtin locale provider while creating Collation. * Housekeeping - Replace keyword PROCEDURE with FUNCTION while creating trigger and event trigger. - Introduced an ‘Editor’ preferences category and migrated all editor related settings into it. * Bug fixes - Fixed an issue where custom column widths in the result grid of Query Tool or View/Edit Data were reset after re-executing a query. - Fixed the issue where updating the name of a table column does not reflect in the corresponding primary key constraint. - Fixed an issue where pgAdmin failed to update the server connection status when the server was disconnected in the background and a refresh was performed on that server. - Make Dashboard tables to be vertically resizable. - Fixed an issue in Firefox where the query window would shift to the left after opening the history tab or selecting a column header in the results grid. - Fixed an issue where CPU usage was very high on Windows when opening the psql tool. - Ensure DB restriction type is preserved while import and export server. - Fixed incorrect behaviour of the option deduplicate items after creating the index. - Added PKEY index in the index statistics summary. - Fixed an issue where adding breakpoints caused errors, and stepping out of a nested function removed breakpoints from the parent function. - Ensure the scratch pad in the Query Tool is not restored after it is closed. - Update the documentation for parameters that require file paths. - Fixed an issue where downloading images on the ERD tool was not working in desktop mode. - Ensure that disabling “Save Application State” in Preferences prevents tool data from being saved and stops it from being restored on application restart. - update to 9.6: * Supported Database Servers - PostgreSQL: 13, 14, 15, 16 and 17 - EDB Advanced Server: 13, 14, 15, 16 and 17 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 17.2 * New features - Ensure that keyboard shortcuts are displayed in tooltips, context menus, and the main menu. - Implemented a server-side cursor to enhance performance when retrieving large datasets. - Added support for setting a custom SESSION_DIGEST_METHOD in pgAdmin 4 to facilitate FIPS compliance. - Enable the PKCE workflow for OAuth 2 authentication. * Housekeeping - Ensure that pgAdmin 4 is compatible with PG/EPAS v18. - Use ‘Drop’ instead of ‘Delete’ for object commands to make destructive actions more deliberate. * Bug fixes - Fixed an issue where windows installer is not signing tmp files generated by InnoSetup. - Fixed an issue in the Search Objects tool where selecting a node occasionally selected an incorrect node. - Improved the application state restoration by leveraging rc-dock layout and ensure the order and layout of tabs is maintained on restore. - Fixed an issue where json editor in result grid was crashing if null value is set in the json editor. - Update zstd library link to 1.5.7 in Dockerfile. - update to 9.5: * Supported Database Servers - PostgreSQL: 13, 14, 15, 16 and 17 - EDB Advanced Server: 13, 14, 15, 16 and 17 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 17.2 * New features - Add a new permission to allow disabling “Change Password” feature for a pgAdmin role. - Added role-based restrictions for editing server connections. - Added support for customizing keyboard shortcuts in the Query Tool’s Edit menu. - Add a search box to enable searching within the preferences tab. - Added support to preserve the workspace, query windows, and pgAdmin state during an abrupt shutdown or restart. - Open preferences in a new tab instead of a dialog for better user experience. - Supports JSON logging for gunicorn process within Docker. * Bug fixes - Improved PL/pgSQL code folding and support nested blocks. - Add a flag to allow access to system Python packages on recent Linux distributions. - Fixed an issue where utilities such as pg_dump and pg_restore failed to log error messages when required dependency files were missing. - Fixed an issue where the Schema Diff Tool incorrectly reported differences due to variations in the order of the privileges. - Fixed an issue in SQL syntax highlighting where the same color was used for both variable names and datatypes. - Fixed an issue in the query tool where using multiple cursors to copy text resulted in only the first line being copied. - Ensure that Keyboard shortcuts for save and download actions should not called when their respective UI buttons are disabled. - Fixed an issue where data export using a query opened the wrong dialog type. - Fixed an issue where data export using a query failed when the query contained a newline character. - Fixed a UI layout issue that occurred after upgrading from pgAdmin v9.2 when all tabs had been closed prior to the upgrade. - Fixed an issue where the Columns node was not visible under Catalog Objects. - update to 9.4: * Supported Database Servers - PostgreSQL: 13, 14, 15, 16 and 17 - EDB Advanced Server: 13, 14, 15, 16 and 17 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 17.2 * New features - Enabled large file downloads for desktop users within the query tool. - Add all missing options to the Import/Export Data functionality, and update the syntax of the COPY command to align with the latest standards. - Add support for exporting table data based on a custom query. * Bug fixes - Fixed an issue where the result grid slowed down when any column contained a large amount of data. - Fix the issue where an error is displayed when a table is dropped while a query is running. - Fixed an issue where the options key was not working as expected in the PSQL tool. - Fixed an issue where correct error message not displayed when sql statement contains Arabic letters. - Enhance contrast for selected and hovered items in the Object Explorer to improve visibility and accessibility. - Fixed an issue where the query tool returns “cannot unpack non-iterable Response object” when running any query with a database name change. - Handle result grid data changes in View/Edit Data mode by automatically reconnecting to the server if a disconnection occurs. - Implement API fetch error display for select dropdown. - Fixed an issue where light theme briefly appears when pgAdmin loads or tools open, even when a dark or system UI theme is preferred. - Fixed issues related to column range selection using shift + click. - Fixed an issue where pgAdmin failed to focus when previously unfocused and then quit. - update to 9.3: * Supported Database Servers - PostgreSQL: 13, 14, 15, 16 and 17 - EDB Advanced Server: 13, 14, 15, 16 and 17 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 17.2 * New features - Add support for type constructors for PostGIS spatial types. - Added ability to use SQL in the “DB Restriction” field. - Add support for custom roles and role permissions management in pgAdmin. - Added support for font ligatures. * Bug fixes - Add Cache-Control no-cache,no-store,must-revalidate header to dynamically generated utils.js file. - Fixed an issue where shift + click on rows/columns for range selection did not work in the query tool data output window. - Fixed an issue where the debugger hangs when stepping into nested function/procedure. - Fixed an issue where the scroll position in the Object Explorer was not retained when switching workspaces. - Ensure that graph data is updated even when the Dashboard tab is inactive. - Fixed an issue where Ctrl/Cmd+A in cell editor would select all rows. - Fixed an issue where drag and drop function with no parameters does not work. - Fixed an issue where changes to foreign key constraints were not detected in the schema diff. - Change the shortcut for canceling a running query as it conflicts with the shortcut to open a new query tool. - Fixed an issue where filtering on a view caused an error. - Fixed an issue where the query tool went blank when converting history dates to the appropriate locale format. - Ensure that the server list is alphabetically sorted in the Query Tool/PSQL workspace. - Fixed an issue where the user management tab is not opening in the classic layout. - Allow OAuth 2 login using the username claim if the email is absent from the user profile. - Rebase patches: * package_deps.patch * package_git_local.patch - Update vendored packages. ------------------------------------------------------------------- Fri Apr 11 14:21:40 UTC 2025 - Antonio Larrosa - Add patch to try to fix reproducible builds by disabling webpack optimizations that seem to help with this: * fix-reproducible-builds.patch ------------------------------------------------------------------- Tue Apr 8 10:11:12 UTC 2025 - Antonio Larrosa - update to 9.2: * supported database servers - postgresql: 13, 14, 15, 16 and 17 - edb advanced server: 13, 14, 15, 16 and 17 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 17.2 * New features - Added an ability to configure the font family for SQL editors. - Added support to automatically open a file after it is downloaded in the desktop mode. - Added support for post-connection SQL execution, which will be run automatically on each connection made to any database of the server. - Add support for restoring plain SQL database dumps. - Added support for creating Directory nodes in EPAS. - Change icon buttons to show tooltip even when disabled. - Add an option to load/replace the servers.json file on each container startup. - Open user management in a separate tab instead of a dialog to enhance UI/UX. * Housekeeping - Added Security.md file. * Bug fixes - Ensure that modal dialogs are not triggered more than once to avoid duplicates. - Change session files garbage collection strategy. - Fixed an issue where pgAdmin should fallback to main screen if the last opened screen is disconnected. - Fixed an issue where the PSQL terminal displays keyname for non alphanumeric keys. - Fixed an issue where geometries in the geometry viewer will render partially when the container was resized. - Change the stop/terminate icon at all the places for better UX. - Fixed an issue where the Schema Diff was not displaying the difference query when a table had a UNIQUE NULLS NOT DISTINCT constraint. - Fixed an issue where the query tool data grid did not respect the default value for columns of domain type when the domain had a default value. - Ensure the newly added parameters in the server dialog are incorporated into the Import/Export Servers functionality. - Fixed an issue where updating the grantee was not correctly applying the privileges. - Fixed an issue where the upgrade_check API returned an unexpected keyword argument ‘cafile’ due to changes in the urllib package supporting Python v3.13. - Fixed an issue where delete/rename was done on wrong file after sorting in Storage Manager. - Fixed an XSS vulnerability issue in the Query Tool and View/Edit Data (CVE-2025-2946, bsc#1240748). - Fixed a remote code execution issue in the Query Tool and Cloud Deployment (CVE-2025-2945, bsc#1240746). - Fixed an issue where query tool is crashing on macOS 15.4 due to a locale issue. - update to 9.1: * supported database servers - postgresql: 13, 14, 15, 16 and 17 - edb advanced server: 13, 14, 15, 16 and 17 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 17.2 * New features - Added an option to open the file in a new tab within the query tool. - Add support for one to one relationship in the ERD tool. - Enable the ability to close the ‘Welcome’ tab in the Query Tool/PSQL Workspace. * Housekeeping - Added support for Python 3.13 * Bug fixes - Fixed an issue where pgAdmin does not support pg_vector column length/precision. - Fixed an issue where pasting text containing JSON data into the query tool grid would result in incorrect parsing. - Fixed an issue where the query tool was not treating IDENTITY columns as columns with default values when inserting new rows. - Fixed an issue where the ERD tool fails to open a saved file containing parent-child relationship within the same table. - Fixed Docker image entrypoint.sh email validation. - Fixed an issue where the User Management and Change Password dialogs were hidden when selecting a menu while a workspace other than ‘Default’ was active. - Fixed an issue where the column order displayed was incorrect for exclusion constraints with multiple columns. - Ensure the saved passwords are decrypted with the correct encryption key for external authentication in server mode. - Fixed an issue where drop-down menus were hidden behind the dock. - Fixed an issue where deleting rows in the query tool would delete all rows in the table when ‘Select All Remaining Rows’ was used. - update to 9.0: * supported database servers - postgresql: 13, 14, 15, 16 and 17 - edb advanced server: 13, 14, 15, 16 and 17 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 17.0 * New features - Change button labels and color in delete confirmation dialog for all objects to improve UX. - Enhanced pgAdmin 4 with support for Workspace layouts. - Added the MAINTAIN privilege for PostgreSQL version 17 and above. - Add support for OAuth2 profile array response, which also takes care of the GitHub Private Email ID issue. * Housekeeping - Show the python version used for the pgAdmin server in the about dialog. * Bug fixes - Change the logic of setval function, so that the next nextval of sequence will return exactly the specified value. - Fixed an issue where pgadmin cannot install into path with non ASCII characters. - Fixed an issue where filter dialog save fails when the PostgreSQL server/database connection is lost. - Fixed an issue where option key was not registering in PSQL tool. - Fixed an issue where Schema Diff not produce difference script for Index definition with where condition. - Correct the documentation for the MFA configuration. - Fixed an issue where error message from the database server need space between two sentences. - Fixed an issue where query tool throws utf-8 decode error when using cursor with binary data. - Allow deleting the entry while creating/adding new label to enumeration type. - Fixed an issue where properties dialog throwing an error for Materialized View. - Fix a formatting issue in View/Edit tool generated SQL where some filters are applied. - Fixed an issue where tooltip on a dropdown button is blocking access to dropdown menu. - Fix the error occurring while loading preferences on startup. - Fixed an issue where copying query tool output cell is not working if any SQL text is selected. - Ensure master password pop up is not shown on setting MASTER_PASSWORD_REQUIRED to false. - Remove the option “With no data (concurrently)” from Refresh MATERIALIZED VIEW context menu. - Fix an issue where wrong information is shown after using the filter on the Dashboard> State tab. - Fixed an issue where PSQL tool is not opening if database name have HTML characters in the name. - Fixed an issue where Default Privileges and Privileges not working correctly. - Fixed an issue where quotes were missing in the CREATE script for the tablespace. - update to 8.14: * supported database servers - postgresql: 12, 13, 14, 15, 16 and 17 - edb advanced server: 12, 13, 14, 15, 16 and 17 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 17.0 * New features - Allow setting NULL ordering for columns in view/edit data filter dialog. - Show auto-complete column names in filtered rows dialog of table and filter options of view/edit data tool. - Allow the use of a pgpass file in the pgAdmin container via Docker secrets. - Fixed multiple issues and improved ERD auto-layout. - Add support for passing connection details as placeholders in the passexec command. - Add support to deploy pgAdmin in a container with readOnlyRootFilesystem to true. - Added support for a builtin locale provider in the Database dialog. - Added support for adding tags on a server node. * Bug fixes - Fixed an issue where Ctrl/Cmd + A was not selecting all data in query tool data grid. - Fixed an issue where querying a foreign table gives the error ‘ForeignTableCommand’ object has no attribute ‘auto_commit’. - Fixed an issue where indent with space was not aligning to next tab position. - Fixed an issue where pgAdmin crashes on accessing the dashboard state tab when database is super busy. - Fixed an issue related to the query tool update connection after the server disconnected from the object explorer. - Fixed an issue where a column name change in the edit dialog of the table node does not show the updated column name. - Fixed an issue where query tool should show results and messages only from the last executed query. - Fixed an issue where query tool throws syntax error if a newly added row is untouched and saved. - Ensure the crypt key is retrieved correctly on backend server restart. - Fixed an issue in schema diff where an error message popup was showing some garbage without any info. - Fixed an issue where query tool should not prompt for unsaved changes when there are no changes. - Add a user preference to enable/disable alternating row background colors in the data output of query tool. - Fixed an issue where doing Ctrl/Cmd+C on a selected text in a cell editor of data output in the query tool copied the complete text. - Fixed an issue where auto-width of wide columns in data output is incorrectly calculated. - Ensure correct custom SSL certificate passed in connection string. - update to 8.13: * supported database servers - postgresql: 12, 13, 14, 15, 16 and 17 - edb advanced server: 12, 13, 14, 15 and 16 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 17.0 * New features - Replace infinite scrolling with pagination in query tool data output for better UX and performance. - Add an object menu option to disconnect all server and database connections. - Alternate the background color of rows to enhance readability. - Allow to pass PGADMIN_CONFIG_CONFIG_DATABASE_URI from docker secrets. - Format dashboard graph metrics for better readability. - Added support for auto-detecting and setting the End-of-line character (LF/CRLF) in the query tool editor. - Make the background color for the serial number and header cells distinct. * Housekeeping - Updated the react-menu library from v2 to v4. - Remove bootstrap from the runtime code. - Remove the dependency on python packages eventlet and greenlet. * Bug fixes - Fixed an issue to allow the Enter key to save data in the result grid text editor. - Move ‘About pgAdmin 4’ to app menu on macOS. - Fixed an issue where the query tool was crashing when an empty geometry was being rendered. - Fixed an issue where role properties were not loading. - Fix multiple issues related to debugger params dialog input. - Fixed an issue where the dock layout was not saved upon closing a tab. - Fixed an issue where the copy shortcut CTRL +C was not working in the Query Tool data grid. - Fixed an issue where Dashboard tab showing ‘Something went wrong’. - Fixed an issue where cursor selection is not visible in the PSQL tool. - Allow OAuth2 params OAUTH2_NAME, OAUTH2_DISPLAY_NAME, OAUTH2_ICON, OAUTH2_BUTTON_COLOR to be optional. - Add appropriate minimum width and height setting for desktop apps to avoid app accidentally going below visibility levels. - Fixed an issue where graphical explain keeps the node details open even after plan changed. - Fixed an issue in the debugger where function arguments of the character data type were being truncated. - Fix the issue where rows do not retain shading when scrolling. - Use PG17 as the default in the container. - update to 8.12: * supported database servers - postgresql: 12, 13, 14, 15, 16 and 17 - edb advanced server: 12, 13, 14, 15 and 16 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.4 * New features - Added feature to restore preferences to their default values. - Add a new config variable - ALLOW_SPECIAL_EMAIL_DOMAINS to allow special domains for pgAdmin user emails. - Allow running non-continuous selected SQL code blocks in the query tool. * Housekeeping - Improved the extendability of the SchemaView and DataGridView. * Bug fixes - Fix the query tool restore connection issue on the server disconnection from the left side object explorer. - Revamp the current password saving implementation to a keyring and reduce repeated OS user password prompts. - Fixed an issue where users could not use pgAdmin if they did not have access to the management database. - Fixed an issue where servers listed in the servers.json file were being reimported upon container restart. - Added support for OIDC based OAuth2 authentication. - Fixed an issue where cursor moves to end of line when editing input fields. - Fixed an issue where “Quit App” confirmation modal in desktop app is not respecting “Confirm on close or refresh?”. - Fixed an issue where different client backend shows all SQL are same. - Fixed a security issue where the OAuth2 client ID and secret exposed through the web browser (CVE-2024-9014). - update to 8.11: * supported database servers - postgresql: 12, 13, 14, 15, 16 and 17 - edb advanced server: 12, 13, 14, 15 and 16 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.3 * New features - Add a home button to the geometry viewer to set original zoom level when the viewer was opened. * Housekeeping - Upgrade react-data-grid fork to latest and change pgAdmin accordingly. - Introduce custom React Hook useSchemaState to simplify SchemaView component. * Bug fixes - Fixed an issue where refreshing the Schema Diff tool opened in a new tab caused an error. - Fix server heartbeat logging error after deleting the server. - Fixed an issue where the Generate Script ignored filter conditions when a parent node was selected. - Fixed an issue where delete object(shortcut key) affecting both text and Object Explorer items. - Fix an issue where ERD tool should to be able to open saved pgerd file when using keyboard shortcuts. - Updated the documentation for web server authentication. - Fixed an issue where the REVOKE statement in the create script was throwing an error if the role contained special characters. - Improve code highlighting in query editor. - Fix an issue where the wheel package is not getting installed on the arm64-based macOS version < 14. - Fixed an issue where column resizing is not working in search objects dialog. - Fixed an issue where the value in the find box is not updating with selected text in editor if find is already open and re-triggered. - Fixed paths for Flatpak broken after Electron changes. - update to 8.10: * supported database servers - postgresql: 12, 13, 14, 15, 16 and 17 - edb advanced server: 12, 13, 14, 15 and 16 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.3 * New features - Add support for Postgres Server Logs for Text, CSV and JSON format in plain and tabular formats. Upgrade React to version 18. - Add a keyboard shortcut to close active tab panel. - Add support for highlighting selection matches in the query editor. * Housekeeping - Replace pgAdmin NW.js container with Electron container. - Updated to the latest version of the Notistack library. - Ensure that pgAdmin 4 is compatible with PostgreSQL v17. - Automatically apply virtualization in the DataGridView of SchemaView if the schema contains only one collection. - Add the git commit hash details to the About dialog. * Bug fixes - Fixed an issue where paste operation in query tool data grid should skip bytea columns and put the value as NULL instead. - Fixed an issue where the taskbar icon appeared as a red square for the query tool and schema diff when opened in a new window. - Fix issue with missing new added records in download file. - Fixed an issue where the File Open dialog did not show files without a dot extension. - Ensure pgAdmin never makes network requests to Google etc. - Fixed an issue where pop-up notifications from Object Explorer wouldn’t get dismissed automatically if the Query Tool was opened. - Fixed the permission denied issue for functions of the pgstattuple extension when accessing statistics with a non-admin user. - Ensure processes related notifiers disappears. - Updated entrypoint.sh to utilize the email-validator package for email validation. - Fixed an issue where users could not insert characters at the desired location, as it was added to the end of the line. - Fixed an issue where sorting the database activity table on the dashboard by any column caused the details to expand in the wrong position. - Fix an issue where the preferences JSON file has no effect when an external database is used. - Fixed an issue where theme preview under theme options was broken in pgAdmin server mode. - Fixed an issue where users could not autofill their saved passwords in the connect server dialog in the browser. - Fixed an issue where Generate Script button should be disabled if no objects are selected in the schema diff result. - Fixed an issue where ERD Open/Save shorcuts were not working on Windows/Linux. - Add a precautionary check for the query tool connection cursor to fix the error ‘NoneType’ object has no attribute ‘_query’. - Fixed an issue where boolean values in node details of graphical explain plan were not interpreted correctly. - Fixed an issue where Reassign/Drop Owned dialog not opening for Role. - Ensure pgadmin does not try to connect to the server if saved password is not available. - Ensure that pgAdmin works when opened in an iframe. - update to 8.9: * supported database servers - postgresql: 12, 13, 14, 15 and 16 - edb advanced server: 12, 13, 14, 15 and 16 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.3 * New features - Provide option to set theme based on OS theme preference. * Housekeeping - Remove the usage of MUI makeStyles as it doesn’t support React 18. * Bug fixes - Disable the query tool editor input if any SQL is being loaded to prevent users from typing. - Fixed an issue where resizable data editors in query tool should not be allowed to resize beyond the app window bounds. - Fixed new line indentation in query editor and add a user preference to disable it. - Ensure that a user can connect to a server using SSL certificates and identity files from a shared storage. - Fixed an issue where object explorer toolbar button not showing shortcut in the tooltip. - Add support for comments on RLS policy object. - Fixed an issue where changing a column name should reflect in all the constraints in table object dialog and ERD table dialog. - Fixed an issue where dark theme shows white background when all tabs are closed. - Ensure preferences can be loaded using preferences.json. - Fixed an issue where the schema diff incorrectly marked tables as different due to schema-qualified trigger functions in the trigger definitions. - Fixed an issue where backslash breaks syntax highlighting. - Search Objects dialog should focus on search input on open. - Fixed incorrect sorting of size in statistics tab. - Fixed an issue where query tool shortcuts for find/replace are not working. - Fixed migration failure while using external database. - Fixed an issue where query tool auto-complete stops working after connection change. - Fix the permissions issue in the pgAdmin installation directory on Debian and RHEL-8 platforms (CVE-2024-6238). - Fixed an issue where delete button in Users data was enabled for incorrect rows. - Rebase and update patches: * package_deps.patch * package_git_local.patch - Bump dependencies versions - Fix update-vendor.sh script to work with rpm 4.20. - Replace the npx command from `npx eslint --no-eslintrc ...` to `npx eslint --no-config-lookup ...` ------------------------------------------------------------------- Mon Dec 9 22:43:51 UTC 2024 - Steve Kowalik - Switch {Build,}Requires on Flask-Security-Too back to Flask-Security. ------------------------------------------------------------------- Mon Jun 17 10:11:42 UTC 2024 - Antonio Larrosa - update to 8.8: * supported database servers - postgresql: 12, 13, 14, 15, and 16 - edb advanced server: 12, 13, 14, 15, and 16 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.3 * Bug fixes - Fix an issue where user authentication fails with special characters in password. - Fixed an issue where canceling a query without privilege does not display any message on query tool. - Fix the issue where docker with SSL v8.7 fails to start. - Fixed an issue where the size displayed as 'NaN B' for all databases in the statistics tab. - Fixed an issue where backup and restore operations failed with the error 'This build does not support compression with gzip'. - update to 8.7: * supported database servers - postgresql: 12, 13, 14, 15, and 16 - edb advanced server: 12, 13, 14, 15, and 16 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.3 * New features - Added support for the 'Add to macros' feature and fixed various usability issues. - Added support for executing the query at the cursor position in the query tool. - Changes in Query Tool, Debugger, and ERD Tool shortcuts to remove the use of Accesskey which will allow them to be customized. - Added support for viewing PGD Clusters. - Enhance the Delete dialog by highlighting the names of the objects to be deleted in bold. - Added support for platform Ubuntu 24.04 and Fedora 40. * Housekeeping - Upgrade react-table from v7 to v8. - Replace the current FontAwesome based PSQL tool icon with MUI Terminal icon. * Bug fixes - Ensure that Schema Diff does not indicate a table as different when the trigger names are the same but the trigger function body is different. - Disable ERD for system catalogs. - Disable Debugger for system catalogs. - Fixed an issue where drag and drop publication and subscription name in SQL editors was not working. - Fixed an issue of the pgAdmin window size increasing each time it was reopened. - Update the documentation for preferences dialog and keyboard shortcuts. - Fixed an issue where pgAdmin fails to start when Ubuntu OS is upgraded to a major version. - Remove query info notifier timeout field from Query Tool Preferences Dialog. - Fixed incorrect highlighting for C-Style escape strings in SQL editor. - Fixed an issue where the recover password button was enabled even when no email was provided. - Fixed an issue where resetting the password from the password reset link was not working. - update to 8.6: * supported database servers - postgresql: 12, 13, 14, 15, and 16 - edb advanced server: 12, 13, 14, 15, and 16 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.1 * New features - Added the new columns "last_seq_scan" and "last_idx_scan" from the pg_stat_all_tables and pg_stat_all_indexes tables respectively to the Statistics tab. - Added support for excluding multiple tables while taking Backup. * Housekeeping - Update UI library MUI from v4 to v5, more details here - Upgraded Flask, Flask-Security-Too, Werkzeug, and other dependencies, ensuring compatibility with Python 3.7. * Bug fixes - Fixed all input boxes in pgAdmin to show browser auto-fill only where it is relevant. - Install dbus-python, an in-direct dependency of the Keyring package as a system package for Debian platforms. - Fixed an issue where debugger was not scrolling automatically on stepping. - Fixed an XSS vulnerability in the /settings/store endpoint (CVE-2024-4216, bsc#1223868). - Fixed an issue where double dollar quoted code is treated as string in syntax highlighter. - Fixed an issue where pressing backspace should remove the spaces and not the entire tab width, on enabling 'Use spaces?' in the preferences. - Fixed an issue where incorrect select/exec scripts were generated for functions/procedures. - Fixed an issue where connection to the database is not automatically re-established after connectivity drop. - Fixed an issue when closing the view data second tab; it raises the error that the 'ViewCommand' object has no attribute 'auto_commit'. - Fixed violates check constraint issue when creating a pgAgent schedule. - Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215, bsc#1223867). ------------------------------------------------------------------- Mon Apr 8 09:08:22 UTC 2024 - Antonio Larrosa - update to 8.5: * supported database servers - postgresql: 12, 13, 14, 15, and 16 - edb advanced server: 12, 13, 14, 15, and 16 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.1 * New features - Added support for provider, deterministic, version and RULES parameter while creating collation. - Added support for EDB Job Scheduler. - Added support for viewing Log Based Clusters. - Added support for UNIX socket in entrypoint.sh for Docker implementation. * Bug fixes - Fixed an issue in Schema Diff where Columns with sequences get altered unnecessarily. - Fixed an issue where user was unable to share a newly registered server. - Bug fixes and improvements in pgAdmin CLI. - Fixed an issue where the 'Save Password' option for SSH tunneling password was consistently disabled. - Fixed schema diff wrong query generation for table, foreign table and sequence. - Fixed an issue where table properties were not updating from properties dialog. - Fixed an issue where maximize icon is missing from query tool panel. - Fix an issue in table dialog where changing column name was not syncing table constraints appropriately. - Fixed rollback and commit button activation on execute button click. - Fixed an issue where taking backup of a shared server was using server owner's user name. - Fix an issue in editor where replace option in query tool edit menu is not working on non-Mac OS. - Fix an issue in editor where Format SQL shortcut and multiline selection are not working. - Fix an issue in editor where "Use Spaces?" Preference of Editor is not working. - Fixed an issue where Triggers, Rules, Indexes were absent from the Schema Diff when comparing views. - Fix an issue in query tool where toggle case of selected text loses selection. - Fix query tool autocomplete results when cursor is in between the SQL query. - Fix an issue in query tool where custom keyboard shortcuts are not working for some. - Fixed the issue where the update-user CLI command doesn't change the password. - Fixed issue related to email authentication of Two-factor authentication. - Fixed a remote code execution issue in the validate binary path (boo#1222390, CVE-2024-3116). - update to 8.4: * supported database servers - postgresql: 12, 13, 14, 15, and 16 - edb advanced server: 12, 13, 14, 15, and 16 * bundled postgresql utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.1 * New features - Allow preferences customization using a configuration file. - Add support for JSON log format. - Add --yes option for skipping the confirmation prompt while deleting the user via CLI for scripting purpose. * Housekeeping - Upgrade CodeMirror from version 5 to 6. - Added documentation for Dashboard's System Statistics tab. - Separate the application name, branding & version information from the configuration file. - Upgrade python packages cryptography to 42.0.x and Flask-Security-Too to 5.3.x. * Bug fixes - Fix multiple issues where PasswordExecCommand was not working in server mode and PasswordExecCommand was not loaded when importing servers. - Fix the tabbed panel backward/forward shortcut for tabs. - Fixed an issue where dependencies and dependents were not showing if a composite type is used as an attribute in another composite type. - Fix an issue where constraint check control is enabled in the edit table dialog. - Fix an issue where the scripts created by generate script of Schema diff for Table with sequence was not working earlier. - Ensure that the OAuth2 session is logged out when users log out from pgAdmin. - Remove role related checks on the UI dashboard when terminating session/query and let PostgreSQL take care of it. - Fix an issue where type column in dependents/dependencies tab is not showing correct label. - Unsafe Deserialization and Remote Code Execution by an Authenticated user in pgAdmin 4 (boo#1221172, CVE-2024-2044). - Replace the requirement for cryptography 42.0 to be satisfied with 41.0 (which is the version we have in SLE) given that the code using the cryptography module doesn't seem to really require 42.0 . ------------------------------------------------------------------- Wed Feb 21 16:21:52 UTC 2024 - Antonio Larrosa - ExcludeArch: s390x ------------------------------------------------------------------- Mon Feb 19 13:59:59 UTC 2024 - Antonio Larrosa - Update to 8.3: * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14, 15, and 16 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.0 * New features - Allow drag-n-drop columns collection tree node as comma separated columns. - Added support to rename columns in Views. - Added BYPASSRLS|NOBYPASSRLS option while creating a Role. - Added support for column storage syntax while creating table. - Use COOKIE_DEFAULT_PATH or SCRIPT_NAME in session cookie path. - Added configurable parameter to enable support for PasswordExecCommand in server mode. * Bug fixes - Fixed an issue where format sql was messing up operator. Included many other feature changes, more details here - Fixed an issue where formatting inserts empty lines in specific case. - Add support for selecting a schema in the backup database dialog with no tables, mviews, views or foreign tables. - Fixed a UI border issue on the dependencies tab for columns with icon. - Fixed an issue where multiple errors were showing if user does not have connect privileges. - Fixed an issue where group membership information was displayed incorrectly. - Ensure that the correct SQL is generated when changing the column data type to "char". - Fixed an issue pgAdmin fails to launch due to inconsistent PATH variable name on windows. - Fix a backend server error when creating a named restore point. - Fix wrong default for FORCE_LOWER in the FLASK_GRAVATAR module. ------------------------------------------------------------------- Fri Feb 9 09:31:20 UTC 2024 - Antonio Larrosa - Add node_modules.spec.inc as Source to satisfy factory-auto. ------------------------------------------------------------------- Thu Feb 8 13:55:25 UTC 2024 - Antonio Larrosa - Fix shebang of pgadmin4-desktop to use python3.11 ------------------------------------------------------------------- Tue Feb 6 08:14:21 UTC 2024 - Antonio Larrosa - New pgadmin4-cloud subpackage that includes now the cloud dependencies and make the pgadmin4-cloud package optional so it's now optional to depend on the azure/aws/google python packages. - Add patch to let pgadmin4 work without cloud support: * make-cloud-packages-optional.patch ------------------------------------------------------------------- Fri Feb 2 06:59:36 UTC 2024 - Antonio Larrosa - Add a optipng script that actually uses pngcrush to compress png images so we don't depend on optipng which is not available in SLE. - Fix pgadmin4-desktop to use a timer instead of threads. It seems there's an issue the way python threads were used with Qt5 that made the script fail to update the systray menu when pgadmin was started. - Add missing python-typer dependency - Add pgadmin4-user.conf file to create the pgadmin user/group using systemd with the new system-user-pgadmin package. ------------------------------------------------------------------- Mon Jan 29 15:54:39 UTC 2024 - Adam Majer - Replace yarn (which is not available in SLE) with local-npm-registry. - Add node_modules service and node_modules.obscpio / node_modules.spec.inc source files which replace vendor.tar.xz that is now removed. - package_deps.patch - dependency fixes - package_git_local.patch - dependency fixes that are needed *after* generating package-lock.json since only registry-supplied packages are available locally. - Update update-vendor.sh script. ------------------------------------------------------------------- Mon Jan 15 09:10:32 UTC 2024 - Antonio Larrosa - Update to 8.2 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14, 15, and 16 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.0 * New features - Administer pgAdmin Users and Preferences Using the Command Line Interface (CLI). - Allow users to convert View/Edit table into a Query tool to enable editing the SQL generated. - Added copy server support, allowing the duplication of existing servers with the option to make certain modifications. - Added keep-alive support for SSH sessions when connecting to a PostgreSQL server via an SSH tunnel. * Housekeeping - Ensure that eventlet's subprocess should be used following the resolution of an issue with Python 3.12 by eventlet. * Bug fixes - Fixed an issue where query tool title did not change after "Save As" until any new change is made. - Fixed an issue where export servers was not adding extension if not specified. - Fixed an issue where pgAdmin imports servers to the wrong accounts for the external authentication. - Fixed an issue where an error occurred in the SQL tab when using an extended index(pgroonga). - Fixed an issue where changes done to a node using edit dialog are not reflecting on the properties tab if the properties tab is active. - Fixed an issue where DB Restrictions were not visible on the server dialog. - Ensure that the 'Dbo' schema is displayed as a regular schema rather than a system catalog schema. - Introduce LDAP configuration parameter LDAP_IGNORE_MALFORMED_SCHEMA to ignore fetching schema from the LDAP server. - Fixed an error-'amname' when generating ERD for database containing partition tables. - Fixed an issue where object explorer last tree state was not saving. - Fixed an issue where pgAgent job schedule dialog is not opening for edit. - Fixed an issue where user is not able to cancel or terminate active queries from dashboard. - Fixed browser autocomplete related issues on pgAdmin authentication related pages. - Fixed an issue where auto commit/rollback setting not persisting across query tool connection change. - Fixed an issue where Schema Diff not generating difference for missing columns. - Update to 8.1 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14, 15, and 16 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.0 * New features - Add support for generating ERD for a schema. - Add support for creating a function with custom return type. * Housekeeping - Fixed several accessibility-related issues for enhanced usability. * Bug fixes - Ensure focus is not changed to ssh tunnel password input when user explicitly focus on server password input. - Provide a way to bypass the SSL cert verification for OAuth2 provider. - Fixed an issue where database name was missing in an error message if name contains any special characters. - Ensure that indexes created by constraints are visible in the object explorer when "Show system objects" is enabled. - Fixed an issue where reading process logs throws an error when DATA_DIR is moved to a networked drive. - Remove the 'Close Window' submenu specifically for OSX to prevent unintended closure of the entire application. - Rename all references of 'Execute query' to 'Execute script' to be more relevant. - Fixed an issue where syntax error was not highlighting in query tool. - Fixed an issue where on entering full screen, the option label is not changed to 'Exit Full Screen' in desktop mode. - Ensure that the Authentication Source in the drop-down of the UserManagement dialog aligns with the entries specified for AUTHENTICATION_SOURCES in the configuration file. - Reverse engineer serial columns when generating ERD for database/table. - Fixed an issue where the Schema was not visible in the dropdown for table properties or when creating a new table. - Fixed an issue where option key was not registering in PSQL tool. - Fixed an issue where the Vacuum option INDEX_CLEANUP have an incorrect value ('AUTO') for database versions < 14. - Fixed an issue where the pgAdmin page went blank when clicking the delete button in the User Management dialog. - Ensure that correct timezone is set for Docker deployments. - Fixed an issue where all rows and filter rows buttons of object explorer toolbar were disabled for views and other supported nodes. - Fixed an issue where schema diff tool is not loading preferences on start. ------------------------------------------------------------------- Thu Nov 30 11:57:25 UTC 2023 - Antonio Larrosa - Changes in the spec file so it can be used in Factory as well as in SLE - Modify the pgadmin4-desktop helper to use PyQt5 instead of PyQt6 since the latter is not available in SLE ------------------------------------------------------------------- Fri Nov 24 13:22:24 UTC 2023 - Antonio Larrosa - Update to 8.0 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14, 15, and 16 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.0 * New features - Have close buttons on individual panel tabs instead of common. - Allow closing all the tabs, including SQL and Properties. - Changes in the context menu on panel tabs - Add close, close all and close others menu items. * Housekeeping - Update app bundle built to use notarytool instead of altool. - Replace the current layout library wcDocker with ReactJS based rc-dock. - Upgrade Flask, Werkzeug and other modules depends on the latest version of Flask. * Bug fixes - Fix an issue where the scroll position of panels was not remembered on Firefox. - Add DROP SQL for foreign keys in SQL generated by ERD when using WITH DROP option. - Fixed an issue where psql was not taking the role used to connect in server properties. - Fixed an issue where Geometry Viewer renders geometry incorrectly after trying to view 3D or non-4326 SRID geometry. - Fix the sorting of size on the statistics panel. - Fixed restoration of query tool database connection after dropping and re-creating the database with the same name. - Fix an issue where the default server-group is being deleted if the load-server json file contains no servers. - Fix an issue of the incorrect format (no indent) of SQL stored functions/procedures. - Server config information in the about dialog should be only visible to admin users. - Fixed an issue where Schema Diff does not work when the user language is set to any language other than English in Preferences. - Fixed the query generated when creating subscription where copy_data parameter was missing. - Ensure backup/restore/maintenance works with invalid pgpass file parameter. - Fix an issue where OAUTH_ADDITIONAL_CLAIMS does not recognise AzureAD with > 150 groups. - Fixed circular import error occurring while deploying cloud PostgreSQL instance from pgAdmin. - Fix an issue where the browser window stuck on spinning with an Oauth user without email. - Fix an issue where import/export data is not working for shared servers. - Remove the max length of 255 from password exec command in server configuration dialog. - Remove gettext from empty strings in the title of the storage graph. - Fixed an issue where the change server password is not working in desktop mode. - Fix a crash issue occurring when debugging a function with arguments when using pgAdmin with external config database. - Fix an issue in ERD tool where SQL generated is missing columns for the table. - Clear the password field in the config database on clear saved server password. - Fixed an issue where the data type of the array type was not visible for the column in the Foreign Table dialog. - Drop patches that are not needed anymore: * support-new-werkzeug.patch * support-new-flask.patch ------------------------------------------------------------------- Mon Oct 30 11:23:57 UTC 2023 - Antonio Larrosa - Add obsoletes: pgadmin4-web ------------------------------------------------------------------- Wed Oct 25 06:26:07 UTC 2023 - Antonio Larrosa - Add a vendor.tar.xz source package with node modules that have to be downloaded in the developer workstation since otherwise they won't be able to get downloaded in the build service. - Add an update-vendor.sh script that updates (actually, recreates) the vendor.tar.xz package. This should be run manually with each package update. - Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used at all for some time. - Add patch to set the environment variable EVENTLET_NO_GREENDNS which fixes pgadmin4 to build successfully with eventlet 0.33.3, httpcore 0.17.1 and httpx 0.24.0: * fix-eventlet-select_epoll.patch - Merged pgadmin4-web subpackage into the main pgadmin4 package which now installs the pgAdmin4 server. - Create new pgadmin4-desktop subpackage that includes a very small python script I wrote that starts the pgadmin4 server in runtime mode (as a regular user) and provides a system tray icon so users can open new windows and quit the server with a UI since the alternative (using the official pgAdmin4 runtime application would require providing a full node.js modules tree and using NW.js for the ui). - Fix .desktop file which was now moved to the pgadmin4-desktop subpackage. The "Encoding" key is deprecated so it has been removed, only one main category is now used in the Categories key and the path to the icon was fixed. - Remove pgadmin4.qt.conf.in which is not used anymore ------------------------------------------------------------------- Wed Oct 25 06:24:15 UTC 2023 - Antonio Larrosa - Update to 7.8 * Supported Database Servers - PostgreSQL: 12, 13, 14, 15, and 16 - EDB Advanced Server: 12, 13, 14 and 15 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 16.0 * New features - Add support for foreign table's new functionality for PG 11 and above. - Allow setting custom username for shared servers, with default as username of server being shared. - Add 'GENERATED ALWAYS AS..' option while creating column constraints for Foreign Table. - GUI representation of the system's activity using the 'system_stats' extension. - Added 'load_balance_hosts' connection string parameter for PG 16 and above. * Housekeeping - Use PG16 as the default PostgreSQL version. * Bug fixes - Fixed an issue in ERD tool where the downloaded images have a few links cut. - Fixed an issue where user was not able to assign new/old columns as primary key once column with primary key is deleted. - Add support for setting prepare threshold in server connection. - Fixed an issue where the wrong message "Current database has been moved or renamed" is displayed when debugging any function. - Fixed an issue where Processes tab displays wrong server name in some scenario. - Fix an issue where global/native keyboard shortcuts are not working when any cell of data output grid has focus. - Fixed query history slowness issue by storing query only for those having certain threshold max length. - Fix an issue where foreign table column name becomes "none" if the user changes any column data type. - Pin the cryptography version to fix PyO3 modules initialisation error. - Ensure that the backup works properly for PG 16 on the latest docker image. - Fixed an issue where the user is unable to select objects on the backup dialog due to tree flickering. - Fixed an issue where non-super PostgreSQL users are not able to terminate their own connections from dashboard. - Fix an issue where scale in columns is not allowed to have value as 0 or below. - Fix an issue in graphical explain plan where query tool crashes when the plan has parallel workers details and sort node is clicked for details. - Fix an issue where user login is not working if username/email contains single quote in server mode. - Update to 7.7 * Supported Database Servers - PostgreSQL: 11, 12, 13, 14 and 15 - EDB Advanced Server: 11, 12, 13, 14 and 15 * Bundled PostgreSQL Utilities - psql, pg_dump, pg_dumpall, pg_restore: 15.4 * New features - Added support to select/deselect objects in the Backup dialog. - Added all the new options of the 'WITH' clause in the subscription dialog. - Added USING method while creating the table. - Added compression method option while creating a column. - Added Strategy, Locale Provider, ICU Locale, ICU Rules, and OID options while creating a database. - Added USING method while creating the materialized view. - Add support for additional ID token claim checks for OAuth 2 authentication. * Housekeeping - Added the ‘data type’ column in the properties tab of the Columns collection node. * Bug fixes - Fix an issue where user is not able to change the password when SMTP is not configured. - Ensure user is redirected to login page after failed login. - Ensure that Materialized view size fields in "Statistics" should be human-readable. - Fix an issue where changing the password shows success but the new password is not working. - Fix an issue where login form doesn't appear if internal auth source is removed. - Fix a security related issue where an authenticated user can run remote command using validate binary path API (CVE-2023-5002, boo#1215603). ------------------------------------------------------------------- Fri Aug 25 11:52:39 UTC 2023 - Simon Lees - Update to 7.6 - Features: - Added Expression to CREATE INDEX. - Added cascade option while creating an extension. - Added ‘Ignore Grants’ option in the schema diff tool. - Added ‘Ignore Tablespace’ option in the schema diff tool. - Added support for ALTER INDEX column statistics. - Added unlogged option while creating a sequence. - Added all like options while creating a table. - Added support for SYSTEM, CONCURRENTLY and TABLESPACE options in REINDEX. - Added WAL option to EXPLAIN ANALYZE command. - Added new/missing options to the VACUUM command. - Added SKIP_LOCKED and BUFFER_USAGE_LIMIT option to Analyze command. - Add support for TRUNCATE trigger in foreign table. - Ensure that Schema Diff comparison results should be displayed in the sorted order. - Added support to detach partitions using concurrently and finalize. - Added all supported index storage parameters while creating an index. - Added new/missing parameters to pg_dumpall (Backup Server). - Added new/missing parameters to pg_dump (Backup Objects). - Added new/missing parameters to pg_restore. - Housekeeping: - Generate software bill of materials as part of the package builds. - Added support for PostgreSQL and EPAS 16 to ensure it works without any errors. - Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS. - Enable cluster deployment with gp3 volume for AWS & BigAnimal cloud providers. - Clarify the LICENSE file to indicate that it is the PostgreSQL Licence. - Remove unsupported PostgreSQL versions from the container. - Bug fixes: - Fix incorrect redirection URL after authentication by removing fixed value set to SCRIPT_NAME environment variable in pgAdmin4.wsgi file. - Allow changing the POOL_SIZE and MAX_OVERFLOW config values of the pgAdmin config DB connection pool. - Fix an issue where query tool on shared server is throwing error if the pgAdmin config DB is external. - Fix the query tool issue where raise Notice from func/proc or code blocks are no longer displayed live. - Fix the issue where query tool window turns blank if the user tries to generate a graph on the result. - Fix an issue where changing MFA_SUPPORTED_METHODS breaks the MFA validation. - Fix an issue where pgAdmin 7.5 fails to render table SQL with extension loaded index method. - Fix an issue where cycle syntax was not added in SQL when creating new sequence from UI. - Fix an issue where the SET directive is excluded from the function header in the schema diff tool. - Fix a query tool error ‘pgAdminThread’ object has no attribute ‘native_id’. - Ensure keyboard shortcut for query execution is disabled when query execution is in progress. - Fix an issue where queries can’t complete execution. - Fixed an issue where Import Export not working when using pgpassfile. - Fix an issue where queries longer than 1 minute get stuck - Container 7.1 - Fix an issue where queries get stuck with auto-completion enabled. - Fixed Query Tool/ PSQL tool tab title not getting updated on database rename. - Ensure user gets proper error if incorrect credentials are entered while authenticating AWS. - Fix an issue where the edit server fails in desktop mode if the server password is not stored. - Ensure that Backup, Restore, and Maintenance should work properly when pgpass file is used. - Fix the query tool auto-complete issue on the server reconnection. - Fix the query tool restore connection issue. - Fix the reconnecton issue if the PostgreSQL server is restarted from the backend. - Fix the connection and stability issues since v7, possibly related to background schema changes. - Fixed an issue where the query tool is unable to execute a query on Postgres 10 and below versions. - Fix the lost connection error in v7.4. - Fixed an issue where pgAdmin failed to setup role with hyphens in name. - Fixed an issue where filters are not working and query history shows empty queries. - Fix an issue where adding a sub-folder inside a folder is not working as expected in File Manager. - Fix an error ‘list’ object has no attribute ‘strip’ while attempting to populate auto-complete manually the first time. - Fixed an issue where ERD Tool can’t load the saved pgerd file from Shared Storage. - Fix an issue where inserting more than 10 rows does not work correctly in View Data; only parts end up in the table. - Add support-new-flask.patch to fix build with flask 2.3 ------------------------------------------------------------------- Mon Jul 31 07:23:54 UTC 2023 - Steve Kowalik - Update to 7.4, extremely large list of changes, partially chosen: * Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. * Added support for Logical Replication. * Implemented runtime using NWjs to open pgAdmin4 in a standalone window instead of the system tray and web browser. * Added Quick Search functionality for menu items and help articles. * Added publication and subscription support in Schema Diff. * Use cheroot as the default production server for pgAdmin4. * Show the login roles that are members of a group role be shown when examining a group role. * 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. * Use schema qualification while accessing the catalog objects. * Make the 'Save Data Changes' icon to be more intuitive. * Improve code coverage and API test cases for Server module. * 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. * 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. * 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. * 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. * 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. * 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'. * 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. * Set PSQLRC and PSQL_HISTORY env vars to apt. user storage path in the server mode. * Added support for OWNED BY Clause for sequences. * Revisit all the CREATE and DROP DDL's to add appropriate 'IF EXISTS', 'CASCADE' and 'CREATE OR REPLACE'. * 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. * Added support of Aggregate and Operator node in view-only mode. * Ensure that users should be able to modify the REMOTE_USER environment variable as per their environment by introducing the new config parameter WEBSERVER_REMOTE_USER. * Added support for Two-factor authentication for improving security. * Added support to disable the auto-discovery of the database servers. * Replace Flask-BabelEx with Flask-Babel. * Upgrade Flask to version 2. * Added support to import/export server groups and servers from GUI. * Added support to open SQL help, Dialog help, and online help in an external web browser. * Rename the menu 'Disconnect Server' to 'Disconnect from server'. * Added capability to deploy PostgreSQL servers on Amazon RDS. * Rename the menu 'Disconnect Database' to 'Disconnect from database'. * Added transaction start time to Server activity sessions view. * Added support for unique keys in ERD. * Added status bar to the Query Tool. * Ensure that row numbers should be visible in view when scrolling horizontally. * Relocate GIS Viewer Button to the Left Side of the Results Table. * Added capability to deploy PostgreSQL servers on EDB BigAnimal. * Added options 'Ignore owner' and 'Ignore whitespace' to the schema diff panel. * Added support for Azure AD OAUTH2 authentication. * Ensure the database and schema restriction controls are not shown as a drop-down. * Added the ability to resize columns on dashboard tables. * PG 15 compatibility issues fixed. * Added capability to deploy PostgreSQL servers on Microsoft Azure. * Added support for visualise the graph using a Line chart in the query tool. * Added option to trigger autocomplete on key press in the query tool. * Allow users to delete files/folders from the storage manager. * Allow users to search within the file/storage manager. * Added support for visualizing the graphs using Stacked Line, Bar, and Stacked Bar charts in the query tool. * Added support for visualise the graph using a Pie chart in the query tool. * Removing dynamic module loading and replacing it with static loading. * Added support to show all background processes in separate panel. * Added support to create triggers from existing trigger functions in EPAS. * Remove the SQL files for the unsupported versions of the database server. * Fixed improper parsing of HTTP requests in Pallets Werkzeug v2.1.0 and below (CVE-2022-29361). - Included in 6.19: Fix a vulnerability that allows a user of the product to change another user's settings or alter the database (bsc#1207464, CVE-2023-0241). - Included in 6.14: Fix a vulnerability that allows a remote unauthenticated user to redirect a user to an arbitrary web site by crafting a malicious URL (boo#1207238, CVE-2023-22298). - Included in 6.7: Fix for unrestricted file upload (boo#1197143, CVE-2022-0959). - Included in 6.5: Fixed an issue when uploading a CSV throwing an error in the Desktop mode - Drop patches remove_simplejson_dep.patch, fix-python-lib.patch and 0001-Fix-bug-ValueError-unsupported-format-character-D.patch - Add patch support-new-werkzeug.patch and support-new-azure-mgmt-rdbms.patch: * Support changes among our dependencies. ------------------------------------------------------------------- Sat Feb 11 16:50:03 UTC 2023 - Matej Cepl - Remove dependency on python-simplejson (gh#pgadmin-org/pgadmin4#5853). ------------------------------------------------------------------- Wed Jun 9 10:06:10 UTC 2021 - Ralf Habacker - Add 0001-Fix-bug-ValueError-unsupported-format-character-D.patch to fix bug reported at https://redmine.postgresql.org/issues/6522 ------------------------------------------------------------------- Tue Feb 2 13:59:50 UTC 2021 - Antonio Larrosa - Fix typos (chmod being used instead of chown in %postun web and pgadmin4 used in the service file for User/Group keys instead of pgadmin) ------------------------------------------------------------------- Mon Feb 1 12:43:28 UTC 2021 - Marcus Rueckert - the system wide service does not need to run as root. switch to user/group pgadmin ------------------------------------------------------------------- Sat Jan 30 04:22:43 UTC 2021 - Marcus Rueckert - Update to 4.30 - Features: - ERD Tool (Beta): The Entity-Relationship Diagram (ERD) tool is a database design tool that provides a graphical representation of database tables, columns, and inter-relationships. You can use the ERD tool to design a new schema and generate the SQL required to create it, or to reverse engineer and diagram an existing database schema. - Kerberos support is added in pgAdmin 4 using SPNEGO for logging into pgAdmin, similar to the existing LDAP and "internal" options. Note that support for logging into database servers using Kerberos is not included in this release, but will be added in a future version. - Add a container option (PGADMIN_DISABLE_POSTFIX) to disable the Postfix server: Postfix (like other MTAs) must start as user 'root', and the pgAdmin container achieves this using 'sudo'. Whilst that works well in most environments, it can cause problems in some. This option allows you to completely disable Postfix to avoid these issues, though you will need to configure an external mail server to be used to send password reset emails. - Bugs/Housekeeping: - Improve the explain plan details by showing a popup instead of a tooltip when clicking on plan nodes. - Ensure that verbose logs are visible for Utility (Backup, Maintenance etc.) jobs. - Added support for expressions in exclusion constraints. - Ensure that the 'template1' database is not visible after pg_upgrade. - Added appropriate help message and a placeholder for letting users know about the account password expiry for Login/Group Role. - Updated Flask-BabelEx to the latest version. - Fixed extra parentheses issue around joins for Views. - Ensure that the current value of sequences is ignored while comparing using Schema Diff. - Fixed an issue when the user tries to delete multiple records in the data grid. - Fixed TypeError exception in schema diff when selecting two identical objects. - Include PostgreSQL 13 utilities in the container distribution. https://www.pgadmin.org/docs/pgadmin4/4.30/release_notes_4_30.html ------------------------------------------------------------------- Wed Jan 27 11:26:24 UTC 2021 - Antonio Larrosa - Fix the desktop application by removing the overriding of SERVER_MODE in config_system.py and config_distro.py which were forcing SERVER_MODE to always have a specific value instead of letting the runtime choose so there's no need to force it. - Rename pgadmin4.conf to pgadmin4.conf.in, pgadmin4.uwsgi to pgadmin4.uwsgi.in and README.SUSE.uwsgi to README.SUSE.uwsgi.in and make them also replace PYTHONSITELIB with the python version used at build time - Replace all variables from config files in %prep instead of %install - Include README.SUSE.uwsgi in the web-uwsgi subpackage ------------------------------------------------------------------- Wed Jan 27 10:51:24 UTC 2021 - Antonio Larrosa - Add BuildRequires for python-cryptography and replace dependency for python-Flask-Babel with python-Flask-BabelEx ------------------------------------------------------------------- Fri Dec 11 11:16:37 UTC 2020 - Andreas Schneider - Add BuildRequires for python modules ------------------------------------------------------------------- Fri Dec 11 07:59:42 UTC 2020 - ecsos - Update to 4.29: - Ensure that folder rename should work properly in Storage Manager - Fixed an issue where the debugger's custom tab title not applied when opened in the new browser tab - Fixed an issue where dynamic tab title has not applied the first time for debugger panel - Fixed an issue where schema diff doesn't show the result of compare if source schema has tables with RLS - Fixed an issue where the process watcher dialog throws an error for the database server which is already removed - Ensure that code coverage should cover class and function declarations - Ensure that dirty indicator (*) should not be visible when renaming the tabs - Fixed an issue where shared servers import is failing - Improve code coverage and API test cases for Foreign Tables, Debugger, Views and Materialized Views - Fix some requirement versions. ------------------------------------------------------------------- Wed Nov 18 03:01:56 UTC 2020 - Marcus Rueckert - Update to 4.28: - Added support to download utility files at the client-side. - Added support to rename query tool and debugger tabs title. - Added support for dynamic tab size. - Added tab title placeholder for Query Tool, View/Edit Data, and Debugger. - Added support to compare schemas and databases in schema diff. - Ensure that non-superuser should be able to debug the function. - Ensure that query history should be listed by date/time in descending order. - Ensure that Grant Wizard should include foreign tables. - Ensure that search object functionality works with case insensitive string. ------------------------------------------------------------------- Sat Oct 17 09:21:57 UTC 2020 - ecsos - Update to 4.27: - Added Macro support. - Added support to view trigger function under the respective trigger node. - Allow user to change the database connection from an open query tool tab. - Added support to ignore the owner while comparing objects in the Schema Diff tool. - Merged the latest code of 'pgcli' used for the autocomplete feature. - Fixed invalid literal issue when fetching dependencies for Materialized View. - Fixed an issue where schema diff is showing identical table as different due to default vacuum settings. - Ensure that the user should be able to change the start value of the existing sequence. - Fixed an issue where the query tool is not fetching more than 1000 rows for the table does not have any primary key. - Fixed an issue where 'Rows X' column values were not visible properly for Explain Analyze in Dark theme. - Fixed an issue where file extension is stripped on renaming a file. ------------------------------------------------------------------- Mon Sep 21 18:45:31 UTC 2020 - Andreas Schneider - Specify path for pg_dump and pg_restore - Disable update check (if you're on leap or other you wont be able to upgrade to a newer version anyway) ------------------------------------------------------------------- Sun Sep 20 16:43:55 UTC 2020 - Marcus Rueckert - Update to 4.26: - Added SQL Formatter support in Query Tool. - Added a new button to the query tool toolbar to open a new query tool window. - Added shared server support for admin users. - Warn the user when connecting to a server that is older than pgAdmin supports. - Ensure that schema names starting with 'pg' should be visible in browser tree when standard_conforming_strings is set to off. - Fixed an issue where --load-server does not allow loading connections that use pg_services. - Fixed string indices must be integers issue for PostgreSQL < 9.3. - Fixed an issue where the application ignores the fixed port configuration value. - Remove illegal argument from trigger function in trigger DDL statement. - Ensure that 'setup-web.sh' should work in Debian 10. - Fixed excessive CPU usage by stopping the indefinite growth of the graph dataset. ------------------------------------------------------------------- Fri Sep 11 13:03:51 UTC 2020 - Andreas Schneider - Create a pgadmin user and group - Add uwsgi configuration (fast, user privileges and apparmor support) ------------------------------------------------------------------- Thu Sep 10 19:24:29 UTC 2020 - Andreas Schneider - Only activate the pgadmin4 apache config if the PGADMIN4 flag is set. For mod_wsgi you should use `a2enmod wsgi` - Create /etc/pgadmin/config_system.py with server mode for web Run /usr/lib/python3.6/site-packages/pgadmin4-web/setup.py to create the admin user - Remove config_local.py with outdated options ------------------------------------------------------------------- Mon Sep 7 13:32:12 UTC 2020 - Paolo Stivanin - Update to 4.25: - Modified schema diff tool to compare two databases instead of two schemas - Resolve schema diff dependencies by selecting the appropriate node automatically and maintain the order in the generated script. - Replace charting library Flotr2 with ChartJS using React. - Upgrade font-awesome from v4 to v5. - Fixed an issue where debugger doesn't work if the search path is set other than 'public'. - Fixed ssh tunnel hang issue when the user tries to disconnect the server. - Fixed an issue where conversion of bytea to the binary string results in an error. - Fixed an issue where the entire logs are in red text when the user runs backup and restore. - Ensure that the user will be able to modify the start value of the Identity column. - Fixed an issue where 'ALTER VIEW' statement is missing when the user sets the default value of a column for View. ------------------------------------------------------------------- Tue Aug 4 14:42:39 UTC 2020 - Marcus Rueckert - Update to 4.24 - New features - Issue #5235 - Support configuration files that are external to the application installation. - Issue #5484 - Added support for LDAP authentication with different DN by setting the dedicated user for the LDAP connection. - Issue #5583 - Added support for schema level restriction. - Issue #5601 - Added RLS Policy support in Schema Diff. - Issue #5622 - Added support for permissive/restricted policy type while creating RLS Policy. - Issue #5650 - Added support for LDAP anonymous binding. - Issue #5653 - Added High Contrast theme support. - Housekeeping - Issue #5323 - Improve code coverage and API test cases for Foreign Data Wrapper. - Issue #5326 - Improve code coverage and API test cases for Domain and Domain Constraints. - Issue #5329 - Improve code coverage and API test cases for FTS Configuration, FTS Parser, FTS Dictionaries, and FTS Template. - Bug fixes - Issue #3814 - Fixed issue of error message not getting displayed when filename is empty for backup, restore, and import/export. - Issue #3851 - Add proper indentation to the code while generating functions, procedures, and trigger functions. - Issue #4235 - Fixed tab indent issue on a selection of lines is deleting the content when ‘use spaces == true’ in the preferences. - Issue #5137 - Fixed save button enable issue when focusing in and out of numeric input field. - Issue #5287 - Fixed dark theme-related CSS and modify the color codes. - Issue #5414 - Use QStandardPaths::AppLocalDataLocation in the runtime to determine where to store runtime logs. - Issue #5463 - Fixed an issue where CSV download quotes numeric columns. - Issue #5470 - Fixed backgrid row hover issue where on hover background color is set for edit and delete cell only. - Issue #5530 - Ensure that the referenced table should be displayed on foreign key constraints. - Issue #5554 - Replace the runtime themes with ones that don’t have sizing issues. - Issue #5569 - Fixed reverse engineered SQL for partitions when storage parameters are specified. - Issue #5577 - Include LICENSE and DEPENDENCIES [inventory] files in official packages. - Issue #5621 - Remove extra brackets from reverse engineering SQL of RLS Policy. - Issue #5629 - Fixed an issue where the user is able to edit properties when some of the collection nodes are selected. - Issue #5630 - Fixed an issue where installation of pgadmin4 not working on 32-bit Windows. - Issue #5631 - Fixed ‘cant execute empty query’ issue when remove the value of ‘USING’ or ‘WITH CHECK’ option of RLS Policy. - Issue #5633 - Ensure that create RLS Policy menu should not be visible for catalog objects. - Issue #5647 - Fixed an issue where difference DDL is showing the wrong SQL when changing the policy owner. - Issue #5662 - Fixed accessibility issue where few dialogs are not rendering properly when we zoomed in browser window 200% and screen resolution is low. - Issue #5666 - Added missing dependencies/dependent and corrected some wrongly identified. - Issue #5673 - Fixed an issue where fetching the schema throws an error if the database is not connected in Schema Diff. - Issue #5675 - Fixed CSRF errors when pgAdmin opened in an iframe on safari browser. - Issue #5677 - Fixed text color issue in explain analyze for the Dark theme. - Issue #5686 - Fixed issue where the user was not able to update policy if the policy is created with space. - update requires to match requirements.txt ------------------------------------------------------------------- Tue Jul 14 13:27:20 UTC 2020 - Marcus Rueckert - Update to 4.23 - New features - Issue #5468 - Added option to ignore the whitespaces while comparing objects in schema diff. - Issue #5500 - Added server group name while selecting servers in schema diff. - Issue #5516 - Added support of Row Security Policies. - Issue #5576 - Improve error messaging if the storage and log directories cannot be created. - Housekeeping - Issue #5325 - Improve code coverage and API test cases for Collations. - Issue #5574 - Cleanup Windows build scripts and ensure Windows x64 builds will work. - Issue #5581 - Documentation of Row Level Security Policies. - Bug fixes - Issue #3591 - Ensure that the query tool should display the proper error message while terminating the active session. - Issue #3669 - Ensure that proper error should be displayed for the deleted node. - Issue #3787 - Disabled the Stop process button after clicking it and added a message ‘Terminating the process…’ to notify the user. - Issue #4226 - Fixed an issue where select all checkbox only selects the first 50 tables. - Issue #5416 - Ensure that the query tool panel gets closed when clicking on the ‘Don’t Save’ button. - Issue #5465 - Fixed an issue where the Edge browser version is showing wrong and warning message gets displayed. - Issue #5492 - Fixed an issue where the search object is unable to locate inherited tables and constraint filters are not working. - Issue #5507 - Fixed connection and version number detection issue when the database server is upgraded. - Issue #5521 - Fixed an issue when dumping servers from a desktop pgAdmin app by providing an option ‘–sqlite-path’. - Issue #5539 - Fixed typo in exception keyword. - Issue #5584 - Fixed an issue where two identical tables showing different by schema diff tool. - Issue #5592 - Ensure that pgadmin should be able to connect to the server which has password more than 1000 characters. ------------------------------------------------------------------- Mon Jun 15 08:10:53 UTC 2020 - Michal Vyskocil - Update to 4.22 - New features * Added connected pgAdmin user and connection name in the log file. * Show the startup log as well as the server log in the runtime's log viewer. - Bugfixes * Gracefully informed the user that the database is already connected when they click on "Connect Database...". * Fixed an issue where clicking on the cross button of the alert box on the login page is not working. * Fixed the SQL help issue for EDB Postgres Advanced Server. * Ensure that maintenance job should be worked properly for indexes under a materialized view. * Ensure that file browse "home" button should point to $HOME rather than /. * Ensure that 'With OID' option should be disabled while taking backup of database server version 12 and above. * Fixed invalid literal issue when removing the connection limit for the existing role. * Fixed internal server error when clicking on Triggers -> 'Enable All' for partitions. * Fixed generated SQL issue for auto vacuum options. * Ensure that the dependencies tab shows correct information for Synonyms. * Fixed an issue where the newly added table is not alphabetically added to the tree. * Fixed list sorting issue in the schema diff tool. * Fixed an issue while comparing the two identical schemas using the schema diff tool. * Fixed an issue when renaming the column not added in the proper order. * Correct ipv4 "all interfaces" address in the container docs, per Frank Limpert. * Fixed an issue where select2 hover is inconsistent for the SSL field in create server dialog. * Fixed post-login redirect location when running in server mode under a non-default root. * Fixed an issue where the background job creation fails if there is only a version-specific python binary available in PATH. * Fixed data truncation issue when updating the data of type character with length. * Fixed an issue where if LDAP_SEARCH_BASE_DN is not set then, the value for LDAP_BASE_DN will be considered. * Fixed an issue where clicking on Select All button, not selecting all the options in pgAgent job scheduler. * Clarify and correct the docs on enabling the pl/debugger plugin on the server. * Fixed Unicode decode error 'utf-8' codec can't decode byte. - Packaging: * refresh fix-python-lib.patch * add keyring e8697e2eef76c02d3a6332778881b2a8210976f2 enabling GPG source tarballs verification ------------------------------------------------------------------- Thu May 14 16:25:22 UTC 2020 - Antonio Larrosa - Decrease requirements to build in SLE/Leap: * Werkzeug from 0.15.0 to 0.14.1 * passlib from 1.7.2 to 1.7.1 * psycopg from 2.8 to 2.7.4 * python-dateutil from 2.8.0 to 2.7.3 * simplejson from 3.16.0 to 3.13.2 * pytz from 2018.9 to 2018.3 pgadmin has this tendency to just follow the latest versions instead of properly specify required versions. ------------------------------------------------------------------- Wed May 13 09:42:09 UTC 2020 - Antonio Larrosa - Update to 4.21 - New features * Added search object functionality. * Added LDAP authentication support. * Added support for parameter toast_tuple_target and parallel_workers of the table. * Added support of Packages, Sequences and Synonyms to the Schema Diff. * Added an option to prevent a browser tab being opened at startup. - Bug fixes * Ensure that the start and end date should be deleted when clear the selection for pgAgent Job. * Fixed calendar opening issue on the exception tab inside the schedules tab of pgAgent. * Fixed an issue where the autovacuum_enabled parameter is added automatically in the RE-SQL when the table has been created using the WITH clause. * Fixed generated SQL when any token in FTS Configuration or any option in FTS Dictionary is changed. * Fixed tab key navigation issue for parameters in table dialog. * Ensure that switch cell is in sync with switch control for accessibility. * Fixed compilation warnings while building pgAdmin. - Update to 4.20 - New features * Added support of Collation, FTS Configuration, FTS Dictionary, FTS Parser and FTS Template to the Schema Diff. * Added support of Domain, Domain Constraints and Types to the Schema Diff. - Housekeeping * Enhance the color of switch control for both light and dark theme. * Added and fixed gettext usage for better translation coverage. - Bug fixes * Fix an issue where the user can not change the value of DateTime picker control using keyboard. * Fixed some accessibility issues in the dialogs. * Fixed chrome driver download utility issue for Ubuntu. * Change some colors and opacity to comply with WCAG color contrast standards. * Fix an accessibility issue to maximize the panel for all alertify dialog. * Improve logic to get the DDL statements as a part of the comparison. * Fixed tab key navigation issue for Grant Wizard. * Fixed Unicode character issue causing error on Python2 environment. * Fixed focus color issue for Alertify dialog buttons. ------------------------------------------------------------------- Tue Mar 24 17:07:55 UTC 2020 - Antonio Larrosa - Update dependencies versions and replace python-Flask-Security with python-Flask-Security-Too (fixes boo#1166991) ------------------------------------------------------------------- Mon Mar 16 10:34:00 UTC 2020 - Antonio Larrosa - Update to 4.19 (boo#1166681) - New features * Added accessibility support in AlertifyJS. * Added Czech language support. * Added Python 3.8 support. - Housekeeping * Improve code coverage and API test cases for the Event Trigger module. * Improvements in the UI for both default and dark themes. * Enhance logging by tracking stdout and stderr of subprocess when log level set to DEBUG. * Added option to override the class name of a label tag for select2 control. - Bug fixes * Changed the color of selected and hovered item for Select2 dropdown. * Improve the style of the highlighted code after query execution for Dark mode. * Ensure that AlertifyJS should not be visible as a title for alert dialog. * Changed background pattern for geometry viewer to use #fff for all themes. * Fix an issue where debugger not showing all arguments anymore after hitting SQL error while debugging. * Set proper focus on tab navigation for file manager dialog. * Fix an issue where command and statements were parsed incorrectly for Rules. * Ensure that all the transactions should be canceled before closing the connections when a server is disconnected using pgAdmin. * Fixed Firefox monospaced issue by updating the font to the latest version. * Update Flask-SQLAlchemy and SQLAlchemy package which is not working on Windows with Python 3.8. * Fix syntax error when changing the event type for the existing rule. - Update to 4.18 - New features * Added support for a multi-level partitioned table. * Added a Schema Diff tool to compare two schemas and generate a diff script. * Allow screen-reader to read label & description of non-textable elements. * Allow screen-reader to identify the alert errors. * Added labels and titles after parsing and validating all the pgAdmin4 web pages for accessibility. * Set input controls as read-only instead of disabled will allow tab navigation in the properties tab and also allow screen readers to read it. - Housekeeping * Improve code coverage and API test cases for the CAST module. * Improve code coverage and API test cases for the LANGUAGE module. * Improve the test framework to run for multiple classes defined in a single file. * Updated wcDocker package which includes aria-label accessibility improvements. * Replace node-sass with sass for SCSS compilation. - Bug fixes * Ensure that path file name should not disappear when changing ext from the dropdown in file explorer dialog. * Fixed an issue while editing char[] or character varying[] column from View/Edit data throwing an error. * Fixed an issue where Grant wizard unable to handle multiple objects when the query string parameter exceeds its limit. * Added tab navigation on close buttons for all the panels and create/properties dialog. * Fix column resizable issue in the file explorer dialog. * Logout the pgAdmin session when no user activity of mouse move, click or keypress. * Fix an issue where setting STORAGE_DIR to empty should show all the volumes on Windows in server mode. * Updated the incorrect icon used for the cast node on refresh. * Fix an issue where refreshing a package results in the change in the object completely. * Fix an issue where select, insert and update scripts on tables throwing an error. * Ensure Postfix starts in the container, now it runs as non-root by default. * Fixed an issue where Save Password control disappears after clicking on it while creating a server. - Update to 4.17 - New features * Allow screen-reader to read relationship attributes in nested elements. * Ensure all binaries are securely signed and linked with the hardened runtime in the macOS bundle - Housekeeping * Refactored SQL of Table’s and it’s child nodes. * Refactored SQL of Views and Materialized Views. * Refactored SQL of Functions and Procedures. * Added support for on-demand loading of items in Select2. * Added code coverage tool for pgAdmin. - Bug fixes * Fix syntax highlighting in code mirror for backslash and escape constant. * Fix an issue where clicking on an empty textbox like fill factor or comments, considers it as change and enabled the save button. * Added support to view multilevel partitioned tables. * Ensure that constraints, indexes, rules, triggers, and compound triggers should be created on partitions. * Added more information to the ‘Database connected/disconnected’ message. * Ensure that the user should be able to select/modify tablespace for the partitioned table on v12 and above. * Rename some internal environment variables that could conflict with Kubernetes. * Fix vulnerability issues reported by ‘yarn audit’. Replace the deprecated uglifyjs-webpack-plugin with a terser-webpack-plugin. * Ensure that the error message should not be displayed if Tablespace is not selected while creating the index. * Fix an issue where operator, access method and operator class is not visible for exclusion constraints. * Add a note to the documentation about the use of non-privileged ports on filesystems that don’t support extended attributes when running the container. * Added tab navigation for tabs under explain panel in query tool. * Fix an issue where the table is not created with autovacuum_enabled and toast.autovacuum_enabled for PG/EPAS 12. - Update to 4.16 - New features * Warn the user on changing the definition of Materialized View about the loss of data and its dependent objects. * Allow drag and drop functionality for all the nodes under the database node, excluding collection nodes. * Use a ‘play’ icon for the Execute Query button in the Query Tool for greater consistency with other applications. * Added aria-label to provide an invisible label where a visible label cannot be used. * Added role=”status” attribute to all the status messages for accessibility. * Run pgAdmin in the container as a non-root user (pgadmin, UID: 5050) * Allow Gunicorn logs in the container to be directed to a file specified through GUNICORN_ACCESS_LOGFILE. * Changed the open query tool and data filter icons. - Housekeeping * Add Reverse Engineered and Modified SQL tests for Materialized Views. * Refactored code of table and it’s child nodes. * Refactored code of columns node. - Bug fixes * Fix issue where the Reset button does not get enabled till all the mandatory fields are provided in the dialog. * Fix scrolling issue in ‘Users’ dialog. * Remove the sorting of table headers with no labels. * Updated documentation for default privileges to clarify more on the grantor. * Fix query tool launch error if user name contains HTML characters. It’s a regression. * Fix network disconnect issue while establishing the connection via SSH Tunnel and it impossible to expand the Servers node. * Fix an issue where the wrong type is displayed when changing the datatype from timestamp with time zone to timestamp without time zone. * Ensure that the superuser should be able to create database, as the superuser overrides all the access restrictions. * Fix server connection drops out issue in query tool. * Updated the json file name from ‘servers.json’ to ‘pgadmin4/servers.json’ in the container deployment section of the documentation. * Ensure that the superuser should be able to create role, as the superuser overrides all the access restrictions. * Fix reverse engineering SQL issue for partitions when specifying digits as comments. * Enhance the logic to change the label from ‘Delete/Drop’ to ‘Remove’ for the server and server group node. * Shown some text on process watcher till the initial logs are loaded. * Fix VPN network disconnect issue where pgAdmin4 hangs on expanding the Servers node. * Fix main window tab navigation accessibility issue. * Ensure that the Servers collection node should expand independently of server connections. * Fix the help button link on the User Management dialog. * Fix accessibility issues. * Fix XSS issue in explain and explain analyze for table and type which contain HTML. * Fix an issue of retrieving properties for Compound Triggers. It’s a regression. * Fix an issue where pgAdmin4 unable to retrieve table node if the trigger is already disabled and the user clicks on Enable All. * Fix reverse engineering SQL issue for triggers when passed a single argument to trigger function. * Fix an issue where length and precision are not removed from table/column dialog. * Fix an issue where the Interval data type is not displayed in the properties dialog of table/column. * Fix ‘Could not find the object on the server.’ error while refreshing the check constraint. * Fix issue where the user can not switch the UI language. It’s a regression. * Fix reverse engineering SQL issue where when clause is not visible for PG/EPAS 12. * Fix pgAdmin4 failed to start issue after upgrading to version 4.15. * Added statistics and storage information in reverse engineering SQL of table/column. * Fix an issue where the inherited table name with quotes did not escape correctly. * Fix an issue where context menu is open along with submenu and the focus is not on context menu or submenu. - Update to 4.15 - New features * Added encrypted password in reverse engineered SQL for roles. * Added Dark(Beta) UI Theme option. * Support Enable Always and Enable Replica on triggers. * Add an option to request confirmation before cancelling/resetting changes on a Properties dialog. * Added support for custom theme creation and selection. - Bug fixes * Ensure create new object dialog should be opened when alt+shift+n key is pressed on the collection node. * Fixed issue where Drop and Disconnect connection menu points are too close to each other. * Ensure context menus never get hidden below the menu bar. * Rename the context menu from ‘Drop Server’ to ‘Remove Server’. * Ensure the correct “running at” agent is shown when a pgAgent job is executing. * Fix an issue in the Query Tool where shortcut keys could be ignored following a query error. * Fix the toggle case shortcut key combination. * Fix an issue where a black arrow-kind image is displaying at the background of browser tree images. * Ensure comments are shown in reverse engineered SQL for table partitions. * Handle NULL values appropriately when sorting backgrid tables. * Give appropriate error messages when the user tries to use an blank master password. * Remove arbitrary (and incorrect) requirement that composite types must have at least two members. * Don’t quote bigints when copying them from the Query Tool results grid. * Ensure compression level is passed to pg_dump when backing up in directory format. * Ensure the number of jobs can be specified when backing up in directory format. * Ensure Javascript errors during Query Tool execution are reported as such and not as Ajax errors. * Suppress Enter key presses in Alertify dialogues when the come from Select2 controls to allow item selection with Enter. * Ensure that units are respected when sorting by file size in the File dialog. * Ensure all messages are retained in the Query Tool from long running queries. * Updated documentation for the delete row button that only strikeout the row instead of deleting it. * Updated documentation for the query tool toolbar buttons. * Fixed an issue where psql of v12 throwing “symbol not found” error while running Maintenance and Import/Export. * Fixed potential error in the properties dialog for the Code tab. * Fixed an issue where Datetimepicker control opens when clicking on the label. * Fixed potential issue in reset function for nested objects. * Fixed an issue where escape key not working to close the open/save file dialog. * Fixed an issue where keyboard shortcut for context menu is not working when using Firefox on CentOS7. * Fixed docker container exit issue occurs due to change in Gunicorn’s latest version. - Rebase patches: * use-os-makedirs.patch - Add patch to fix command to link to the python library * fix-python-lib.patch ------------------------------------------------------------------- Wed Oct 23 20:49:56 UTC 2019 - Marcus Rueckert - refresh use-os-makedirs.patch to apply cleanly again ------------------------------------------------------------------- Wed Oct 23 20:40:47 UTC 2019 - Marcus Rueckert - add back defattr to fix sle12 build ------------------------------------------------------------------- Mon Oct 21 15:38:51 UTC 2019 - ecsos@opensuse.org - Update to 4.14 - New features * Added Copy with headers functionality when copy data from Query Tool/View Data. * Implemeted the Query Plan Analyser. * Include PostgreSQL 12 binaries in the container. - Housekeeping * Add Reverse Engineered and Modified SQL tests for Synonyms. * Add Reverse Engineered and Modified SQL tests for Unique Constraints. - Optimize Webpack to improve overall performance. - Bug fixes * Ensure backup a partition table should not backup the whole database. * Ensure that ‘ENTER’ key in the data filter should not run the query. * Fix issue where backup fails for schema name that needs quoting. * Highlighted the color of closing or opening parenthesis when user select them in CodeMirror. * Fix issue where export job fails when deselecting all the columns. * Fix an error where ‘false’ string is displayed when we add a new parameter in the Parameters tab, also clear the old value when the user changes the parameter name. * Ensure that pgAdmin should work behind reverse proxy if the inbuilt server is used as it is. * Fix issue where pgAdmin does not load completely if loaded in an iframe. * Ensure the search path should not be quoted for Database. * Ensure pgAdmin should work behind reverse proxy on a non standard port. * Fix query tool open issue on Internet Explorer. * Fix issue where query history is not visible in the query history tab. * 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. * Ensure the MAC OSX app should be notarized for Catalina. - Changes from 4.13 - New features * Added Gather Merge, Named Tuple Store Scan and Table Function Scan icon for explain module. * Don’t wait for the database connection before rendering the Query Tool UI, for improved UX. * Allow configuration options to be set from the environment in the container distribution. * Ensure editable and read-only columns in Query Tool should be identified by icons and tooltips in the column header. * Add an Italian translation. * Refactor Dockerfile to avoid needing to run supporting scripts (i.e. ‘docker build .’ will work) and minimise layers. - Housekeeping * Add Reverse Engineered SQL tests for Schemas. * Add Reverse Engineered SQL tests for Views. * Add Reverse Engineered SQL tests for Rules. * Add Reverse Engineered and Modified SQL tests for Foreign Keys. * Add Reverse Engineered and Modified SQL tests for Foreign Servers. * Add Reverse Engineered and Modified SQL tests for Foreign Tables. * Add Reverse Engineered and Modified SQL tests for FTS Templates. * Add Reverse Engineered and Modified SQL tests for Indexes. * Add Reverse Engineered and Modified SQL tests for Primary Keys. * Add Reverse Engineered and Modified SQL tests for User Mappings. * Add Modified SQL tests for Resource Group. - Bug fixes * Added ProjectSet icon for explain module. * Ensure Boolean columns should be editable using keyboard keys. * Further code refactoring to stabilise the Feature Tests. * Fix an issue where oid column should not be pasted when copy/paste row is used on query output containing the oid column. * Fix display of validation error message in SlickGrid cells. * Fix issue where Validated switch option is inverted for the Foreign Key. * Fix a debugger error when using Python 2.7. * Fix error while importing data to a table using Import/Export dialog and providing “Not null columns” option. * Ensure View should be created with special characters. * Ensure Boolean columns should be editable in View/Edit data and Query Tool. * Fix an error that could be seen when click on any system column of a table. * Unescape HTML entities in database names in the Query Tool title bar. * Add editor options for plain text mode and to disable block folding to workaround rendering speed issues in CodeMirror with very large scripts. * Ensure port and username should not be mandatory when a service is provided. * Fix Truncate option deselect issue for compound triggers. * Fix length and precision enable/disable issue when changing the data type for Domain node. * Fix SQL tab issue for Views. It’s a regression of compound triggers. * Fix PGADMIN_SERVER_JSON_FILE environment variable support in the container. * Fix exception in query history for python 2.7. * Fix query tool launch error if user name contain html characters. * Increase cache control max age for static files to improve performance over longer run. * Fix SQL issue of length and precision when changing the data type of Column. * Fix modified SQL for Index when reset the value of Fill factor and Clustered?. * Fix reversed engineered SQL for btree Index when provided sort order and NULLs. * Ensure sequence with negative value should be created. * Fix issue where EXEC script doesn’t write the complete script for Procedures. * Fix query tool and view data issue with the Italian language. * Ensure Primary Key should be created with Index. * Fix query history exception for Python 3.6. ------------------------------------------------------------------- Sat Sep 7 09:14:37 UTC 2019 - ecsos@opensuse.org - Update to 4.12 - New features * Add support of Compound Triggers for EPAS 12+. * Add support for planner support functions in PostgreSQL 12+ functions. * Add support for generated columns in Postgres 12+. * Use the full tab space for CodeMirror instances on dialogues where appropriate. * Allow a banner to be displayed on the login and other related pages showing custom text. * Allow enhanced cookie protection to be disabled for compatibility with dynamically addressed hosting environments. * Add an optimisation to the internal code responsible for searching for treeview nodes. * Display the row count in the popup message when counting table rows, not just in the properties list. * Add support in query history to show internal queries generated by pgAdmin during save data operations. - Housekeeping * Add Reverse Engineered SQL tests for Columns. * Add Reverse Engineered SQL tests for Trigger Functions. * Add Reverse Engineered SQL tests for Exclusion Constraint. * Add a –modules option to the RE-SQL test suite to allow testing of specific object types. - Bug fixes * Fix issue where Deleting N number of rows makes first N number of rows disable. * Fix generation of reverse engineered SQL for tables with Greenplum 5.x. * Update wcDocker to allow the browser’s context menu to be used except in tab strips and panel headers. * Ensure type names are properly encoded in the results grid. * Fix generation of reverse engineered SQL for partition table, partitions were shown as a child of indexes. * Update wcDocker to prevent window state loading creating blank dialogues. * Fix accessibility issue for checkbox in IE11. * Ensure the Query Tool doesn’t throw an error when viewing the contents of a table with no columns. * Ensure columns can be created when they are IDENTITY fields with the CYCLE option enabled. * Ensure purely numeric comments can be saved on new columns. * Fix accessibility issue for Datetime cell in backgrid. * Ensure the query tool will work with older versions of psycopg2 than we officially support, albeit without updatable resultsets. * Ensure command tags are shown in the messages tab of the Query Tool. * Fix load on demand in View/Edit data mode. * Fix some errors thrown on the JS console when dragging text in the Query Tool. * Ensure triggers should be updated properly for EPAS server. * Fix the reverse engineered SQL for trigger functions with the WINDOW option selected. * Ensure enable trigger menu should be visible when trigger is disabled. * Ensure the comment on a Primary Key constraint can be edited under the Table node. * Fix console error when changing kind(SQL/BATCH) for pgAgent job step. * Fix double click issue to expand the contents of a cell if the resultset was not editable. * Fix generation of reverse engineered SQL for Rules. * Ensure compound triggers for event should be updated properly. * Ensure compound triggers should be displayed under Views. * Ensure Truncate option should be available for Compound Triggers. - Changes from 4.11 - New features * Add support for editing of resultsets in the Query Tool, if the data can be identified as updatable. * Set the mouse cursor appropriately based on the layout lock state. * Add EXPLAIN options for SETTINGS and SUMMARY. - Housekeeping * Add Reverse Engineered SQL tests for Roles and Resource Groups. * Add Reverse Engineered SQL tests for FDWs. * Add Reverse Engineered SQL tests for Languages. * Add Reverse Engineered SQL tests for Extensions. * Add Reverse Engineered SQL tests for FTS Configurations. * Add Reverse Engineered SQL tests for Packages. * Add Reverse Engineered SQL tests for FTS Dictionaries. * Add Reverse Engineered SQL tests for Domains. * Add Reverse Engineered SQL tests for Collations. * Add Reverse Engineered SQL tests for Types. * Add Reverse Engineered SQL tests for Sequences. * Add Reverse Engineered SQL tests for FTS Parsers. * Add Reverse Engineered SQL tests for Constraints. - Bug fixes * Allow keyboard navigation of all controls on subnode grids. * Fix dropping of pgAgent schedules through the Job properties. * Prevent flickering of large tooltips on the Graphical EXPLAIN canvas. * Fix an error that could be seen when editing column privileges. * Ensure parameter values are quoted when needed when editing roles. * EXPLAIN options should be Query Tool instance-specific. * Fix an error while retrieving json data from the table. * Fix ‘malformed array literal’ error when updating a pgAgent job. * Ensure drag/drop from the treeview works as expected on Firefox. * Fix table icon issue when updating any existing field. * Ensure browser should not be started by Selenium when feature tests are excluded from a test run. * Use ROLE consistently when generating RE-SQL for roles, not USER. * Fix an error seen when updating a connection string in a pgAgent job step. * Fix reverse engineered sql for Foreign Data Wrapper created on EPAS server in redwood mode. * Fix some minor UI issues on IE11. * Fix sequence reverse engineered SQL generation with quoted names on PG/EPAS 10+. * Fix an issue where Explain and Explain Analyze are not working, it’s regression of #1760. * Fix an issue where Filter toolbar button is not working in view/edit data, it’s regression of keyboard navigation. - Changes from 4.10 - New features * Allow some objects to be dragged/dropped into the Query Tool to insert their signature into the query text. * Allow the path to /pgadmin4/servers.json to be overridden in the container distribution. - Bug fixes * Ensure the browser close confirmation is only shown when closing a Query Tool which is running in a separate browser tab. * Prevent an error that may occur when editing data with an integer primary key. * Fix a quoting issue that caused a blank UI to be displayed when running in French. * Ensure the version comparision should be correct for windows installer. - Changes from 4.9 - New features * Visually distinguish simple tables from tables that are inherited and from which other tables are inherited. - Housekeeping * Add a framework for testing reversed engineered SQL and CRUD API endpoints. - Bug fixes * Fix issue where the dependencies tab for inherited tables/foreign keys shows partial text. * Allow editing of data where a primary key column includes a % sign in the value. * Fix issue where reverse engineered SQL was failing for foreign tables, if it had “=” in the options. * Fix keyboard navigation in “inner” tabsets such as the Query Tool and Debugger. * Ensure the correct label is used in panel headers when viewing filtered rows. * Fix issue where new column should be created with Default value. * Initial support for PostgreSQL 12. * Initial support for PostgreSQL 12. * Initial support for PostgreSQL 12. * Prevent the geometry viewer grabbing key presses when not in focus under Firefox, IE and Edge. * Prevent the “Please login to access this page” message displaying multiple times. * Ensure that the Return key can be used to submit the Master Password dialogue. * Ensure that browser auto-fill doesn’t cause Help pages to be opened unexpectedly. * Fix issue where SSH tunnel connection using password is failing, it’s regression of Master Password. * Fix an initialisation error when two functions with parameters are debugged in parallel. * Fix issue where property dialog of column should open properly for EPAS v12. * Capitalize the word ‘export’ used in Import/Export module. * Ensure strings are properly encoded in the Query History. * Ensure we include the CSRF token when uploading files. * Fix connection restoration issue when pgAdmin server is restarted and the page is refreshed. * Ensure the debugger control buttons are only enabled once initialisation is complete. * Remove additional “SETOF” included when generating CREATE scripts for trigger functions. * Fix help links for backup globals and backup server. * Fix an XSS issue seen in View/Edit data mode if a column name includes HTML. * Ensure Python escaping matched JS escaping and fix a minor XSS issue in the Query Tool that required superuser access to trigger. * Ensure that both columns and partitions can be edited at the same time in the table dialog. * Fix an XSS issue when username contains XSS vulnerable text. ------------------------------------------------------------------- Tue Jun 4 14:29:52 UTC 2019 - ecsos@opensuse.org - Update to pgadmin4 4.8 - New features * Feature #2653 - Allow the UI layout to be fully locked or to prevent docking changes. - Bug fixes * 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. * Fix the issue of accessing the SQL for Views and Materialized Views. Regression of pluralisation of folder names. ------------------------------------------------------------------- Sun Jun 2 08:26:47 UTC 2019 - ecsos@opensuse.org - Update to pgadmin4 4.7 - Bug fixes * In server mode, update all the saved server credentials when user password is changed. * Fix the responsive layout of the main menu bar. * Fix syntax error when adding more than one column to the existing table. * Fix file browser path issue which occurs when client is on Windows and server is on Mac/Linux. * Added Master Password to increase the security of saved passwords. * Fix accessibility issue for menu navigation. * Update the UI logo. * Fixed CSRF security vulnerability issue, per Alvin Lindstam * Properly assign dropdownParent in Select2 controls. * Ensure popper.js is installed when needed. * Fixed Tab key navigation for Maintenance dialog. * Fix Tab key issue for Toggle switch controls and button on the dialog footer in Safari browser. * Ensure that element should get highlighted when they get focus on using Tab key. * Fixed console error when subnode control is used in panels. * Stop using application/x-javascript as a mime type and use the RFC-compliant application/javascript instead. * Fixed error on displaying table properties of a table partitioned by list having a default partition. * Fix handling of JSON in the Query Tool with NULL elements. * Fix navigation of switch cells in grids. * Clarify wording for the NO INHERIT option on constraints, per Michel Feinstein. * Relax the permission check on the directory containing the config database, as it may fail in some environments such as OpenShift. * Prevent Backgrid Password cells from losing focus if the browser opens an autocomplete list. * Fix syntax error when creating a table with a serial column. ------------------------------------------------------------------- Tue May 21 07:51:34 UTC 2019 - ecsos@opensuse.org - Update to pgadmin4 4.6 - Features * Feature #4165 - Depend on psycopg2-binary in the Python wheel, rather than psycopg2. - Bug fixes * Ensure that on clicking Delete button should not delete rows immediately from the database server, it should be deleted when Save button will be clicked. * Ensure that newly added row in backgrid should be visible. * Ensure that JSON strings as comments should be added properly for all the objects. * Fix an issue where Deleting N number of rows makes first N number of rows disable. * Added support for Default Partition. * Fix an issue where ‘GRANT UPDATE’ sql should be displayed for default sequence privileges. * Ensure that confirmation dialog should be popped up before reload of query tool or debugger if it is opened in a new browser tab. * Ensure that record should be add/edited for root partition table with primary keys. * Fixed alignment issue of columns in definition section of Index node. * Fixed ‘Location cannot be empty’ error when open Tablespace properties. * Fix an issue where the dropdown becomes misaligned/displaced. * Ensure the treeview shows all sequences except those used to implement IDENTITY columns (which can be edited as part of the column). Show all if Show System Objects is enabled. * Fixed ‘Increment value cannot be empty’ error for existing tables. * Ensure that parameters of procedures for EPAS server 10 and below should be set/reset properly. * Prevent duplicate columns being included in reverse engineered SQL for tables. * Ensure sanity of the permissions on the storage and session directories and the config database. ------------------------------------------------------------------- Mon Apr 15 17:43:50 UTC 2019 - ecsos@opensuse.org - Update to pgadmin4 4.5 - Bug fixes * Fixed ‘Change Password’ issue for SCRAM authentication. * Ensure that two consecutive SELECT statements should work properly. * Relabel the Save button on the datagrid text editor to avoid confusion with the actual Save button that updates the database. * Added recommended ESLinter checks. * Ensure that pgAdmin4 should work properly with psycopg2 v2.8 - Changes from pgadmin4 4.4 Warning: This release includes a bug fix (Bug #3887) which will rename the per-user storage directories for existing users when running in server mode. Previously, saved SQL queries were stored under the STORAGE_DIR in a sub-directory named after the username part of the user’s email address. From this version onwards, the full email address is used, with the @ replaced with an underscore. For example, in v.4.3 with STORAGE_DIR set to /var/lib/pgadmin4 user files may be stored in: /var/lib/pgadmin4/storage/username/ With the fix, that directory will be renamed (or created for new users) as: /var/lib/pgadmin4/storage/username_example.com/ - Features * Add support for reverse proxied setups with Gunicorn, and document Gunicorn, uWSGI & NGINX configurations. * Make the Query Tool history persistent across sessions. * Remove the large and unnecessary dependency on React and 87 other related libraries. * Add support for IDENTITY columns. * Add an ePub doc build target. - Bug fixes * Fix naming inconsistency for the column and FTS parser modules. * Include inherited column comments and defaults in reverse engineered table SQL. * Improve a couple of German translations. * Use the user’s full email address (not just the username part) as the basis for the storage directory name. * Update wcDocker to fix the issue where the Scratch Pad grows in size if the results panel is resized. * Avoid ‘bogus varno’ message from Postgres when viewing the SQL for a table with triggers. * Update all Python and JavaScript dependencies. * Include comment SQL for inherited columns in reverse engineered table SQL. * Make the WHEN field a CodeMirror control on the Event Trigger dialogue. * Fix the online help button on the resource group dialogue. * Enable the online help button on the index dialogue. * Handle resultsets with zero columns correctly in the Query Tool. * Include inherited columns in SELECT scripts. * Fix the latexpdf doc build. * Fix handling of numeric arrays in View/Edit Data. * Enlarge the grab handles for resizing dialogs etc. * Append the file suffix to filenames when needed in the File Create dialogue. * Ensure that Firefox prompts for a filename/location when downloading query results as a CSV file. * Change the CodeMirror active line background colour to $color-danger-lighter so it doesn’t conflict with the selection colour. * Fix the RE-SQL syntax for roles with a VALID UNTIL clause. * Prevent an empty error message being shown when “downloading” a CREATE script using the CSV download. * Overhaul the layout saving code so it includes the Query Tool and Debugger, and stores the layout when change events are detected rather than (unreliably) on exit. * Display errors during CSV download from the Query Tool in the UI rather than putting them in the CSV file. * Improve the German translation for Backup Server. * Ensure the toolbar buttons are properly reset following a CSV download in the Query Tool. * Fix SQL help for EPAS 10+, and refactor the URL generation code into a testable function. * Ensure sequences can be created with increment, start, minimum and maximum options set. * Fix an issue where JSON data would not be rendered in the Query Tool. * Ensure View/Materialized View node should be visible after updating any property. * Fix custom autovacuum configuration for Materialized Views. ------------------------------------------------------------------- Thu Mar 7 14:22:56 UTC 2019 - ecsos@opensuse.org - 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. ------------------------------------------------------------------- Tue Mar 5 11:26:22 UTC 2019 - ecsos@opensuse.org - Update to pgadmin4 4.2 - Bug fixes * Replace Bootstrap switch with Bootstrap4 toggle to improve the performance. * Replace the PyCrypto module with the cryptography module. * Fixed SQL for foreign table options. * Fixed execution time to show Hours part for long running queries in Query Tool. * Messages tab of query tool should be clear on subsequent execution of table/view using View/Edit Data. * Clear drop-down menu should be disabled for View/Edit Data. * Fixed Statistics panel hang issue for 1000+ tables. * Proper error should be thrown when server group is created with existing name. * Ensure long string should be wrap in alertify dialogs. * Ensure that output of the query should be displayed even if Data Output window is detached from the Query Tool. * Inline edbspl trigger functions should not be visible in Grant Wizard. * Proper SQL should be generated when create function with return type as custom type argument. * Ensure that database restriction of server dialog should work with special characters. * Ensure that Backup/Restore button should work on single click. * Fixed SQL for when clause while creating Trigger. * Proper SQL should be generated when creating/changing column with custom type argument. * Ensure that file format combo box value should be retained when hidden files checkbox is toggled. * Proper SQL should be generated when create procedure with custom type arguments. * Ensure that browser should warn before close or refresh. * Fixed EXEC script for procedures. * Proper SQL should be generated when create domain of type interval with precision. * Drop-down should be closed when click on any other toolbar button. * Fixed keyboard navigation for dialog tabs. * Increase frames splitter mouse hover area to make it easier to resize. * Fixed alignment of tree arrow icons for Internet Explorer. * Ensure object names in external process dialogues are properly escaped. * Correct order of Save and Cancel button for json/jsonb editing. * Data should be updated properly for FTS Configurations, FTS Dictionaries, FTS Parsers and FTS Templates. * Fixed unable to drop multiple Rules and Foreign Tables from properties tab. * Fixed Query Tool Initialization Error. * Fixed keyboard navigation for Select2 and Privilege cell in Backgrid. * Correct schema should be displayed in Materialized View dialog. * Fixed debugger issue for procedure inside package for EPAS servers. * Fix alignment of help messages in properties panels. * Fix alignment of submenu for Internet Explorer. * Ensure that grant wizard should list down functions for EPAS server running with no-redwood-compat mode. * Dashboard graph optimization. * Remove Python 2.6 code that’s now obsolete. * Expose the bind address in the Docker container via PGADMIN_BIND_ADDRESS. * Exclude HTTPExceptions from the all_exception_handler as they should be returned as-is. - Rebase fix-python3-crypto-call.patch ------------------------------------------------------------------- Tue Jan 15 16:31:56 UTC 2019 - Antonio Larrosa - Update to pgadmin4 4.1 - Bug fixes * Fix SQL generated for tables with inherited columns. * Ensure the context menu works after a server is renamed. * Fix ordering of VACUUM options which changed in PG11. * Don’t show system catalogs in the schemas property list unless show system objects is enabled. * Fix help for the backup/restore dialogues. * Ensure that last row of table data should be visible and user will be able to add new row. * Make the browser more robust in the face of multibyte characters in SQL_ASCII databases. - Update to pgadmin4 4.0 - Features * Allow query plans to be downloaded as an SVG file. * New UI design. * Allow servers to be pre-loaded into container deployments. - Bug fixes * Increase the size of the resize handle of the edit grid text pop-out. * Fix handling of array types as inputs to the debugger. * Fix an issue that could cause the Query Tool to fail to render. * Display event trigger functions correctly on EPAS. * Further improvements to treeview restoration. * Run Postfix in the container build so passwords can be reset etc. * Add titles to the code areas of the Query Tool and Debugger to ensure that panels can be re-docked within them. * Fix a webpack issue that could cause the Query Tool to fail to render. * Ensure we display the relation name (and not the OID) in the locks table wherever possible. * Fix an encoding issue in the query tool. * Include the WHERE clause on EXCLUDE constraints in RE-SQL. * Fix an issue when user define Cast from smallint->text is created. * Hide Radio buttons that should not be shown on the maintenance dialogue. * Ensure that null values handled properly in CSV download. * Tweak the wording on the Grant Wizard. * Prevent attempts to bulk-drop schema objects. * Ensure the browser toolbar buttons work in languages other than English. * Allow horizontal sizing of the edit grid text pop-out. * Ensure auto complete should works when first identifier in the FROM clause needs quoting. * Ensure auto complete should works for columns from a schema-qualified table. * Ensure identifiers are properly displayed in the plan viewer. * Make the setup process more robust against aborted executions. * Fixed an issue while creating export job. - Make pgadmin4-web suggest the pgadmin4-doc package instead of requiring it. ------------------------------------------------------------------- Fri Nov 30 09:30:56 UTC 2018 - Antonio Larrosa - Update to pgadmin4 3.6 - Features * Add support for dropping multiple objects at once from the collection Properties panel. * Add the ability to import and export server definitions from a config database - Bug fixes * Ensure previous notices are not removed from the Messages tab in the Query Tool if an error occurs during query execution. * Allow the selection order to be preserved in the Select2 control to fix column ordering in data Import/Export. * Allow use of 0 (integer) and empty strings as parameters in the debugger. * Properly report errors when debugging cannot be started. * Prevent the debugger controls being pressed again before previous processing is complete. * Fix toggle breakpoints buttons in the debugger. * Fix changes to the NOT NULL and default value options in the Table Dialogue. * Fix dropping of multiple functions/procedures at once. ------------------------------------------------------------------- Wed Nov 14 19:19:48 UTC 2018 - Jan Engelhardt - Compact description and trim first-person grammar. - Rename pgadmin4-docs to pgadmin4-doc to be in line with the naming of other packages in openSUSE. - Safeguard fdupes to not run over partition boundaries. ------------------------------------------------------------------- Wed Nov 7 17:31:38 UTC 2018 - Antonio Larrosa - Update to pgadmin4 3.5 - Features * Save the treeview state periodically, and restore it automatically when reconnecting. * Migrate from Bootstrap 3 to Bootstrap 4. - Bug fixes * Ensure that Utilities(Backup/Restore/Maintenence/Import-Export) should not be started if binary path is wrong and also added ‘Stop Process’ button to cancel the process. * Fix syntax error when creating new pgAgent schedules with a start date/time and exception. * Cleanup session files periodically. * Rename the ‘SQL Editor’ section of the Preferences to ‘Query Tool’ as it applies to the whole tool, not just the editor. * Fix CREATE Script functionality for EDB-Wrapped functions. * Fix connection garbage collector. * Purge connections from the cache on logout. * Ensure that utility existence check should work for schema and other child objects while taking Backup/Restore. * Fixed fatal error while launching the pgAdmin4 3.5. Update the version of the Flask to 0.12.4 for release. ------------------------------------------------------------------- Mon Oct 8 11:02:50 UTC 2018 - Antonio Larrosa - 3.4 - Update to pgadmin4 3.4 - Features * Move all CSS into SCSS files for consistency and ease of colour maintenance etc. * Add optional data point markers and mouse-over tooltips to display values on graphs. * Add shortcuts for View Data and the Query tool to the Browser header bar. - Bug fixes * Ensure the runtime can startup properly if there are wide characters in the logfile path on Windows. * Fix handling of backslashes in the edit grid. * Ensure queries are no longer executed when dashboards are closed. * Fix support for the CLOB datatype in EPAS. * Fix logic around validation and highlighting of Sort/Filter in the Query Tool. * Ensure auto-complete works for objects in schemas other than public and pg_catalog. * Ensure changes to Query Tool settings from the Preferences dialogue are applied before executing queries. * Swap the Schema and Schemas icons and Catalog and Catalogs icons that had been used the wrong way around. ------------------------------------------------------------------- Wed Oct 3 08:59:31 UTC 2018 - Antonio Larrosa - 3.3 - Update to pgadmin4 3.3 - Features * Add a geometry viewer that can render PostGIS data on a blank canvas or various map sources. * Added new backup/restore options for PostgreSQL 11. Added dump options for 'pg_dumpall'. * Add a Spanish translation. - Bug fixes * Stabilise feature tests for continuous running on CI systems. * Fixed debugger execution issues. * Ensure 'select all' and 'unselect all' working properly for pgAgent schedule. * Fix sort/filter dialog issue where it incorrectly requires ASC/DESC. * Ensure backup should work with '--data-only' and '--schema-only' for any format. * Fix keyboard shortcuts layout in the preferences panel. * Merge pgcli code with version 1.10.3, which is used for auto complete feature. * Ensure that refreshing a node also updates the Property list. * Ensure that refresh button on dashboard should refresh the table. * Handle connection errors properly in the query tool. * Make session implementation thread safe * Ensure external table node should be visible only for GPDB. * Fix auto scrolling issue in debugger on step in and step out. * Fix sort/filter dialog editing issue. * Ensure sort/filter dialog should display proper message after losing database connection. * Ensure sql for Role should be visible in SQL panel for GPDB. * When building the Windows installer, copy system Python packages before installing dependencies to ensure we don't end up with older versions than intended. * Correct the documentation of View/Edit data. ------------------------------------------------------------------- Tue Aug 21 09:08:55 UTC 2018 - Antonio Larrosa - 3.2 - Initial release of pgadmin4 3.2