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