Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Table & columns case sensitiveness #29

Open
maoueh opened this issue Jul 12, 2023 · 0 comments
Open

Table & columns case sensitiveness #29

maoueh opened this issue Jul 12, 2023 · 0 comments

Comments

@maoueh
Copy link
Contributor

maoueh commented Jul 12, 2023

It appears that table & column names must all be provided in lower case. I'm not sure yet if it's a bug in the sink code or it's a Postgres limitation that all identifiers are returned lowered case.

This means passing Transfer fails for table name even if in the schema SQL it was written Transfer. Same thing with column names.

If it's indeed a Postgres thing, we should probably normalize the table/column to lower case when creating them directly to avoid mistakes.

Otherwise if it's a bug in the sink code, we must decide what is the best course here (respect casing or always keep lower case).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant