Hello community, here is the log from the commit of package pgadmin3 for openSUSE:Factory checked in at 2018-03-31 15:37:14 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/pgadmin3 (Old) and /work/SRC/openSUSE:Factory/.pgadmin3.new (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Package is "pgadmin3" Sat Mar 31 15:37:14 2018 rev:3 rq:592632 version:1.22.2 Changes: -------- --- /work/SRC/openSUSE:Factory/pgadmin3/pgadmin3.changes 2017-11-27 22:17:37.328352922 +0100 +++ /work/SRC/openSUSE:Factory/.pgadmin3.new/pgadmin3.changes 2018-03-31 15:37:34.328199134 +0200 @@ -1,0 +2,6 @@ +Fri Mar 30 11:55:48 UTC 2018 - ralf.habacker@freenet.de + +- Added 0003-postgresql-8.3-support.patch to fix invalid + sql statement on accessing postgresql 8.3 database + +------------------------------------------------------------------- New: ---- 0003-postgresql-8.3-support.patch ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ pgadmin3.spec ++++++ --- /var/tmp/diff_new_pack.D6zQWt/_old 2018-03-31 15:37:35.420159541 +0200 +++ /var/tmp/diff_new_pack.D6zQWt/_new 2018-03-31 15:37:35.424159395 +0200 @@ -35,6 +35,7 @@ # https://bitbucket.org/openscg/pgadmin3-lts/commits/ea8a31af779b101248fc13242... # https://bitbucket.org/openscg/pgadmin3-lts/commits/1d65e012f7bb88d3b6c5a0894... Patch2: 0002-basic-support-postgresql10.patch +Patch3: 0003-postgresql-8.3-support.patch BuildRequires: autoconf BuildRequires: automake BuildRequires: fdupes @@ -95,6 +96,7 @@ %patch0 -p1 %patch1 -p1 %patch2 -p1 +%patch3 -p1 autoreconf -fiv sed -i 's/\r$//' LICENSE TODO CHANGELOG # remove wrong EOL ++++++ 0003-postgresql-8.3-support.patch ++++++ --- a/pgadmin/schema/pgColumn.cpp 2018-02-27 12:59:42.871950867 +0100 +++ b/pgadmin/schema/pgColumn.cpp 2018-02-27 13:00:15.491784358 +0100 @@ -568,7 +568,7 @@ // grab inherited tables with attibute names pgSet *inhtables = database->ExecuteSet( wxT("SELECT\n") - wxT(" array_to_string(array_agg(inhrelname), ', ') inhrelname,\n") + wxT(" array_to_string(array_agg(inhrelname), ', ') AS inhrelname,\n") wxT(" attrname\n") wxT("FROM\n") wxT(" (SELECT\n") --- a/pgadmin/schema/pgFunction.cpp 2018-02-27 13:10:04.000000000 +0100 +++ b/pgadmin/schema/pgFunction.cpp 2018-02-27 13:10:39.733120796 +0100 @@ -660,7 +660,7 @@ } pgSet *functions; - if (obj->GetConnection()->GetIsGreenplum()) + if (obj->GetConnection()->GetIsGreenplum() || !obj->GetConnection()->BackendMinimumVersion(9, 0)) { // the Open Source version of Greenplum already has the pg_get_function_result() function, // however the 4.3 stable release does not have this function