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

Support new wal2json type specifiers

XMLWordPrintable

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

      With wal2json after https://github.com/eulerto/wal2json/issues/31 all the type specifiers have changed.

      eg. before
      "columntypes" : [ "int4", "int4", "varchar", "varchar", "varchar", "varchar", "date", "varchar", "varchar", "varchar", "varchar", "geometry" ],
      after
      "columntypes" : [ "integer", "integer", "character varying(20)", "character varying(4)", "character varying(100)", "character varying(100)", "date", "character varying(100)", "character varying(254)", "character varying(20)", "character varying(2)", "geometry(MultiPolygon,2193)" ],

      https://github.com/debezium/debezium/blob/master/debezium-connector-postgres/src/main/java/io/debezium/connector/postgresql/connection/wal2json/Wal2JsonReplicationMessage.java has a big list of type strings and they don't match^.

      Looks like you can turn the behaviour off with the plugin option include-typmod=0 but it'd probably be better to support them.

      https://www.postgresql.org/docs/current/static/datatype.html#DATATYPE-TABLE has a list of the builtin typenames if that's helpful.

              robert.coup Robert Coup (Inactive)
              robert.coup Robert Coup (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: