Hello,
usually sql identifiers are case insensitive. There are exception. If
you use double quotes for sql identifier, then you have to write exact
same identifier everywhere.
postgres=3D# create table Foo(a integer);
CREATE TABLE
Time: 174,078 ms
postgres=3D# select * from Foo;
a
---
(0 rows)
Time: 33,255 ms
postgres=3D# select * from foo;
a
---
(0 rows)
Time: 0,822 ms
postgres=3D# drop table foo;
DROP TABLE
Time: 34,945 ms
postgres=3D# create table "Foo"(a integer);
CREATE TABLE
Time: 3,225 ms
postgres=3D# select * from foo;
ERROR: relation "foo" does not exist
LINE 1: select * from foo;
^
postgres=3D# select * from Foo;
ERROR: relation "foo" does not exist
LINE 1: select * from Foo;
^
postgres=3D# select * from "Foo";
a
---
(0 rows)
Time: 1,277 ms
you cannot change this behave. Just don't use double quotes in create
statement.
Regards
Pavel Stehule
2010/2/2 Kelly SACAULT <kelly.sacault@gmail.com>:
>
> The following bug has been logged online:
>
> Bug reference: =C2=A0 =C2=A0 =C2=A05308
> Logged by: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Kelly SACAULT
> Email address: =C2=A0 =C2=A0 =C2=A0kelly.sacault@gmail.com
> PostgreSQL version: 8.4.2
> Operating system: =C2=A0 Ubuntu 9.10
> Description: =C2=A0 =C2=A0 =C2=A0 =C2=A0How to disable Case sensitivity o=
n 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 h=
ave
> spent many hours in studying the parameters, the faqs and the forums. I h=
ave
> 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 ?
>
> Kelly
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>
