From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ken Johanson <pg-user@kensystem.com>
Cc: Martijn van Oosterhout <kleptog@svana.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: [HACKERS] Case Preservation disregarding case
Date: Sun, 03 Dec 2006 00:55:38 -0500
Message-ID: <13344.1165125338@sss.pgh.pa.us> (raw)
In-Reply-To: <45725923.7010500@kensystem.com>
References: <200610301928.51255.beauh@bluefrogmobile.com>
<23177.1162265010@sss.pgh.pa.us>
<EB48EBF3B239E948AC1E3F3780CF8F88012F88DD@MI8NYCMAIL02.Mi8.com>
<45712E31.1030004@kensystem.com>
<20061202133556.GC26365@svana.org>
<457199E4.3010401@kensystem.com>
<4571A3AF.6070608@zigo.dhs.org>
<4571AE66.7050304@kensystem.com>
<4571B392.6020303@zigo.dhs.org>
<4571C133.1060200@kensystem.com>
<20061202201822.GD26365@svana.org>
<45725923.7010500@kensystem.com>
Ken Johanson <pg-user@kensystem.com> writes:
> Martijn van Oosterhout wrote:
>> I think it's unlikely to happen anytime soon. The primary reason being
>> that then you can no longer use indexes to search the catalog. Which
> I take a different opinion on this:
> -*If* the option to turn on case-insenetive behavior were selectable at
> the DB or session level, the existing apps could continue to use the
> case sensitve mode and be completely unaffected.
Ken, you clearly fail to understand the point being made above. This is
not something that is "selectable at the session level". It won't work
from either a functional or performance perspective.
The real bottom line, though, is that this community has little respect
for proposals that involve moving away from the SQL spec rather than
closer to it; and that's what you're asking us to do. The spec is not
at all vague about the case-sensitivity of identifiers. Now certainly
we are not doing exactly what the spec says, but what you ask is even
less like the spec's requirements.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, pg-user@kensystem.com, kleptog@svana.org
Subject: Re: [HACKERS] Case Preservation disregarding case
In-Reply-To: <13344.1165125338@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox