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

case sensitivity regarding field names postgresql #159

Open
japerlman opened this issue Jun 18, 2021 · 0 comments
Open

case sensitivity regarding field names postgresql #159

japerlman opened this issue Jun 18, 2021 · 0 comments

Comments

@japerlman
Copy link

I've been struggling with getting the PATCH and POST actions to work on a postgres DB I inherited that use camelCase field names (firstName, lastName) I created a new table with all lower case field names and everything works perfect. I renamed one of the camelCase fields (firstName -> first_name) in an dev copy of the database and it works that way too. I tried escaping the the field name in the JSON data body with ""firstName"" but that didn't work either.

Not sure what is going on but posting this here for a little guidance as to what I can do to get it to work with these camelCase field names, I had to enable 'quoteIdentifiers' => true in app.php to get Cake4 to even see the fields at all.

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