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

Postgres - Column default values are not extracted

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 1.6.0.Beta2
    • 1.3.1.Final
    • postgresql-connector
    • None

    Description

      Postgres - Neither during snapshot phase nor streaming phase, Debezium connector does extract default values from table structure.

      This is problematic when Avro is used. When a new not null column with default value is added, the new schema is incompatible since - the new column has to be nullable or has a default value.

       

      (Clone of DBZ-1491)

      Attachments

        Issue Links

          clones

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) DBZ-1491 Column default values are not extracted while reading table structure

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

          Activity

            People

              Unassigned Unassigned
              kppullin Kevin Pullin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: