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

Add support for Postgres VARCHAR array columns

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 0.7.2
    • 0.6.2
    • postgresql-connector
    • None

    Description

      my test table(postgresql):
      CREATE TABLE public.arr_test(
      id serial,
      content text,
      films integer[] NULL,
      films_relation jsonb NULL,
      imgs varchar(256)[] NULL,
      primary key(id)
      );

      warn log:
      Unexpected JDBC type '2003' for column 'imgs' that will be ignored [io.debezium.relational.TableSchemaBuilder]

      I looked at the code in PostgresValueConverter.java, varchar array seems to be unrealized.
      case PgOid.VARCHAR_ARRAY:
      .....
            // These array types still need to be implemented. The superclass will not handle them so
            // we return null here until we can code schema implementations for them.
            return null;

      Would like to ask why varchar array is not supported. Is it recommended to use the text array?

      Attachments

        Issue Links

          Activity

            People

              jpechane Jiri Pechanec
              jie123108 liuxiaojie liuxiaojie (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: