-
Feature Request
-
Resolution: Done
-
Major
-
0.7.0
-
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.
- blocks
-
DBZ-379 Postgres connectors stops to work after concurrent schema changes and updates
- Closed