Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Ошибка после установки расширения #15

Closed
@Fenoman

Description

@Fenoman

После установки расширения у меня появилась проблема с тем, что перестал работать pgAdmin 4.0, аналогично отваливается DataGrip при получении объектов из схемы public.

Возникает следующая ошибка:

with schema_procs as (select prorettype, proargtypes, proallargtypes from pg_catalog.pg_proc where pronamespace = ?::oid and xmin::varchar::bigint > ? ), schema_opers as (select oprleft, oprright, oprresult from pg_catalog.pg_operator where oprnamespace = ?::oid and xmin::varchar::bigint > ? ), schema_aggregates as (select A.aggtranstype , A.aggmtranstype from pg_catalog.pg_aggregate A join pg_catalog.pg_proc P on A.aggfnoid = P.oid where P.pronamespace = ?::oid and (A.xmin::varchar::bigint > ? or P.xmin::varchar::bigint > ?) ), schema_arg_types as ( select prorettype as type_id from schema_procs union select distinct unnest(proargtypes) as type_id from schema_procs union select distinct unnest(proallargtypes) as type_id from schema_procs union select oprleft as type_id from schema_opers where oprleft is not null union select oprright as type_id from schema_opers where oprright is not null union select oprresult as type_id from schema_opers where oprresult is not null union select aggtranstype::oid as type_id from schema_aggregates union select aggmtranstype::oid as type_id from schema_aggregates ) select type_id, pg_catalog.format_type(type_id, null) as type_spec from schema_arg_types where type_id0 [42725]org.postgresql.util.PSQLException: ОШИБКА: функция unnest(oidvector) не уникальна Подсказка: Не удалось выбрать лучшую кандидатуру функции. Возможно, вам следует добавить явные приведения типов. Позиция:1006

После удаления расширения ошибка пропадает.

Используемая версия Postgres:
PostgresPro 11.1.1 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.3.0-27ubuntu1~18.04) 7.3.0, 64-bit

Установленные расширения:

extnameextownerextnamespaceextrelocatableextversionextconfigextcondition
plpgsql1011false1.0NULLNULL
file_fdw102200true1.0NULLNULL
pg_buffercache102200true1.3NULLNULL
pg_stat_statements102200true1.5NULLNULL
pg_variables102200true1.1NULLNULL
tablefunc102200true1.0NULLNULL
uuid-ossp102200true1.1NULLNULL
pg_pathman163842200false1.5{119515229,119515240}{,}
tds_fdw163842200true2.0.0-alpha.2NULLNULL
plv81638411false2.3.8NULLNULL
pg_query_state163842200true1.1NULLNULL
bloom163842200true1.0NULLNULL
pageinspect163842200true1.7NULLNULL
btree_gin163842200true1.3NULLNULL
pg_trgm163842200true1.4NULLNULL
vops163842200true1.0NULLNULL

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions


      [8]ページ先頭

      ©2009-2025 Movatter.jp