Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-1634

Recognize PostgreSQL ENUM type as VARCHAR and send it as hash code of the byte array instead of its content

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate Issue
    • Affects Version/s: 0.10.0.Final
    • Fix Version/s: None
    • Component/s: postgresql-connector
    • Labels:
      None

      Description

      As I know from issue DBZ-920 Debezium doesn't support PostgreSQL enum type and it should be recognized as UNKNOWN. However, in my case, it's recognized as VARCHAR (see attachment) and after applying PostgresValueConverter.convertString results into a hash code of the byte array instead of its content.

      All enums in my PostgreSQL database are created as:
      CREATE TYPE attachment_type_enum AS ENUM ('POD', 'SIGNATURE', 'DOCUMENT');
      ALTER TABLE public.documents ADD COLUMN attachment_type attachment_types_enum;

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ccranfor Chris Cranford
              Reporter:
              vit_evv Vitalii Yevtushenko (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: