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

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 0.10.0.Final
    • postgresql-connector
    • None

      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;

              ccranfor@redhat.com Chris Cranford
              vit_evv Vitalii Yevtushenko (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: