Skip to content

case sensitivity regarding field names postgresql #159

@japerlman

Description

@japerlman

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions