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

Support Postgres composite types

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Unresolved
    • Icon: Major Major
    • Backlog
    • None
    • postgresql-connector
    • None

      Postgres Composite types allow structured types to be used as column types:

      CREATE TYPE phone AS (
          area text,
          numb integer
      );
      
      ALTER TABLE customers ADD phone_no phone;
      

      Debezium should capturing values to such columns. Some open questions:

      • Are changes to the logical decoding plug-ins needed?
      • How to obtain information about the columns contained in a composite type?
      • How to represent columns of composite types in emitted CDC messages? Could be done as an equivalent struct or just by adding the contained columns directly to the before/after structs. The latter increases compatibility with consumers, but it loses information about the containing composite type. This might be mitigated by adding the composite type name as a schema parameter of the schemas for the contained columns. That'd be my preference.

            Unassigned Unassigned
            gunnar.morling Gunnar Morling
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated: