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

Postgres connector fails with array columns

    XMLWordPrintable

Details

    • 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).

    Description

      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]

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: