Skip to content

DB sync fails to restart if schema name has upper case characters #54

@wonder-sk

Description

@wonder-sk

This is the traceback:

image

Just checked in psql:

create schema "Hello";
select 'Hello'::regnamespace;    -- error
select "Hello"::regnamespace;    -- error
select '"Hello"'::regnamespace;  -- works

So we'll just need to wrap the schema name in double quotes and then single quotes... see also:
https://dba.stackexchange.com/questions/234330/how-to-use-to-regclass-with-uppercase-table-names

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions