Your message dated Sun, 29 Sep 2019 20:43:24 +0000
with message-id <[email protected]>
and subject line Bug#926512: fixed in phppgadmin 7.12.0+ds-1
has caused the Debian Bug report #926512,
regarding phppgadmin: v5.1 doesn't play well with PostgreSQL v11
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 [email protected]
immediately.)


-- 
926512: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=926512
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: phppgadmin
Version: 5.1+ds-4
Severity: important

Hi,

it seems things changed in PostgreSQL system tables; trying to show functions
throws this error (translated from Italian):

======================================= 8<
=======================================

SQL Error:

ERROR:  p.proisagg column doesn't exist
LINE 18:    WHERE NOT p.proisagg
                      ^
HINT:  Perhaps you wanted to reference column "p.prolang" instead.

In query:

                        SELECT

                                p.oid AS prooid,
                                p.proname,
                                p.proretset,
                                pg_catalog.format_type(p.prorettype, NULL) AS
proresult,
                                pg_catalog.oidvectortypes(p.proargtypes) AS
proarguments,
                                pl.lanname AS prolanguage,
                                pg_catalog.obj_description(p.oid, 'pg_proc') AS
procomment,
                                p.proname || ' (' ||
pg_catalog.oidvectortypes(p.proargtypes) || ')' AS proproto,
                                CASE WHEN p.proretset THEN 'setof ' ELSE '' END
|| pg_catalog.format_type(p.prorettype, NULL) AS proreturns,
                                u.usename AS proowner
                        FROM pg_catalog.pg_proc p
                                INNER JOIN pg_catalog.pg_namespace n ON n.oid =
p.pronamespace
                                INNER JOIN pg_catalog.pg_language pl ON pl.oid
= p.prolang
                                LEFT JOIN pg_catalog.pg_user u ON u.usesysid =
p.proowner
                        WHERE NOT p.proisagg
                                AND n.nspname = 'xxxxxxxx'
                        ORDER BY p.proname, proresult

======================================= >8
=======================================

v5.6 is available on project's homepage (1) and PostgreSQL v11 is going to be
released in Buster: can the version be aligned with upstream?

Thanks

(1) http://phppgadmin.sourceforge.net/doku.php


P.S.: please ignore system info: phppgadmin is installed on a different box



-- System Information:
Debian Release: buster/sid
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'proposed-updates'), (500, 'unstable'), 
(500, 'stable'), (500, 'oldstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 5.0.0-6.slh.1-aptosid-amd64 (SMP w/4 CPU cores; PREEMPT)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE
Locale: LANG=it_IT.UTF-8, LC_CTYPE=it_IT.UTF-8 (charmap=UTF-8), LANGUAGE=it 
(charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages phppgadmin depends on:
ii  dpkg                                1.19.6
pn  libapache2-mod-php | php-cgi | php  <none>
ii  libjs-jquery                        3.3.1~dfsg-1
pn  libphp-adodb                        <none>
pn  php-pgsql                           <none>

Versions of packages phppgadmin recommends:
pn  apache2 | httpd  <none>

Versions of packages phppgadmin suggests:
pn  postgresql      <none>
pn  postgresql-doc  <none>
pn  slony1-bin      <none>

--- End Message ---
--- Begin Message ---
Source: phppgadmin
Source-Version: 7.12.0+ds-1

We believe that the bug you reported is fixed in the latest version of
phppgadmin, 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 [email protected],
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Jean-Michel Vourgère <[email protected]> (supplier of updated phppgadmin 
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 [email protected])


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Format: 1.8
Date: Sun, 29 Sep 2019 22:05:11 +0200
Source: phppgadmin
Binary: phppgadmin
Architecture: source
Version: 7.12.0+ds-1
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers <[email protected]>
Changed-By: Jean-Michel Vourgère <[email protected]>
Description:
 phppgadmin - web-based administration tool for PostgreSQL
Closes: 926512
Changes:
 phppgadmin (7.12.0+ds-1) unstable; urgency=medium
 .
   [ Johannes Ranke ]
   * README.Debian: Give a hint how to find the port of local clusters.
 .
   [ Christoph Berg ]
   * Add debian/gitlab-ci.yml.
 .
   [ Jean-Michel Vourgère ]
   * New upstream version. Closes: #926512.
     - New upstream source address: Updated d/copyright and d/watch.
     - Dropped patches applied upstream.
   * Bumped policy to 4.4.0.
   * Bumped compat to 12.
   * Adjusted lintian override for tag
     package-contains-upstream-installation-documentation renaming.
Checksums-Sha1:
 0aeb93c9167c4a2469b84a401d726b4e5192465c 2005 phppgadmin_7.12.0+ds-1.dsc
 cbedfcf630cf9da39e9a54360e7ad663564023cb 431372 
phppgadmin_7.12.0+ds.orig.tar.xz
 68a4c57e29b909ccf42a1a51447c2b42f893d562 11108 
phppgadmin_7.12.0+ds-1.debian.tar.xz
 e5214ee396ffe2c2f79cbb6e58c2ac237511e53c 6221 
phppgadmin_7.12.0+ds-1_amd64.buildinfo
Checksums-Sha256:
 45834b5a3a25bef45e51d2349be857bd3d4b2d9c162666cea55c0a9a964fc443 2005 
phppgadmin_7.12.0+ds-1.dsc
 9d2f8831845cb84f718e474658f1832ed2331e3f0c4eb4168af371e0d894364c 431372 
phppgadmin_7.12.0+ds.orig.tar.xz
 eecd4041a52e5bf729c23e78e9d95c18c626aade7fb60a0e701d51cbfb7ee767 11108 
phppgadmin_7.12.0+ds-1.debian.tar.xz
 3cf9b5f9fc43726e2ac411509418467bb862d68e3926fce41616fc212c099f1a 6221 
phppgadmin_7.12.0+ds-1_amd64.buildinfo
Files:
 65c813a7e3c369754e3613a62e346b17 2005 web optional phppgadmin_7.12.0+ds-1.dsc
 9bb366768a623dff57b30f561a030e54 431372 web optional 
phppgadmin_7.12.0+ds.orig.tar.xz
 87e89b9a1b4d6ca28f537796cdb18a97 11108 web optional 
phppgadmin_7.12.0+ds-1.debian.tar.xz
 baa18c709090ad2cedb58d9a6cfaabe0 6221 web optional 
phppgadmin_7.12.0+ds-1_amd64.buildinfo

-----BEGIN PGP SIGNATURE-----

iQJGBAEBCgAwFiEEQIMD57NJdABlZVMrO1wscaIY2DwFAl2REMUSHG5pcmdhbEBk
ZWJpYW4ub3JnAAoJEDtcLHGiGNg8UQQP/RspylUN+HCQD8tSjB1qdTgoRCeGGWI5
ZNegmZkLpbpZxBi/8O3OANrQ6kBFl69tLSPKKzhDfi8SvcanO+2lZrumW/ZEJYVZ
jTHsgfiDk2nSIx4qJwZaaKRs9+T2UAt85VRkrhjoH+v6AmV7e4Ge0dslMElW6Vwj
K5+jrJ3cv4mZkwVPIFo2S315m2hIsZjMGGPMf2DHUw9X5NZtR/GGgCcc6xDb9iCW
FykpL9SphqHj863y+pYaiQbGNlngryGqDGI0RJfJm6k8+0fjx+aKfkExT5ZdJOXL
xHlwL9zqn7/HSNP4sgTKFWWzBx1lG6aHXsP//OV2fw4VnY4GrLwKNdBcq9MIxE0m
wCQ2duxASiJGAFesti2/tMM9npeA7O9mPlq+YDX/OxlXkCjqa++R2jSzU086ispE
2v1oSqcIllguufubVL0UobhuvsssL5oAWU2m2K3dSDkcb4hwZ212Juru12dUIuWa
rRTVd5e8jmaEEheH2vfbHPFa7D1uUjzWbCDZYERbLo8euxayjc5F7PY9S+iLGwO1
81RcC0nc+Pq1Q5heyHwoSgJp3tiMZ/U84X2d+/DpE8EYM9CKfGdtpSeQ7+49eGJP
fuSklr9lfGckXhTq3N7yY7X1aifp4iVh//tt4/xZ5clgHP7vXZIPBz1Feqd2Zose
PmbE/+gSfI/N
=z/cs
-----END PGP SIGNATURE-----

--- End Message ---

Reply via email to