#469 column p.proisagg does not exist

[Sébastien Clément]

Using phpPgAdmin v5.6 and PostgreSQL v11.2 on CentOS v7, when I try to access the Functions tab within the public schema, I get the following error:

ERROR:  column p.proisagg does not exist
LINE 18:    WHERE NOT p.proisagg
                      ^
HINT:  Perhaps you meant to reference the column "p.prolang".
Dans l'instruction :

            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 = 'public'
            ORDER BY p.proname, proresult

Fatal error: Call to a member function recordCount() on integer in /mnt/webdata/websites/appl

[Sébastien Clément]

Update:

The definition of the query to access the list of functions should be modified in phpPgAdmin to replace pg_proc.proisagg with pg_proc.prokind. See: https://dba.stackexchange.com/questions/238903/postgresql-11-error-column-p-proisagg-does-not-exist#238906

[Jobe]

The result of that change breaks support for older versions of PostgreSQL including but not limited to 9.3. Therefore the change needs to take PostgreSQL versions into account to use the correct form.

[Robert Treat]

I believe this is fixed in git and as such will be part of the next release. If you want to see the patch, check out: https://github.com/phppgadmin/phppgadmin/commit/e3e8087bfd8f1fb93564b7a691f8ac9ed7c63a02