[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


 Description   

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

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

Message:

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)



 Comments   
Comment by Doctrine Bot [ 20/Dec/13 ]

A related Github Pull-Request [GH-343] was closed:
https://github.com/doctrine/dbal/pull/343

Generated at Sat Aug 23 03:38:20 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.