ERROR: function array_agg(text) is not unique - Mailing list pgadmin-support

Hi!
I'm using pgAdmin 4:
Wersja 2.0
Prawa autorskieCopyright 2013 - 2017, The pgAdmin Development Team
Wersja Python2.7.11 (default, Apr 26 2017, 12:38:27) [GCC 4.4.7 20120313
(Red Hat 4.4.7-17)]
Wersja Flask0.11.1
Tryb AplikacjiDesktop
Aktualny Użytkownikpgadmin4@pgadmin.org

and cannot even click on a table because get the following error:
2017-11-08 14:06:32.124 CET [1247] ERROR:  function array_agg(text) is not
unique at character 5207

<http://www.postgresql-archive.org/file/t342733/Auswahl_831.png>

From the log:

2017-11-08 14:16:59.672 CET [1247] STATEMENT:  SELECT rel.oid, rel.relname
AS name, rel.reltablespace AS spcoid,rel.relacl AS relacl_str,  (CASE WHEN length(spc.spcname) > 0 THEN spc.spcname
ELSE   (SELECT sp.spcname FROM pg_database dtb    JOIN pg_tablespace sp ON dtb.dattablespace=sp.oid    WHERE dtb.oid =
16463::oid) END) as spcname,  (select nspname FROM pg_namespace WHERE oid = 16476::oid ) as schema,
pg_get_userbyid(rel.relowner)AS relowner, rel.relhasoids, rel.relkind,  (CASE WHEN rel.relkind = 'p' THEN true ELSE
falseEND) AS is_partitioned,  rel.relhassubclass, rel.reltuples, des.description, con.conname, 
con.conkey,    EXISTS(select 1 FROM pg_trigger            JOIN pg_proc pt ON pt.oid=tgfoid AND pt.proname='logtrigger'
         JOIN pg_proc pc ON pc.pronamespace=pt.pronamespace AND 
pc.proname='slonyversion'            WHERE tgrelid=rel.oid) AS isrepl,    (SELECT count(*) FROM pg_trigger WHERE
tgrelid=rel.oidAND tgisinternal = 
FALSE) AS triggercount,    (SELECT ARRAY(SELECT CASE WHEN (nspname NOT LIKE 'pg\_%') THEN
quote_ident(nspname)||'.'||quote_ident(c.relname)           ELSE quote_ident(c.relname) END AS inherited_tables    FROM
pg_inheritsi    JOIN pg_class c ON c.oid = i.inhparent    JOIN pg_namespace n ON n.oid=c.relnamespace    WHERE
i.inhrelid= rel.oid ORDER BY inhseqno)) AS coll_inherits,  (SELECT count(*)        FROM pg_inherits i      JOIN
pg_classc ON c.oid = i.inhparent      JOIN pg_namespace n ON n.oid=c.relnamespace        WHERE i.inhrelid = rel.oid) AS
inherited_tables_cnt,   (CASE WHEN rel.relpersistence = 'u' THEN true ELSE false END) AS 
relpersistence,    substring(array_to_string(rel.reloptions, ',') FROM 'fillfactor=([0-9]*)')
AS fillfactor,    (CASE WHEN (substring(array_to_string(rel.reloptions, ',') FROM
'autovacuum_enabled=([a-z|0-9]*)') = 'true')      THEN true ELSE false END) AS autovacuum_enabled,
substring(array_to_string(rel.reloptions,',') FROM 
'autovacuum_vacuum_threshold=([0-9]*)') AS autovacuum_vacuum_threshold,    substring(array_to_string(rel.reloptions,
',')FROM 
'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS
autovacuum_vacuum_scale_factor,    substring(array_to_string(rel.reloptions, ',') FROM
'autovacuum_analyze_threshold=([0-9]*)') AS autovacuum_analyze_threshold,    substring(array_to_string(rel.reloptions,
',')FROM 
'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS
autovacuum_analyze_scale_factor,    substring(array_to_string(rel.reloptions, ',') FROM
'autovacuum_vacuum_cost_delay=([0-9]*)') AS autovacuum_vacuum_cost_delay,    substring(array_to_string(rel.reloptions,
',')FROM 
'autovacuum_vacuum_cost_limit=([0-9]*)') AS autovacuum_vacuum_cost_limit,    substring(array_to_string(rel.reloptions,
',')FROM 
'autovacuum_freeze_min_age=([0-9]*)') AS autovacuum_freeze_min_age,    substring(array_to_string(rel.reloptions, ',')
FROM
'autovacuum_freeze_max_age=([0-9]*)') AS autovacuum_freeze_max_age,    substring(array_to_string(rel.reloptions, ',')
FROM
'autovacuum_freeze_table_age=([0-9]*)') AS autovacuum_freeze_table_age,    (CASE WHEN
(substring(array_to_string(tst.reloptions,',') FROM 
'autovacuum_enabled=([a-z|0-9]*)') =  'true')      THEN true ELSE false END) AS toast_autovacuum_enabled,
substring(array_to_string(tst.reloptions,',') FROM 
'autovacuum_vacuum_threshold=([0-9]*)') AS
toast_autovacuum_vacuum_threshold,    substring(array_to_string(tst.reloptions, ',') FROM
'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS
toast_autovacuum_vacuum_scale_factor,    substring(array_to_string(tst.reloptions, ',') FROM
'autovacuum_analyze_threshold=([0-9]*)') AS
toast_autovacuum_analyze_threshold,    substring(array_to_string(tst.reloptions, ',') FROM
'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS
toast_autovacuum_analyze_scale_factor,    substring(array_to_string(tst.reloptions, ',') FROM
'autovacuum_vacuum_cost_delay=([0-9]*)') AS
toast_autovacuum_vacuum_cost_delay,    substring(array_to_string(tst.reloptions, ',') FROM
'autovacuum_vacuum_cost_limit=([0-9]*)') AS
toast_autovacuum_vacuum_cost_limit,    substring(array_to_string(tst.reloptions, ',') FROM
'autovacuum_freeze_min_age=([0-9]*)') AS toast_autovacuum_freeze_min_age,    substring(array_to_string(tst.reloptions,
',')FROM 
'autovacuum_freeze_max_age=([0-9]*)') AS toast_autovacuum_freeze_max_age,    substring(array_to_string(tst.reloptions,
',')FROM 
'autovacuum_freeze_table_age=([0-9]*)') AS
toast_autovacuum_freeze_table_age,    array_to_string(rel.reloptions, ',') AS table_vacuum_settings_str,
array_to_string(tst.reloptions,',') AS toast_table_vacuum_settings_str,    rel.reloptions AS reloptions, tst.reloptions
AStoast_reloptions, 
rel.reloftype,    CASE WHEN typ.typname IS NOT NULL THEN (select quote_ident(nspname) FROM
pg_namespace WHERE oid = 16476::oid )||'.'||quote_ident(typ.typname) ELSE
typ.typname END AS typname,    (CASE WHEN rel.reltoastrelid = 0 THEN false ELSE true END) AS
hastoasttable,    -- Added for pgAdmin4    (CASE WHEN (substring(array_to_string(rel.reloptions, ',') FROM
'autovacuum_enabled=([a-z|0-9]*)'))::boolean  THEN true ELSE false END) AS
autovacuum_custom,    (CASE WHEN (substring(array_to_string(tst.reloptions, ',') FROM
'autovacuum_enabled=([a-z|0-9]*)'))::boolean  AND rel.reltoastrelid != 0
THEN true ELSE false END) AS toast_autovacuum,    *(SELECT array_agg(provider || '=' || label) * FROM pg_seclabels sl1
WHERE
sl1.objoid=rel.oid AND sl1.objsubid=0) AS seclabels,    (CASE WHEN rel.oid <= 13805::oid THEN true ElSE false END) AS
is_sys_table   -- Added for partition table    , (CASE WHEN rel.relkind = 'p' THEN pg_get_partkeydef(21530::oid) ELSE 
'' END) AS partition_scheme FROM pg_class rel  LEFT OUTER JOIN pg_tablespace spc on spc.oid=rel.reltablespace  LEFT
OUTERJOIN pg_description des ON (des.objoid=rel.oid AND 
des.objsubid=0 AND des.classoid='pg_class'::regclass)  LEFT OUTER JOIN pg_constraint con ON con.conrelid=rel.oid AND
con.contype='p'  LEFT OUTER JOIN pg_class tst ON tst.oid = rel.reltoastrelid  LEFT JOIN pg_type typ ON
rel.reloftype=typ.oidWHERErel.relkind IN ('r','s','t','p') AND rel.relnamespace = 16476::oidAND NOT rel.relispartition
ANDrel.oid = 21530::oid ORDER BY rel.relname; 
2017-11-08 14:17:03.430 CET [1247] ERROR:  function array_agg(text) is not
unique at character 5207
2017-11-08 14:17:03.430 CET [1247] HINT:  Could not choose a best candidate
function. You might need to add explicit type casts.



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html