ERROR: function array_agg(text) is not unique

From: pinker <pinker(at)onet(dot)eu>
To: pgadmin-support(at)postgresql(dot)org
Subject: ERROR: function array_agg(text) is not unique
Date: 2017-11-08 13:19:32
Message-ID: 1510147172854-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pgadmin(dot)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 false END) 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.oid AND 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_inherits i
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_class c 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 AS toast_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 OUTER JOIN 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.oid
WHERE rel.relkind IN ('r','s','t','p') AND rel.relnamespace = 16476::oid
AND NOT rel.relispartition
AND rel.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

Browse pgadmin-support by date

  From Date Subject
Next Message Hoffman, Laura A (CTR) 2017-11-08 14:51:06 RE: Accessibility Issues with PostgreSQL pgAdmin 1.22.2
Previous Message Murtuza Zabuawala 2017-11-08 12:21:12 Re: values not fitting in query result columns, and some ideas