Your message dated Sun, 11 Feb 2018 21:26:38 +0000 with message-id <e1ekz8w-0007uo...@fasolo.debian.org> and subject line Bug#878295: fixed in pgadmin3 1.22.2-4 has caused the Debian Bug report #878295, regarding pgadmin3 changes for PG10 to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact ow...@bugs.debian.org immediately.) -- 878295: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=878295 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems
--- Begin Message ---Package: pgadmin3 Version: 1.22.2-1 ----- Forwarded message from Bernhard Rieder <bernh...@ratte.cc> ----- Date: Wed, 11 Oct 2017 16:10:53 +0200 From: Bernhard Rieder <bernh...@ratte.cc> To: christoph.b...@credativ.de Subject: pgadmin3 anpassungen für PG10diff -ur pgadmin3-1.22.2/pgadmin/include/pgAdmin3.h pgadmin3-1.22.2-PG10/pgadmin/include/pgAdmin3.h --- pgadmin3-1.22.2/pgadmin/include/pgAdmin3.h 2016-11-10 15:13:28.000000000 +0100 +++ pgadmin3-1.22.2-PG10/pgadmin/include/pgAdmin3.h 2017-10-11 14:40:38.835409091 +0200 @@ -58,8 +58,8 @@ // Supported server minimum and maximum values. const short SERVER_MIN_VERSION_N = 0x0804; const wxString SERVER_MIN_VERSION_T = wxT("8.4"); -const short SERVER_MAX_VERSION_N = 0x0906; -const wxString SERVER_MAX_VERSION_T = wxT("9.6"); +const short SERVER_MAX_VERSION_N = 0x0A00; +const wxString SERVER_MAX_VERSION_T = wxT("10.0"); // Supported Greenplum Database and Greenplum HAWQ minimum and maximum values. const short GP_MIN_VERSION_N = 0x0802; diff -ur pgadmin3-1.22.2/pgadmin/schema/pgServer.cpp pgadmin3-1.22.2-PG10/pgadmin/schema/pgServer.cpp --- pgadmin3-1.22.2/pgadmin/schema/pgServer.cpp 2016-02-08 11:25:13.000000000 +0100 +++ pgadmin3-1.22.2-PG10/pgadmin/schema/pgServer.cpp 2017-10-11 14:55:57.274751845 +0200 @@ -905,13 +905,24 @@ if (conn->BackendMinimumVersion(8, 5)) { sql += wxT(", CASE WHEN usesuper THEN pg_is_in_recovery() ELSE NULL END as inrecovery"); - sql += wxT(", CASE WHEN usesuper THEN pg_last_xlog_receive_location() ELSE NULL END as receiveloc"); - sql += wxT(", CASE WHEN usesuper THEN pg_last_xlog_replay_location() ELSE NULL END as replayloc"); + if (conn->BackendMinimumVersion(10, 0)) + { + sql += wxT(", CASE WHEN usesuper THEN pg_last_wal_receive_lsn() ELSE NULL END as receiveloc"); + sql += wxT(", CASE WHEN usesuper THEN pg_last_wal_replay_lsn() ELSE NULL END as replayloc"); + } + else + { + sql += wxT(", CASE WHEN usesuper THEN pg_last_xlog_receive_location() ELSE NULL END as receiveloc"); + sql += wxT(", CASE WHEN usesuper THEN pg_last_xlog_replay_location() ELSE NULL END as replayloc"); + } } if (conn->BackendMinimumVersion(9, 1)) { sql += wxT(", CASE WHEN usesuper THEN pg_last_xact_replay_timestamp() ELSE NULL END as replay_timestamp"); - sql += wxT(", CASE WHEN usesuper AND pg_is_in_recovery() THEN pg_is_xlog_replay_paused() ELSE NULL END as isreplaypaused"); + if (conn->BackendMinimumVersion(10, 0)) + sql += wxT(", CASE WHEN usesuper AND pg_is_in_recovery() THEN pg_is_wal_replay_paused() ELSE NULL END as isreplaypaused"); + else + sql += wxT(", CASE WHEN usesuper AND pg_is_in_recovery() THEN pg_is_xlog_replay_paused() ELSE NULL END as isreplaypaused"); } pgSet *set = ExecuteSet(sql + wxT("\n FROM pg_user WHERE usename=current_user")); @@ -1434,7 +1445,11 @@ bool pgServer::PauseReplay() { SetReplayPaused(true); - wxString sql = wxT("SELECT pg_xlog_replay_pause()"); + wxString sql; + if (conn->BackendMinimumVersion(10, 0)) + sql = wxT("SELECT pg_wal_replay_pause()"); + else + sql = wxT("SELECT pg_xlog_replay_pause()"); return conn->ExecuteVoid(sql); } @@ -1442,7 +1457,11 @@ bool pgServer::ResumeReplay() { SetReplayPaused(false); - wxString sql = wxT("SELECT pg_xlog_replay_resume()"); + wxString sql; + if (conn->BackendMinimumVersion(10, 0)) + sql = wxT("SELECT pg_wal_replay_resume()"); + else + sql = wxT("SELECT pg_xlog_replay_resume()"); return conn->ExecuteVoid(sql); }
--- End Message ---
--- Begin Message ---Source: pgadmin3 Source-Version: 1.22.2-4 We believe that the bug you reported is fixed in the latest version of pgadmin3, which is due to be installed in the Debian FTP archive. A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to 878...@bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Christoph Berg <m...@debian.org> (supplier of updated pgadmin3 package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing ftpmas...@ftp-master.debian.org) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Format: 1.8 Date: Sun, 11 Feb 2018 20:50:47 +0100 Source: pgadmin3 Binary: pgadmin3 pgadmin3-data Architecture: source Version: 1.22.2-4 Distribution: unstable Urgency: medium Maintainer: Debian PostgreSQL Maintainers <pkg-postgresql-public@lists.alioth.debian.org> Changed-By: Christoph Berg <m...@debian.org> Description: pgadmin3 - graphical administration tool for PostgreSQL pgadmin3-data - graphical administration tool for PostgreSQL - documentation Closes: 878295 888421 Changes: pgadmin3 (1.22.2-4) unstable; urgency=medium . * Move packaging repository to salsa.debian.org * pgadmin/include/pgAdmin3.h: Don't check for maximally supported PG version. * Support PG 10: Replace various occurrences of "xlog" by "wal" and "location" by "lsn". Patch by Bernhard Rieder and Christoph Berg. (Closes: #878295, #888421) Checksums-Sha1: 724e95f2a1c7bdcd84bd6c8685a04a23c253a795 2250 pgadmin3_1.22.2-4.dsc a0a4f4a5ca5ff8c83e25ee4a9a1eaf8b0c1dcdc3 20324 pgadmin3_1.22.2-4.debian.tar.xz 7aca6ddf535b8ed48a634109ee88d21d6277061e 12254 pgadmin3_1.22.2-4_source.buildinfo Checksums-Sha256: 0643557a36e1082273f62ba5e973abfa410d56409af41918312549d0ea128c61 2250 pgadmin3_1.22.2-4.dsc 003ce27647339acd75818eb6a057b0d7b329121a23ddd523383a825377a593bc 20324 pgadmin3_1.22.2-4.debian.tar.xz 1e0e7ef498aa0c89496720b12736fd4ed032aec8968e70de4af301391e1e41cc 12254 pgadmin3_1.22.2-4_source.buildinfo Files: e19c6aa08642c03d96b10f1001ce7bb4 2250 database optional pgadmin3_1.22.2-4.dsc 164f9ae843547f665057ee5e264fcdf5 20324 database optional pgadmin3_1.22.2-4.debian.tar.xz 21b71b50045385f2b64e925643ec2319 12254 database optional pgadmin3_1.22.2-4_source.buildinfo -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAlqAoWAACgkQTFprqxLS p66RQw//aqtp0clXOgv5+OANnnsp+TUNkpO4jVR7VMKQSa1ZnsNCoJYkBNcC9qli HIX+2VrhMzE4BJLznSwEtYAw+YP19iZG58OjkZA3h9tVXrsnbEHuCDR8j0aGX/Si ZEajiO99dI77LA/8gEUO+jgiuR5FZA82wxVu1YfYtc5trZn+xKJpspUXbOitGwFn +5BDTMCwJJyZppXUIBjnr0VsKEbvp15T4vHj4H71XmR5EUwodcW+f2C5uu3bY24i yOGfBZa8yF++DTAdtPyT88OXVNip6naj8i+xMqP/oyYsxPiGF71Bmf2XfDANeLE9 Wq4tJ+Lc1ZfFUHbfAcUkb11a8fxb/NYr6/2J27XgCfaS8611kJC7voijECGn+MOW VW445yVPxHH8YlUM5Na+ZpMeMpfBguolTQspz9tuIRdcUJXXLl92+sF61xz3iaUY Q4VJ49Kl0AAML0QFtORUKNHKpa8xoH3mf5njUdOMkGh7jzMf2YFspDDSGVv0AYCK +2NfZ+LcI1Nw8cDhrjS+xZVaSqF1R5TfzivLxK8NHCIuMs0+O+W3jOxxoYWLUo0r 6b0/cLmKfeotcmCIfSc1rbD+cGaVtVE8k/qCl+rYM+sHEWSoBDA71C8AekY/wi8s XD6w2MH5TN+KQMuI6UcEWlwFippR1w59uFn7o4drOJvTZq4fGog= =jsXm -----END PGP SIGNATURE-----
--- End Message ---
_______________________________________________ Pkg-postgresql-public mailing list Pkg-postgresql-public@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
