openSUSE Recommended Update: Recommended update for pgadmin3 ______________________________________________________________________________ Announcement ID: openSUSE-RU-2017:1193-1 Rating: moderate References: #1036952 #986857 Affected Products: openSUSE Leap 42.2 openSUSE Leap 42.1 ______________________________________________________________________________ An update that has two recommended fixes can now be installed. Description: This update of pgadmin3 to 1.22.2 fixes the following issues: - Fix control grid row on hidpi screen. - Do not recommend but only suggest to install postgresql-server - Fix a segmentation fault (bsc#986857) The following upstream changes and bug fixes are included in version 1.22.2: - Include the Negator when reverse engineering SQL for operators - Prevent a crash in some situtions where the database connection is lost and needs to be reset. - Fix display of elapsed query time for queries running longer than 1 hour - Don't barf when connecting to Greenplum or Greenplum HAWQ - Fix selection of conversion functions in the CREATE CONVERSION dialogue. - Properly quote type names in the Type dialogue, and ensure range information is displayed for existing types - Fix selection of cast functions in the Cast dialogue - Resolved an issue related to check options selection in the view properties dialog with the check option. - Properly detect serial columns as such when identifiers have been truncated. - Fixes an issue related to the column inheritance information properly, when one (or, more) common columns are inherited from multiple tables. - Ensure the correct syntax used for moving the objects from one tablespace to another. - Ensure the correct line endings are used when copying from the SQL Pane - Toolbar icons, and menu items for Commit and Rollback actions. - Display the connection details for the current browser object in the status bar - Reset the position (x, y) for dialog(s), and frame(s) to 0 (if found negative), while saving its position and size. - Fixes an issue identifying the return type to TABLE in some cases, using pg_get_function_result(..) for the same instead of format_type(..) - Honour PGPASSFILE environment variable for saving - Fix a segfault occurs while detecting transaction section requirement, when autocommit has been disabled. - Format execution time in a more readable manner - Improve sorting in Data editor - Allow to format the selecte SQL using external tools in Query Editor - Allow to set auto-commit mode to on/off in the query editor - Do not try unlock the mutex, which was not owned by the thread, while creating the popup menu - Set the focus on browser tree windows on startup - Make the arrow key navigation consistent across all platform on the object browser tree - Show indexes for the materialized views in Query pane - Add support for searching materialized views 1.22.2 is the last upstream supported release of pgadmin3. Patch Instructions: To install this openSUSE Recommended Update use YaST online_update. Alternatively you can run the command listed for your product: - openSUSE Leap 42.2: zypper in -t patch openSUSE-2017-543=1 - openSUSE Leap 42.1: zypper in -t patch openSUSE-2017-543=1 To bring your system up-to-date, use "zypper patch". Package List: - openSUSE Leap 42.2 (x86_64): pgadmin3-1.22.2-3.3.1 pgadmin3-debuginfo-1.22.2-3.3.1 pgadmin3-debugsource-1.22.2-3.3.1 - openSUSE Leap 42.2 (noarch): pgadmin3-lang-1.22.2-3.3.1 - openSUSE Leap 42.1 (i586 x86_64): pgadmin3-1.22.2-3.1 pgadmin3-debuginfo-1.22.2-3.1 pgadmin3-debugsource-1.22.2-3.1 - openSUSE Leap 42.1 (noarch): pgadmin3-lang-1.22.2-3.1 References: https://bugzilla.suse.com/1036952 https://bugzilla.suse.com/986857