Re: [HACKERS] What can we learn from MySQL? - Mailing list pgsql-advocacy

From Shachar Shemesh
Subject Re: [HACKERS] What can we learn from MySQL?
Date
Msg-id 40897131.6020902@shemesh.biz
Whole thread Raw
In response to Re: [HACKERS] What can we learn from MySQL?  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-advocacy
Stephan Szabo wrote:

>I've tried just changing the parser to unconditionally casefold to upper.
>First thing that happens is that initdb breaks. In addition, you have
>potential issues with comparisons against the catalog's versions of
>standard functions as such if you allow the case folding to be changed
>after the catalogs are setup.
>
>
That's not the migration path I was thinking of.

What I was thinking of was:
1. Have a setting, probably per-session. Per database works too.
2. Aside from the folder upper and folder lower, have a third option.
This is "fold upper, if fails, fold lower. If succeeds, issue a
warning". This should allow programs that rely on the folding (such as
initdb) to be debugged during the transition period.

          Shachar

--
Shachar Shemesh
Lingnu Open Source Consulting
http://www.lingnu.com/


pgsql-advocacy by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [HACKERS] What can we learn from MySQL?
Next
From: pgsql@mohawksoft.com
Date:
Subject: Re: [HACKERS] What can we learn from MySQL?