============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Drew Whittle
Your email address : drew@csarc.otago.ac.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.
--------------------------------------------------------------------------
