General Bug Report: ODBC translation of Table/Field Names

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Drew Whittle
Your email address : drew(at)csarc(dot)otago(dot)ac(dot)nz

Category : unknown
Severity : non-critical

Summary: ODBC translation of Table/Field Names

System Configuration
--------------------
Operating System : Linux 2.2.10 (RedHat)/NT 4

PostgreSQL version : 6.5

Compiler used : gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)

Hardware:
---------
Linux aphrael.albatross.co.nz 2.2.10 #3 Mon Jul 19 11:50:24 NZST 1999 i586 unkno
wn

Versions of other tools:
------------------------
GNU Make version 3.77, by Richard Stallman and Roland McGrath.

--------------------------------------------------------------------------

Problem Description:
--------------------
I am able to create a table or field name with uppercase
letters in it. This makes the table/field name impossible
to access.

--------------------------------------------------------------------------

Test Case:
----------
Using winsql or psql when you type "create table Test (id int);"
the table is created in lowercase, however if you create a table
in Microsoft Access and use the Save As/Export option and then
select ODBC Datasource and export it to a Postgres database the
table name will not get lowercased and you won't be able to
access it. This also applies to any field names created with
uppercase letters in them.

--------------------------------------------------------------------------

Solution:
---------
Ensure that all table/field names are run through a lower case
routine on create.

--------------------------------------------------------------------------