Re: BUG #5308: How to disable Case sensitivity on naming identifiers

On Tue, Feb 2, 2010 at 12:11 PM, Kelly SACAULT <kelly(dot)sacault(at)gmail(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5308
> Logged by:          Kelly SACAULT
> Email address:      kelly(dot)sacault(at)gmail(dot)com
> 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 (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>