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

Postgres connector fails with array columns

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 0.5.2
    • 0.5.1
    • postgresql-connector
    • None

    • Using Debezium Docker images + Embedded Engine client running on OSX with Java 1.8

    • Hide

      1. Create a database table with an array column and a complex type, e.g:

      create table test_arrays
(
	array_col bigint[] default '{}'::bigint[]
)

2. Start Debezium (in my case I used the embedded engine but I doubt it will be any different if I use Kafka Connect).
      Show
      1. Create a database table with an array column and a complex type, e.g: create table test_arrays ( array_col bigint[] default '{}' ::bigint[] ) 2. Start Debezium (in my case I used the embedded engine but I doubt it will be any different if I use Kafka Connect).

      All my Postgres array columns result in Debezium reporting the following on startup:

      2017-07-11 23:48:35,220 WARN Postgres|localhost|records-snapshot-producer Unexpected JDBC type '2003' for column 'array_col' that will be ignored [io.debezium.relational.TableSchemaBuilder]

              Unassigned Unassigned
              jarym Em Em (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: