Skip to content

source-postgres: TIMESTAMP_WITH_TIMEZONE column can't be used as cursor #13603

Closed
@alafanechere

Description

@alafanechere

Environment

  • Source Connector and version: source-postgres 0.4.21
  • Step where error happened: Sync job

Current Behavior

#13166 enabled the source postgres connector to replicate TIMESTAMP_WITH_TIMEZONE columns. But user can't use this kind of column as a cursor for incremental sync because this type is not handled in setStatementField here.
Leading to the following error:

2022-06-08 07:08:55 e[44msourcee[0m > java.lang.IllegalArgumentException: TIMESTAMP_WITH_TIMEZONE is not supported.
2022-06-08 07:08:55 e[44msourcee[0m > 	at io.airbyte.db.jdbc.JdbcSourceOperations.setStatementField(JdbcSourceOperations.java:86) ~[io.airbyte.airbyte-db-db-lib-0.39.13-alpha.jar:?]

Expected Behavior

Users should be able to use a TIMESTAMP_WITH_TIMEZONE field for cursor in incremental read.

Steps to Reproduce

  1. Create a table with a TIMESTAMP_WITH_TIMEZONE column
  2. Create an incremental sync using this column as a cursor
  3. Run the sync

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions