On Tue, Feb 2, 2010 at 12:11 PM, Kelly SACAULT <[email protected]> wrote: > > The following bug has been logged online: > > Bug reference: 5308 > Logged by: Kelly SACAULT > Email address: [email protected] > PostgreSQL version: 8.4.2 > Operating system: Ubuntu 9.10 > Description: How to disable Case sensitivity on naming identifiers > Details: > > I have installed Postgresql using Ubuntu Synaptic. > > In the contrary of what is stated in the official manual, I have to write > case sensitive SQL statements in my postgresql connexion. > > What parameter do I have to change in the postgresaql configuration ? I have > spent many hours in studying the parameters, the faqs and the forums. I have > found nothing to make my SQL statements case-insensitive. > I want to be able to execute successfully such stmts: > > SELECT col1 FROM myTABLE > > SELECT Col1 FROM myTable > > please, may you help ?
I thought PgSQL was case insensitive by default and that both those would be executed as: SELECT col1 FROM mytable; If you are seeing otherwise in the manual, can you provide a section? Best Wishes, Chris Travers > > Kelly > > -- > Sent via pgsql-bugs mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs > -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
