X-Original-To: pgsql-sql@postgresql.org Received: from dmdelorme.ca (unknown [24.66.20.243]) by postgresql.org (Postfix) with SMTP id 9D87347601F for ; Tue, 11 Mar 2003 14:39:10 -0500 (EST) Received: (qmail 18229 invoked from network); 11 Mar 2003 19:39:10 -0000 Received: from dmdelorme.dmdelorme.ca (HELO dmdelorme) (192.168.1.73) by geo.dmdelorme.ca (192.168.1.1) with SMTP; 11 Mar 2003 19:39:10 -0000 From: "David Delorme" To: Subject: The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard Date: Tue, 11 Mar 2003 13:39:10 -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/288 X-Sequence-Number: 12328 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 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