Ken Geis created FLINK-36303:
--------------------------------
Summary: PostgreSQL timestamp precision 0 not supported
Key: FLINK-36303
URL: https://issues.apache.org/jira/browse/FLINK-36303
Project: Flink
Issue Type: Bug
Components: Connectors / JDBC
Affects Versions: jdbc-3.2.0
Reporter: Ken Geis
I am having trouble with Flink 3.2.0 recognizing my timestamp(0) columns in
PostgreSQL 15.
PostgresDialect code says:
{code:java}
// 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;
{code}
The linked documentation says:
{quote}{{{}time{}}}, {{{}timestamp{}}}, and {{interval}} accept an optional
precision value _{{p}}_ which specifies the number of fractional digits
retained in the seconds field. By default, there is no explicit bound on
precision. The allowed range of _{{p}}_ is from 0 to 6.
{quote}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
