From: | Ken Johanson <pg-user(at)kensystem(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Case Preservation disregarding case |
Date: | 2006-12-03 07:32:45 |
Message-ID: | 45727D9D.6080409@kensystem.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
Tom Lane wrote:
> Ken Johanson <pg-user(at)kensystem(dot)com> writes:
>
>> -*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.
>
Tom,
re: "clearly fail to understand": I know it's not currently selectable
at the session-level. My proposal (quote):
*If* the option ... were selectable
was to make them selectable -- this and another item that I'd proposed
in the past (The proposal for 'standard_conforming_strings' at the
session level was a step *toward* spec without harming existing apps).
Having to set standard_conforming_strings globally for example, is a
problematic setup for shared servers (ISPs etc).
A session configurable strategy is a huge feature to have in shared
environments. (BTW that strategy is both "functional and performing" for
Mysql -- several SQL conformance items can be config'd per connection).
> ...proposals that involve moving away from the SQL spec rather than
> closer to it; and that's what you're asking us to do.
If I ever proposed changing any *default* (spec) behavior, it was
inadvertent or a mistake. (prob. in making my argument that case-insens
does more harm that good for new PG users).
Of course adhering to spec is desirable, and if that mode of operation
remains *supported by default*, good. Adding per-connection or per-db
'quirks mode' (in the case of plug-in apps already built as case-insens
is innocuous).. that's a useful thing.
Put another way how many places is PG *deviating* from spec just by
providing conveniences -- would users revolt if those were dropped? For
compatibility, whether with old PG or Mysql (which is case-preserving
but case insens.), we NEED them. Not as a default behavior per se, but
as a per-session option.
Best,
Ken
From | Date | Subject | |
---|---|---|---|
Next Message | Gurjeet Singh | 2006-12-03 08:56:34 | Re: PostgreSQL win32 fragmentation issue |
Previous Message | Tom Lane | 2006-12-03 05:55:38 | Re: [HACKERS] Case Preservation disregarding case |
From | Date | Subject | |
---|---|---|---|
Next Message | Penchalaiah P. | 2006-12-03 10:33:41 | hi any one can help me |
Previous Message | Tom Lane | 2006-12-03 05:55:38 | Re: [HACKERS] Case Preservation disregarding case |