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>
