Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B34149FB21C; Mon, 30 Oct 2006 23:23:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 06528-01; Mon, 30 Oct 2006 23:23:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C9B889F9CF9; Mon, 30 Oct 2006 23:23:32 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k9V3NU2c023178; Mon, 30 Oct 2006 22:23:30 -0500 (EST) To: beau hargis cc: pgsql-sql@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: Case Preservation disregarding case sensitivity? In-reply-to: <200610301928.51255.beauh@bluefrogmobile.com> References: <200610271623.37525.beauh@bluefrogmobile.com> <1162003132.687.8.camel@pampa> <200610301928.51255.beauh@bluefrogmobile.com> Comments: In-reply-to beau hargis message dated "Mon, 30 Oct 2006 19:28:50 -0800" Date: Mon, 30 Oct 2006 22:23:30 -0500 Message-ID: <23177.1162265010@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/241 X-Sequence-Number: 26630 beau hargis writes: > Considering the differences that already exist between database systems and > their varying compliance with SQL and the various extensions that have been > created, I do not consider that the preservation of case for identifiers > would violate any SQL standard. That's not how I read the spec. It is true that we are not 100% spec compliant, but that isn't a good argument for moving further away from spec. Not to mention breaking backwards compatibility with our historical behavior. The change you propose would fix your application at the cost of breaking other people's applications. Perhaps you should consider fixing your app instead. regards, tom lane