Horton

Thread

  1. General Bug Report: ODBC translation of Table/Field Names

    Unprivileged user <nobody> — 1999-07-19T23:36:23Z

    ============================================================================
                        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.

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