You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "Hongshun Wang (Jira)" <ji...@apache.org> on 2025/10/14 03:50:00 UTC

[jira] [Created] (FLINK-38512) Postgres YAML CDC support database name with middlescore

Hongshun Wang created FLINK-38512:
-------------------------------------

             Summary: Postgres YAML CDC support database name with middlescore
                 Key: FLINK-38512
                 URL: https://issues.apache.org/jira/browse/FLINK-38512
             Project: Flink
          Issue Type: Improvement
          Components: Flink CDC
    Affects Versions: cdc-3.5.0
            Reporter: Hongshun Wang
             Fix For: cdc-3.6.0


Though in postgres official documents, it write:

SQL identifiers and key words must begin with a letter ({{{}a{}}}-{{{}z{}}}, but also letters with diacritical marks and non-Latin letters) or an underscore ({{{}_{}}}).[1]

 

However , this is not exactly the documentation for a database name. If you read it closely, {{-}} is not allowed, yet, while {{CREATE TABLE foo-bar;}} does indeed fail, {{createdb foo-bar}} on the command line works perfectly to create a database named {{foo-bar[2]}}

[1][https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS]

 [2] https://stackoverflow.com/questions/10216784/what-is-a-valid-postgresql-database-name



--
This message was sent by Atlassian Jira
(v8.20.10#820010)