这是indexloc提供的服务,不要输入任何密码
Skip to content

Login Group/Roles 500 error: UNION types "char" and text cannot be matched  #6093

@dade520

Description

@dade520

When working with Login Group/Roles, I'm getting error "Failed to retrieve data from server / Request failed with status code 500" in app. This is on PostgreSQL v15.2 running on RHEL 8 and pgAdmin 4 v6.21

postgresql*.log shows:

2023-04-05 12:49:13.358 EDT [3663137] ERROR: UNION types "char" and text cannot be matched at character 745
2023-04-05 12:49:13.358 EDT [3663137] STATEMENT:
SELECT cl.relkind, COALESCE(cin.nspname, cln.nspname) as nspname,
COALESCE(ci.relname, cl.relname) as relname, cl.relname as indname
FROM pg_catalog.pg_class cl
JOIN pg_catalog.pg_namespace cln ON cl.relnamespace=cln.oid
LEFT OUTER JOIN pg_catalog.pg_index ind ON ind.indexrelid=cl.oid
LEFT OUTER JOIN pg_catalog.pg_class ci ON ind.indrelid=ci.oid
LEFT OUTER JOIN pg_catalog.pg_namespace cin ON ci.relnamespace=cin.oid
WHERE cl.oid IN (SELECT objid FROM pg_catalog.pg_shdepend WHERE refobjid=16388::oid) AND cl.oid > 16383::oid
UNION ALL SELECT 'n', null, nspname, null
FROM pg_catalog.pg_namespace nsp
WHERE nsp.oid IN (SELECT objid FROM pg_catalog.pg_shdepend WHERE refobjid=16388::oid) AND nsp.oid > 16383::oid
UNION ALL SELECT CASE WHEN typtype='d' THEN 'd' ELSE 'y' END, null, typname, null
FROM pg_catalog.pg_type ty
WHERE ty.oid IN (SELECT objid FROM pg_catalog.pg_shdepend WHERE refobjid=16388::oid) AND ty.oid > 16383::oid
UNION ALL SELECT 'C', null, conname, null
FROM pg_catalog.pg_conversion co
WHERE co.oid IN (SELECT objid FROM pg_catalog.pg_shdepend WHERE refobjid=16388::oid) AND co.oid > 16383::oid
UNION ALL SELECT CASE WHEN prorettype=2279 THEN 'T' ELSE 'p' END, null, proname, null
FROM pg_catalog.pg_proc pr
WHERE pr.oid IN (SELECT objid FROM pg_catalog.pg_shdepend WHERE refobjid=16388::oid) AND pr.oid > 16383::oid
UNION ALL SELECT 'o', null, oprname || '('::text || COALESCE(tl.typname, ''::text) || CASE WHEN tl.oid IS NOT NULL
AND tr.oid IS NOT NULL THEN ','::text END || COALESCE(tr.typname, ''::text) || ')'::text, null
FROM pg_catalog.pg_operator op
LEFT JOIN pg_catalog.pg_type tl ON tl.oid=op.oprleft
LEFT JOIN pg_catalog.pg_type tr ON tr.oid=op.oprright
WHERE op.oid IN (SELECT objid FROM pg_catalog.pg_shdepend WHERE refobjid=16388::oid) AND op.oid > 16383::oid
ORDER BY 1,2,3


Any insights?

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions