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
    • 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: