Uppercase schema name causes error

[tthanh]

PGSync version: 2.1.9

Postgres version: 14

Elasticsearch version: 7.14.1

Redis version: 6.2.6

Python version: 3.9

Problem Description:

My schema:

[
    {
        "database": "postgres",
        "index": "blog",
        "nodes": {
            "table": "Blogs",
            "schema": "Blog",
            "columns": [
                "Id",
                "Title"
            ]
        }
    }
]

It works fine with lowercase schema "blog" but with uppercase schema "Blog" it shows me error when i edit my data (bootstrap and pgsync command still works, i can import current data to Elasticsearch but can no longer edit it).

I workaround by rename my schema to lowercase

Error Message:

Query: UPDATE "Blog"."Blogs" SET "Title" = 'new data' WHERE "Id" = 20;

Query 1: ERROR:  relation "blog._view" does not exist
LINE 2: ...                                             FROM Blog._view
                                                             ^
QUERY:  SELECT primary_keys, foreign_keys
                                                          FROM Blog._view
            WHERE table_name = TG_TABLE_NAME
CONTEXT:  PL/pgSQL function table_notify() line 32 at SQL statement