X-Original-To: pgsql-sql@postgresql.org Received: from dmdelorme.ca (unknown [24.66.20.243]) by postgresql.org (Postfix) with SMTP id 1665C4761BC for ; Wed, 12 Mar 2003 09:15:30 -0500 (EST) Received: (qmail 22251 invoked from network); 12 Mar 2003 14:15:33 -0000 Received: from dmdelorme.dmdelorme.ca (HELO dmdelorme) (192.168.1.73) by geo.dmdelorme.ca (192.168.1.1) with SMTP; 12 Mar 2003 14:15:33 -0000 From: "David Delorme" To: Subject: The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard Date: Wed, 12 Mar 2003 08:15:33 -0600 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Archive-Number: 200303/282 X-Sequence-Number: 12322 I am trying to integrate MapInfo with a postgresql backend. Problem: MapInfo query uses both quoted and unquoted statements i.e. "MAPINFO"."MAPINFO_MAPCATALOG" and mapinfo.mapinfo_mapcatalog I can not change the query statements that MapInfo uses to talk to the odbc driver. I am in the process of changing to grass5 for all my map production. I have a schema called MAPINFO and a table called MAPINFO_MAPCATALOG. I need to fold unquoted names to uppercase. I really only need to change this behaviour for this schema. David Delorme http://dmdelorme.ca