• Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 0.7.4
    • 0.7.2
    • postgresql-connector
    • None

      The Postgres connector seems to ignore binary fields, of the type 'bytea'

      That is consistent with the documentation at http://debezium.io/docs/connectors/postgresql/ where it says 'n/a' with the bytea type.

      I tried using the 'include.unknown.datatypes' config property, but that does not seem to work.

      Is there any kind of work-around to access my binary data in Postgres?

            [DBZ-605] Add support for columns of type "bytea"

            Released

            Jiri Pechanec added a comment - Released

            The nightly build seems to solve this issue for me (now I need to tune the memory as my binaries are a bit big)
            Thanks!

            Frank Lyaruu (Inactive) added a comment - The nightly build seems to solve this issue for me (now I need to tune the memory as my binaries are a bit big) Thanks!

            Thanks for looking into it! I'll have a look at it to see if that addresses the issue.

            Frank Lyaruu (Inactive) added a comment - Thanks for looking into it! I'll have a look at it to see if that addresses the issue.

            Ah, interesting, indeed it was already mentioned in the list of column types. All good then, thanks

            Gunnar Morling added a comment - Ah, interesting, indeed it was already mentioned in the list of column types. All good then, thanks

            There is nothing to document - it seems that BYTEA should not be included in the docs at all. Now the documentation is in-line with the code.

            Jiri Pechanec added a comment - There is nothing to document - it seems that BYTEA should not be included in the docs at all. Now the documentation is in-line with the code.

            Support for bytea has been implemented and will be contained in the next release. On include.unknown.datatypes, we just checked that and it worked. Perhaps some typo somewhere? Feel free to share your connector config and we can see whether something sticks out.

            jpechane, can you add the new column type to the connector docs, too? Thanks!

            Gunnar Morling added a comment - Support for bytea has been implemented and will be contained in the next release. On include.unknown.datatypes , we just checked that and it worked. Perhaps some typo somewhere? Feel free to share your connector config and we can see whether something sticks out. jpechane , can you add the new column type to the connector docs, too? Thanks!

            The workaround would be to use that property you mentioned. Odd that this didn't work, we'll have to take a look. Apart from that we should just add support for that data type. Any help is welcomed of course

            Gunnar Morling added a comment - The workaround would be to use that property you mentioned. Odd that this didn't work, we'll have to take a look. Apart from that we should just add support for that data type. Any help is welcomed of course

              jpechane Jiri Pechanec
              frank@dexels.com Frank Lyaruu (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: