File pgadmin4.changes of Package pgadmin4

Overview Repositories Revisions Requests Users Attributes Meta

File pgadmin4.changes of Package pgadmin4 (Revision 39426de8d5a7020c503e1ad927132300)

Currently displaying revision 39426de8d5a7020c503e1ad927132300 , Show latest

-------------------------------------------------------------------
Mon Mar 16 10:34:00 UTC 2020 - Antonio Larrosa <alarrosa@suse.com>

- 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 <mrueckert@suse.de>

- refresh use-os-makedirs.patch to apply cleanly again

-------------------------------------------------------------------
Wed Oct 23 20:40:47 UTC 2019 - Marcus Rueckert <mrueckert@suse.de>

- 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 <alarrosa@suse.com>

- 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 <alarrosa@suse.com>

- 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 <jengelh@inai.de>

- 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 <alarrosa@suse.com>

- 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 <alarrosa@suse.com> - 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 <alarrosa@suse.com> - 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 <alarrosa@suse.com> - 3.2

- Initial release of pgadmin4 3.2

Places

File pgadmin4.changes of Package pgadmin4 (Revision 39426de8d5a7020c503e1ad927132300)

Places