(gravitino) branch main updated: [#7355] fix (doc): Update document for uppercase table and column names not supported in trino-connector of PostgreSQL catalog (#8171)

[jshao]

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

jshao pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/gravitino.git


The following commit(s) were added to refs/heads/main by this push:
     new 36ff2a9b7a [#7355] fix (doc): Update document for uppercase table and 
column names not supported in trino-connector  of PostgreSQL catalog (#8171)
36ff2a9b7a is described below

commit 36ff2a9b7aeadacc826a01d0ad60a38957f05c5d
Author: Yuhui <h...@datastrato.com>
AuthorDate: Thu Aug 21 12:32:09 2025 +0800

    [#7355] fix (doc): Update document for uppercase table and column names not 
supported in trino-connector  of PostgreSQL catalog (#8171)
    
    ### What changes were proposed in this pull request?
    
    Update document for uppercase table and column names not supported in
    trino-connector
    
    ### Why are the changes needed?
    
    Fix: #7355
    
    ### Does this PR introduce _any_ user-facing change?
    
    Update documents
    
    ### How was this patch tested?
    
    NO
---
 docs/trino-connector/catalog-postgresql.md | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/docs/trino-connector/catalog-postgresql.md 
b/docs/trino-connector/catalog-postgresql.md
index 83968f55fb..550b7f0d04 100644
--- a/docs/trino-connector/catalog-postgresql.md
+++ b/docs/trino-connector/catalog-postgresql.md
@@ -14,6 +14,16 @@ To connect to PostgreSQL, you need:
 - PostgreSQL 10.x or higher.
 - Network access from the Trino coordinator and workers to PostgreSQL. Port 
5432 is the default port.
 
+## Case sensitivity
+
+PostgreSQL treats unquoted identifiers as case insensitive.
+For example, the table name MyTable is equivalent to mytable and MYTABLE.
+
+However, if you create a table with quoted identifiers, such as "MyTable", it 
becomes case sensitive and must be referenced exactly as "MyTable".
+
+When using the Gravitino Trino connector with PostgreSQL, you must use 
unquoted identifiers to avoid case sensitivity issues.
+Otherwise, schema names, table names or column names containing uppercase 
letters may not be found.
+
 ## Create table
 
 At present, the Apache Gravitino Trino connector only supports basic 
PostgreSQL table creation statements, which involve fields, null allowances, 
and comments. However, it does not support advanced features like primary keys, 
indexes, default values, and auto-increment.