Cannot execute on אable names with uppercase letter

Question

Cannot execute on אable names with uppercase letter

aviranco opened this issue 6 years ago · 3 comments

Hi,

When I am trying to copy table content when the table name has upper case it fails, saying that the table not exist (with the lower cased name of the table).

e.g. when trying to execute the following: sCOPY my_schema.Entity TO STDOUT
I get error: error: relation "my_schema.entity" does not exist

After renaming the table name to lower case it works

Answer 1 · 2019-03-18T12:17:24.000Z

Hello. Thanks for the report. I don't really see where pg-copy-streams would have an impact on this. it simply forwards the sql COPY command to postgres. do have a test case that we could add to the test suite showing what goes wrong ?

Answer 2 · 2019-03-18T12:19:36.000Z

Also please check https://stackoverflow.com/questions/43111996/why-postgresql-does-not-like-uppercase-table-names that might be related.

Answer 3 · 2019-03-18T17:52:06.000Z

I'll close this issue now I don't think this is related to the pg-copy-streams module. Feel free to re-open with a test case.