- 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.

• Files Changed
• Browse Source

- Update to 4.24

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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...".
    ....
- Packaging:
  * refresh fix-python-lib.patch
  * add keyring e8697e2eef76c02d3a6332778881b2a8210976f2 enabling
    GPG source tarballs verification

old: server:database:postgresql/pgadmin4
new: home:mvyskocil:branches:server:database:postgresql/pgadmin4 rev None
Index: fix-python-lib.patch
===================================================================
--- fix-python-lib.patch (revision 28)
+++ fix-python-lib.patch (revision 2)
@@ -5,32 +5,29 @@
 we have to add it ourselves. Use an environment variable (just as in the Windows case)
 to find out the library version to link to.
 
-Index: pgadmin4-4.19/runtime/pgAdmin4.pro
+Index: pgadmin4-4.22/runtime/pgAdmin4.pro
 ===================================================================
---- pgadmin4-4.19.orig/runtime/pgAdmin4.pro
-+++ pgadmin4-4.19/runtime/pgAdmin4.pro
-@@ -55,6 +55,7 @@ else {
-     # Find and configure Python
-     # Environment setting
-     PYTHON_CONFIG = $$(PYTHON_CONFIG)
-+    PYTHON_VERSION = $$(PYTHON_VERSION)
- 
-     # Python 2?
-     isEmpty(PYTHON_CONFIG) {
-@@ -71,11 +72,15 @@ else {
-         error(The python-config executable could not be found. Ensure Python is installed and in the system path.)
+--- pgadmin4-4.22/runtime/pgAdmin4.pro.orig	2020-06-15 09:57:31.503298807 +0200
++++ pgadmin4-4.22/runtime/pgAdmin4.pro	2020-06-15 10:02:06.335072806 +0200
+@@ -78,6 +78,12 @@
+     } else {
+         error(No suitable python-config could be found in $${PYTHON_DIR}/bin.)
      }
- 
++
++    PYTHON_VERSION = $$(PYTHON_VERSION)
 +    isEmpty(PYTHON_VERSION) {
 +        error(Please set the PYTHON_VERSION environment variable to the version of python to link to.)
 +    }
 +
-     message(Using $$PYTHON_CONFIG)
+     message(Python config: $$PYTHON_CONFIG)
  
-     QMAKE_CXXFLAGS += $$system($$PYTHON_CONFIG --includes)
+     PYTHON_EMBED = $$system($$PYTHON_CONFIG --help 2>&1 | grep -o \'\\-\\-embed\')
+@@ -88,7 +94,7 @@
      QMAKE_LFLAGS += $$system($$PYTHON_CONFIG --ldflags)
--    LIBS += $$system($$PYTHON_CONFIG --libs)
-+    LIBS += $$system($$PYTHON_CONFIG --libs) -lpython$$PYTHON_VERSION
+     message(LDFLAGS: $$QMAKE_LFLAGS)
+ 
+-    LIBS += $$system($$PYTHON_CONFIG --libs $$PYTHON_EMBED)
++    LIBS += $$system($$PYTHON_CONFIG --libs $$PYTHON_EMBED) -lpython$$PYTHON_VERSION
+     message(LIBS: $$LIBS)
+ }
  
-     contains( LIBS, -lpython2.* ) {
-        DEFINES += PYTHON2
Index: pgadmin4.changes
===================================================================
--- pgadmin4.changes (revision 28)
+++ pgadmin4.changes (revision 2)
@@ -1,4 +1,57 @@
 -------------------------------------------------------------------
+Mon Jun 15 08:10:53 UTC 2020 - Michal Vyskocil <mvyskocil@opensuse.org>
+
+- 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 <alarrosa@suse.com>
 
 - Decrease requirements to build in SLE/Leap:
Index: pgadmin4.spec
===================================================================
--- pgadmin4.spec (revision 28)
+++ pgadmin4.spec (revision 2)
@@ -18,13 +18,16 @@
 
 %global	pgadmin4instdir %{_libdir}/pgadmin4-%{version}
 Name:           pgadmin4
-Version:        4.21
+Version:        4.22
 Release:        0
 Summary:        Management tool for PostgreSQL
 License:        PostgreSQL
 Group:          Productivity/Databases/Tools
 URL:            http://www.pgadmin.org
 Source0:        https://download.postgresql.org/pub/pgadmin/%{name}/v%{version}/source/%{name}-%{version}.tar.gz
+Source10:       https://download.postgresql.org/pub/pgadmin/%{name}/v%{version}/source/%{name}-%{version}.tar.gz.asc
+# https://www.pgadmin.org/download/pgadmin-4-source-code/
+Source11:       %{name}.keyring
 Source1:        %{name}.conf
 Source2:        %{name}.service.in
 Source3:        %{name}.tmpfiles.d
@@ -142,6 +145,7 @@
 cd runtime
 export PYTHON_CONFIG=%{_bindir}/python3-config
 export PYTHON_VERSION=%{python3_version}
+export PGADMIN_PYTHON_DIR=%{_prefix}
 export CFLAGS=%{RPM_OPT_FLAGS}
 qmake-qt5 -o Makefile pgAdmin4.pro
 make %{?_smp_mflags} VERBOSE=1
Index: pgadmin4-4.22.tar.gz
===================================================================
Binary file pgadmin4-4.22.tar.gz (revision 2) added
Index: pgadmin4-4.22.tar.gz.asc
===================================================================
--- pgadmin4-4.22.tar.gz.asc (added)
+++ pgadmin4-4.22.tar.gz.asc (revision 2)
@@ -0,0 +1,16 @@
+-----BEGIN PGP SIGNATURE-----
+
+iQIcBAABAgAGBQJey8TRAAoJEIiBsqghCXbyv58P/2cfBzUq4py2IvV2X4Q9+NSN
+3iVZpBXap+xZoeKftG8H3b8GIZdhudLBW1TEGgCuH/CCKn3a7mVWPhPob/qSm+FM
+szngB+x92IA4JRG6N5KYnt+krDcSNgVF762TMPyZ9mSd1Wwoxiu+2zB6QB4p5H7y
+ufevNzCHUANs+NfpPP4e/EnJJHGZdhuqgcMclprFahwCw4V3ZZ9bCC1My/p9FvpH
+yOiUcxh6vUxNRaHmiV/3vQ8/FEvYJxzqzRdpFjEqhHBhIKw0CB3prLysW5J0e6yu
+EZmo0HeaGMLUgbxcbwBy+Ye+uh3wlYTLNiYu9ddJScInZuFbPAt659aHBZTgi5PH
+XAEEhF5aUpm8aoy7zPluKiRhg19DI7k1GN2hqGDQKvIrl6dGLMjELdHyggr/5Ow7
+gv2ZT9A5DebczG14+fDf6XgDswvLn+U7Hsp4BLql6k2eK7qLoC9ORCETOR0LMVWa
+ftIGCDdtCpmH8wLEdjt7yl/i6rHxwBl5rHky1Syrmdef/q1qT9qTc8XfPcfql9Qn
+n2pwFl1LeqKx4C2shZiuZ0QDpWg0KbQlgxpou6QUGXyi9Ks+SEjaJUiAnZkQ1udB
+MkNX3VahVwm+SSWVvhSKwPgjofLPdq/95wOSAdSYUuls4cXog9Uj8eksW9qxf6y/
+Zjss+fY0SCjpqhnlH+eM
+=88O2
+-----END PGP SIGNATURE-----
Index: pgadmin4.keyring
===================================================================
--- pgadmin4.keyring (added)
+++ pgadmin4.keyring (revision 2)
@@ -0,0 +1,52 @@
+-----BEGIN PGP PUBLIC KEY BLOCK-----
+
+mQINBFtyz58BEACgKbtY59R0mxs8rWJNAn1BWNXwhuTvELNCV6gZkMRGFP14tMop
+d9VcUx5UWiulT5wysji63xhkNljmE90jJdlxZwZ+XtnmLzIqp6i29EkAIUt1AoxM
+w2ipMhfuwE6WA6VYxQihu5z2IDOR1PdDUHF5cX/GZgBon/2A33rG5IKTcaNZzL0O
+c3rS5VzOzwnp1FHPlR7PY7BRDNe8q1MrQq14tlgMTaYziNg2t2YwjuhNV6G33qGE
+h390aUnO/eMWIPJzKoi4mE5mhEbh4L/7sFlcRUC6Vs1xa5Ab+L5y2xoDe2grraKD
+u+XpGJaDPLunlhDSTUsp0HsoLVU4ne/HNbCAm2b25tKFcFTUwDH4Ekge1/bQLCvx
+kB63MMLa/FgsJ0XAr8zKEQFrc89qJU4JuvadL4hAIqZ1ywFlwTOBaNfZHbW2Pt5f
+prktIL5d5jIHAdQrFPvLqhhjhM03de6O6dS5lDeP8dTdqzMcqBkwFMmjZMeRAcoJ
+vs0jJNc0fYwL3h2JSWQnIhsvcSe6gk8GFVRbCCy9UplK1K/5TWw+y3mtfWwUCUSW
+nBIuUTV+5iG21o3rdZgfEjXJtBAWW/hKoVwBTe5Ir9yIqaomG5ul0Sn2EgOravns
+AWe2nk4l9cno5CPhGunEtiOD8YQJHskk7/NMtnPegB5j4tprXGS/cK/5hQARAQAB
+tDxQYWNrYWdlIE1hbmFnZXIgKFBhY2thZ2UgU2lnbmluZyBLZXkpIDxwYWNrYWdl
+c0BwZ2FkbWluLm9yZz6JAk4EEwEKADgWIQToaX4u73bALTpjMneIgbKoIQl28gUC
+W3LPnwIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRCIgbKoIQl28ukfD/4y
+3gGysVSJU1964mpi/4NtSTruQ+fx8rN1vY/cctdQVr1ltuJsDRyPgGpXIh9zeK0/
+bkCreCcuGezm2WOUFR6Kf54zMWWbIrAPpbib7rYi8n50jz7SkCfSyJZgqO2bAPBU
+MP6Y09mdLaB4jib9Y6nDhFgm2V0rO64yX/bznVjBzNXFjCTgbPoABU0Guy4yHGUF
+HkQ7Hdg1QLhupMWlphlMJbeSxZJx0T6ApNvr2Qg+uFykSXbXjP2e/tXGb9NeHveT
+tw/hD2yMPzXJZ4uQbk8mJWDfD87fHY4ZUVqLJtKiS3omePJ5FWMPnLl0PLICkvmh
+mhoxyKFGjB+62/PpYwclZLR8iB7wn9tIA/q6BqP/BBhgmzpuh7ZOAU/zUZ5D+tHu
+Q9X0e29iFs4nxewmSM1uCq++l+gGMFRMn0FPH8nyQS/EcB/qXXRc0J3Ja7VVfH5B
+djmVvqTeJmwY+xGdLZAh/WZ9raWd/qbRGNIcYOyhHnvp719EQxYSiiJbIQcRLDbc
+IBiUG322ubSiR4+saYfx4ixrHvx8QYbtagien0kkXtoouhhIuLxq/EADRb979ZvQ
+1hnlUkSGHRN6mDNyLztRqy/iibZrSgX+iKR9lQYI5MnhchihgoN7jyFUiGTV/VSG
+6oH2KHiTgUQawli9OirnBB1oekf2+QZfZUvnM+b+SrkCDQRbcs+fARAArdB3G/Ld
+uGV7BnDpVZxJaHDDKNeyHcg77NY9oycazU0+o5MZYMBvqI0rbEb5ZUaxvOVqvxTS
+Oi7gWN1MfmJnWjZvqfAiYhAxPxqpeBj0jWe3wooqKUcshV4OtVTO9pVqJAE/aPRm
+klNP7DOVg3l7zAOUCJQIOvo0O/kdDDCx3h9BkzJxefCgBZhO0+9vh9cz7bx96nkJ
+TrfjwTCVTYY4jtjMFOzZVCClc+FZ9SZsQNZAlhCMWchUvNl1ynPQV4D6sJ5Nu5ag
+cXWcw1hZIvEgZw3b8E0/7NHIbcHpFjeLdkaHytMN90xe/jEkC8aVi6/IoK0ELwau
+iwXzKpvLUFhy9lQzkQ4OZCiKWb+KTccSBZrtVV/ltNTo9hlegDiYF+o2nTIkZR6b
+ZM+w/3Zp6rAsnw0Qpi3MAd8tv23oW1dfoltm1YlGhaECLf115tiaNWLbJMWeyw54
+A4p/PKVOoyHdTXcYz9qylI5v3ch+YzJ9Xp4L+9cNekx/hla+NoaPsjsDk2KPKigw
+L0ICPCPHvjJZDC0S6YJhYhAplgqLyTkNiR4s6hTpq/nkm3oO6OVaVgPnG9LAnWxl
+F/Cr+ovMz/2soVZ1oNaFOUNB04B/YENK85EfkXtjucUirjWJ6lTib+Hkc7dTTxYG
+WTsPjxTCZbxM+LoxsAPzrHSTS0CvxxCu+RsAEQEAAYkCNgQYAQoAIBYhBOhpfi7v
+dsAtOmMyd4iBsqghCXbyBQJbcs+fAhsMAAoJEIiBsqghCXbyj1IP/39mCRh1/RWj
+ZAqaBJOdUFubL6aiEztuCIOuZhFVcsdRjzkfQUJwiaF2a54RL9nfwaYoxRP3Ef3x
+7/W5qnON+MGnmT8g8n5Vk5+vjEGDCSX7MynSRWmmOKj3mgnKIexgtqsOCOTCDXzV
+U3IpzlOdl2c7ehfhDZuIfLur20vuebCl40UcTTB2wZTTK9MspbpHRq7Nz0xhGLVx
+DwYZrOD5c+bh48JL3/q7YvOM9qqnV+stGFsbUQctHBnqNeTWAPJBySyEHlGG5Fdt
+Dwu1KKI9vQ6SLEcQ7+xdqmdyiLHvKIiUyLm3TPju8zYczKPl0lGNhzOmlgywo1eU
+riVSVLD8QN2hCoo5/z45hpK+AyoYmp7dJyAf6c8inpTUCRzuX4Ahble9kfRiEe8g
+URtgFOTsIB0HcuRdP+P+i7TVVmTCstpRGLslvH5tK2wuxuUG89CoWGVsadxdtKzu
+uu/VYjLjUE8EHxyPWpHbRahRBT7qB8k91QDMc3lAHDF8AWj3B8NRDpV9ZIm2jOXW
+w1TnyhK+iTY+FTdNAnrjPvqxyUk3jP4HMTvgVqc2jRRfTDKwgS++MImPlie66IEX
++Q7ux9ntPsP1zqbiMd6xkjvVYVa1XKEx4piT7lh+4+esMmy0v0woehyPLKDI2C88
+Vm6r0sldG+MX23M2/+32OBWofNHhOffz
+=c4aa
+-----END PGP PUBLIC KEY BLOCK-----
Index: pgadmin4-4.21.tar.gz
===================================================================
Binary file pgadmin4-4.21.tar.gz (revision 28) deleted

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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.

- 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.

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- Update dependencies versions and replace python-Flask-Security
  with python-Flask-Security-Too (fixes boo#1166991)

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

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

• Files Changed
• Browse Source

- add back defattr to fix sle12 build

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

Update to 4.14

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

Update to 4.12

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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.
- 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.
- 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.
- 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.
- 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.
- 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
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Initial release of pgadmin4 3.2

• Files Changed
• Browse Source

- 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.

• Files Changed
• Browse Source

- 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.

• Files Changed
• Browse Source