DBAL-557: [GH-343] Quote identifiers to avoid errors with CamelCased table|view|sequences names #1766

Closed
doctrinebot opened this Issue Jul 11, 2013 · 2 comments

2 participants

@doctrinebot

Jira issue originally created by user @doctrinebot:

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

Url: #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)

@doctrinebot

Comment created by @doctrinebot:

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

@doctrinebot

Issue was closed with resolution "Fixed"

@doctrinebot doctrinebot added the Bug label Dec 6, 2015
@beberlei beberlei was assigned by doctrinebot Dec 6, 2015
@doctrinebot doctrinebot added this to the 2.5 milestone Dec 6, 2015
@doctrinebot doctrinebot closed this Dec 6, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment