Closed
Description
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
- Create a table with a
TIMESTAMP_WITH_TIMEZONE
column - Create an incremental sync using this column as a cursor
- Run the sync