X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4BE18D1B18F for ; Wed, 14 Jul 2004 11:16:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51135-06 for ; Wed, 14 Jul 2004 14:16:36 +0000 (GMT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 93AC8D1B1AB for ; Wed, 14 Jul 2004 11:16:27 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 8918235641; Wed, 14 Jul 2004 07:16:37 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 87AC835455; Wed, 14 Jul 2004 07:16:37 -0700 (PDT) Date: Wed, 14 Jul 2004 07:16:37 -0700 (PDT) From: Stephan Szabo To: Joost Kraaijeveld Cc: pgsql-admin@postgresql.org Subject: Re: Turning of case sensitivity for identifiers? In-Reply-To: Message-ID: <20040714071529.X95638@megazone.bigpanda.com> References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/167 X-Sequence-Number: 14235 On Wed, 14 Jul 2004, Joost Kraaijeveld wrote: > Is it possible to turn of the case sensitivity for tables and columns in > queries (to all CAPS)? I have a (closed source) tool that I have to use > (Clarion) that generates the queries and I cannot change the way the > tool generates the queries. It's not currently possible to turn off case folding or to force spec complient upper case folding. You may want to look through the archives for the discussions if you wish to add something.