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

Add support for Postgres VARCHAR array columns

XMLWordPrintable

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

      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?

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

                Created:
                Updated:
                Resolved: