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

Add support for Postgres VARCHAR array columns

    XMLWordPrintable

    Details

      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

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

                Dates

                Created:
                Updated:
                Resolved: