Received: from clubserv.rp-online.de (clubserv.rp-online.de [149.221.232.11]) by hub.org (8.9.2/8.9.1) with ESMTP id BAA67489 for ; Tue, 16 Mar 1999 01:18:23 -0500 (EST) (envelope-from Michael.Meskes@gmx.net) Received: from pc63.rp-plus.de (as13-082.rp-plus.de [149.221.92.210]) by clubserv.rp-online.de (8.9.1a/8.9.1) with ESMTP id HAA13229 for ; Tue, 16 Mar 1999 07:17:38 +0100 (MET) Received: (from meskes@localhost) by pc63.rp-plus.de (8.9.3/8.9.3/Debian/GNU) id TAA01414 for pgsql-interfaces@postgresql.org; Mon, 15 Mar 1999 19:41:38 +0100 Date: Mon, 15 Mar 1999 19:41:38 +0100 From: Michael Meskes To: PostgreSQL Interfaces Subject: Re: R: [INTERFACES] DefineIndex fails Message-ID: <19990315194138.B1387@gmx.net> Mail-Followup-To: PostgreSQL Interfaces References: <002001be6ec5$23c6db00$19ff78c3@Lasaracina.iamb> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.4i In-Reply-To: <002001be6ec5$23c6db00$19ff78c3@Lasaracina.iamb>; from Nicholas Boretos on Mon, Mar 15, 1999 at 10:20:39AM +0100 On Mon, Mar 15, 1999 at 10:20:39AM +0100, Nicholas Boretos wrote: > Thanx for suggestions, > I was able to resolve this by changing table and field names all to lower > case letters. SQL standard says that case doesn't matter. This is a very common source for problems when accessing relational database systems through Access since in Access case matters. You can access a lower case table name by putting it between two ". That is select * from "a" will access table a, while seelct * from a will access "A". Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael.Meskes@gmx.net | Use PostgreSQL!