Hello,

  bug or feature ?

* PETER in uppercase :

sql>CREATE TABLE "PETER" ( nom varchar(20) );
operation successful (2.545ms)

sql>DROP TABLE PETER;
DROP TABLE: no such table 'peter'

sql>DROP TABLE "PETER";
operation successful (1.947ms)


* peter in lowercase :

sql>CREATE TABLE "peter" ( nom varchar(20) );
operation successful (2.917ms)

sql>DROP TABLE peter;
operation successful (1.882ms)


* peter in lowercase and uppercase :

sql>CREATE TABLE "peter" ( nom varchar(20) );
operation successful (2.900ms)

sql>CREATE TABLE PETER ( nom varchar(20) );
CREATE TABLE: name 'peter' already in use

sql>CREATE TABLE "PETER" ( nom varchar(20) );
operation successful (9.339ms)


Conclusion :
PETER is convert in peter
"PETER" is not convert


Pierre Coustillas

--
1G6
52 route de bischwiller
67300 Schiltigheim
Société de Services et de Formations en Logiciels Libres
http://1g6.biz
Tél : 06 64 63 70 35  //  09 54 38 70 90