ZF2 PostgreSQL db adapter bug

Question

Has anyone encountered a bug with table names using the PostgreSQL adapter in ZF2?

I have a column named UserId and when I try to update/delete a row based on this I get this error:

ERROR:  column 'userid' does not exist

as opposed to UserId.

This is my code:

$delete = $this->delete(
        'Users'
        , array(
             'UserId = ?' => $UserId
        )
    );

Might have something to do with autoQuoteIdentifiers but I couldn't find much online about it.

Any ideas?

Did you check this topic? stackoverflow.com/questions/15940765/… — Frank Heikens
– Frank Heikens, Commented Mar 11, 2015 at 7:16
I've had yes. The problem was that camel case column names need to be enclosed in double quotes so the array should have been array('"UserId" = ?' => $UserId) — matt
– matt, Commented Mar 11, 2015 at 8:15

matt · Accepted Answer · 2015-03-11 10:51:56Z

1

The problem was that camel cased column names need to be enclosed in double quotes so the array should be:

array('"UserId" = ?' => $UserId)

answered Mar 11, 2015 at 10:51

matt

2,3605 gold badges39 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1