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

Add support for Postgres VARCHAR array columns

    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?

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved: