Skip site navigation (1) Skip section navigation (2)

General Bug Report: ODBC translation of Table/Field Names

From: Unprivileged user <nobody>
To: pgsql-bugs(at)postgreSQL(dot)org
Subject: General Bug Report: ODBC translation of Table/Field Names
Date: 1999-07-19 23:36:23
Message-ID: 199907192336.TAA96695@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
============================================================================
                        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.

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


pgsql-bugs by date

Next:From: Bill RobertsDate: 1999-07-20 02:30:55
Subject: unsubscribe
Previous:From: Unprivileged userDate: 1999-07-19 08:47:05
Subject: General Bug Report: psql does report failed SQL commands as executed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group