[DBAL-557] [GH-343] Quote identifiers to avoid errors with CamelCased table|view|sequences names Created: 11/Jul/13  Updated: 20/Dec/13  Resolved: 20/Dec/13

Status: Resolved
Project: Doctrine DBAL
Component/s: None
Affects Version/s: None
Fix Version/s: 2.5
Security Level: All

Type: Bug Priority: Major
Reporter: Doctrine Bot Assignee: Benjamin Eberlei
Resolution: Fixed Votes: 0
Labels: None


This issue is created automatically through a Github pull request on behalf of exu:

Url: https://github.com/doctrine/dbal/pull/343


If you will have Camel Cased table name e.g: ```tmp.SomeNiceTable```, PostgreSQL is case insensitive when queries are passed by driver but is case sensitive when looks for objects so:

SELECT * FROM tmp.SomeNiceTable;

results in error:

relation "public.somenicetable" does not exist

We should use
SELECT * FROM tmp."SomeNiceTable";
form for queries, ```quote_ident``` do the job for Us, but it is not available
in versions prior to 7.3 (http://www.postgresql.org/docs/7.3/static/functions-string.html)

Comment by Doctrine Bot [ 20/Dec/13 ]

A related Github Pull-Request [GH-343] was closed:

Generated at Tue Oct 06 22:50:04 EDT 2015 using JIRA 6.4.10#64025-sha1:5b8b74079161cd76a20ab66dda52747ee6701bd6.