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

Postgres Connector inconsistent handling of timestamp precision

    XMLWordPrintable

Details

    Description

      We have noticed inconsistent behaviour in how timestamp precision is preserved by Debezium during snapshotting vs. normal CDC operations on the Postgres connector.

      For example on a DB field of type:

      timestamp without time zone
      

      containing value:

      2018-03-28 12:03:35.406753
      

      during a snapshot we get:

      1522238615406000000 (notice loss of nanosecond precision)
      

      However, if we update the same record we get:

      1522238615406753000 (no loss of nanosecond precision)
      

      We are not setting time.precision.mode in our config (so it should default to adaptive). We should see full nanosecond precision during both the snapshot and normal CDC.

      Attachments

        Activity

          People

            jpechane Jiri Pechanec
            jsyvanen Julius Syvanen (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: