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

Postgres connector fails with array columns

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • 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).

    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

          is related to

          Feature Request - Feature requests from customers and/or users DBZ-315 Postgres: Support multi-dimensional arrays

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Open

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: