(flink-connector-jdbc) branch main updated: [FLINK-36303][JDBC/postgres] fix PostgreSQL minimum timestamp precision

[fanrui]

This is an automated email from the ASF dual-hosted git repository.

fanrui pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/flink-connector-jdbc.git


The following commit(s) were added to refs/heads/main by this push:
     new 319962ca [FLINK-36303][JDBC/postgres] fix PostgreSQL minimum timestamp 
precision
319962ca is described below

commit 319962ca28598de0f23657ed37986597e3eaef9a
Author: Ken Geis <kg...@berkeley.edu>
AuthorDate: Tue Sep 17 16:58:02 2024 -0700

    [FLINK-36303][JDBC/postgres] fix PostgreSQL minimum timestamp precision
---
 .../flink/connector/jdbc/postgres/database/dialect/PostgresDialect.java | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git 
a/flink-connector-jdbc-postgres/src/main/java/org/apache/flink/connector/jdbc/postgres/database/dialect/PostgresDialect.java
 
b/flink-connector-jdbc-postgres/src/main/java/org/apache/flink/connector/jdbc/postgres/database/dialect/PostgresDialect.java
index e087d619..f42ba480 100644
--- 
a/flink-connector-jdbc-postgres/src/main/java/org/apache/flink/connector/jdbc/postgres/database/dialect/PostgresDialect.java
+++ 
b/flink-connector-jdbc-postgres/src/main/java/org/apache/flink/connector/jdbc/postgres/database/dialect/PostgresDialect.java
@@ -39,7 +39,7 @@ public class PostgresDialect extends AbstractDialect {
     // Define MAX/MIN precision of TIMESTAMP type according to PostgreSQL docs:
     // https://www.postgresql.org/docs/12/datatype-datetime.html
     private static final int MAX_TIMESTAMP_PRECISION = 6;
-    private static final int MIN_TIMESTAMP_PRECISION = 1;
+    private static final int MIN_TIMESTAMP_PRECISION = 0;
 
     // Define MAX/MIN precision of DECIMAL type according to PostgreSQL docs:
     // 
https://www.postgresql.org/docs/12/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL