db-sync icon indicating copy to clipboard operation
db-sync copied to clipboard

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

Open wonder-sk opened this issue 4 years ago • 0 comments

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

wonder-sk avatar Nov 01 '21 17:11 wonder-sk