Skip to content

sql: pg_type_is_visible does not handle user-defined types #60008

Closed
#62181
Closed
sql: pg_type_is_visible does not handle user-defined types#60008
#62181
Labels
A-sql-builtinsSQL built-in functions and semantics thereof.A-sql-datatypesSQL column types usable in table descriptors.A-tools-sqlalchemyC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.S-3-wrong-metadataIssues causing erroneous metadata or monitoring stats to be returned.
@rafiss

Description

@rafiss
rafiss
opened on Feb 8, 2021

The following should return true, but it returns null.

root@:26257/defaultdb> create type mood as enum('Sad', 'Okk', 'Happy');
CREATE TYPE

root@:26257/defaultdb>  select pg_type_is_visible(t.oid) from pg_type t where t.typname = 'mood';
  pg_type_is_visible
----------------------
         NULL

the pg_type_is_visible only checks for the hardcoded list of builtin types.

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-builtinsSQL built-in functions and semantics thereof.A-sql-datatypesSQL column types usable in table descriptors.A-tools-sqlalchemyC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.S-3-wrong-metadataIssues causing erroneous metadata or monitoring stats to be returned.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions