Received: from ctral1.Vanderbilt.Edu (ctral1.Vanderbilt.Edu [129.59.1.22]) by hub.org (8.9.3/8.9.3) with ESMTP id XAA72633 for ; Sun, 19 Sep 1999 23:33:08 -0400 (EDT) (envelope-from powersdp@ctrvax.Vanderbilt.Edu) Received: from ctrvax.vanderbilt.edu (mopowers.HIP.Berkeley.EDU) by ctrvax.Vanderbilt.Edu (PMDF V5.1-10 #U3972) with ESMTP id <01JG65X830RS8WXR9P@ctrvax.Vanderbilt.Edu> for pgsql-general@hub.org; Sun, 19 Sep 1999 22:35:55 CDT Date: Sun, 19 Sep 1999 20:43:00 -0700 From: Dana Powers Subject: Case sensitivity To: pgsql-general@hub.org Message-id: <37E5AD44.CF6025CC@ctrvax.vanderbilt.edu> MIME-version: 1.0 X-Mailer: Mozilla 4.5 [en] (Win98; I) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en I am evaluating whether it is possible to migrate our Contact manager system to Postgres on Linux, but I am having difficulty because the client software was most moronically programmed to access tables using wildly different case structures, i.e. a table might be created 'MYTABLE', and accessed 'mytable', 'MyTable' or 'MYTABLE' depending on the context. Is there anyway to disable case-sensitivity in this case, either through Postgres config, or the ODBC drivers? I have no access to re-configure the clients, due to their wonderfully closed sourcedness. Thanks Dana Powers