[
https://issues.apache.org/jira/browse/FLINK-38512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated FLINK-38512:
-----------------------------------
Labels: pull-request-available (was: )
> 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
> Priority: Major
> Labels: pull-request-available
> 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)
