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: