Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] What can we learn from MySQL?

From: Shachar Shemesh <psql(at)shemesh(dot)biz>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>,Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>,Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>,PostgreSQL advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: [HACKERS] What can we learn from MySQL?
Date: 2004-04-23 19:40:33
Message-ID: 40897131.6020902@shemesh.biz (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-www
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/


In response to

Responses

pgsql-www by date

Next:From: Alexey BorzovDate: 2004-04-23 19:50:10
Subject: Re: [pgsql-advocacy] What can we learn from MySQL?
Previous:From: Jim C. NasbyDate: 2004-04-23 19:27:30
Subject: Re: [HACKERS] What can we learn from MySQL?

pgsql-hackers by date

Next:From: Alexey BorzovDate: 2004-04-23 19:50:10
Subject: Re: [pgsql-advocacy] What can we learn from MySQL?
Previous:From: Andrew SullivanDate: 2004-04-23 19:34:42
Subject: Re: contrib vs. gborg/pgfoundry for replication solutions

pgsql-advocacy by date

Next:From: Alexey BorzovDate: 2004-04-23 19:50:10
Subject: Re: [pgsql-advocacy] What can we learn from MySQL?
Previous:From: Jim C. NasbyDate: 2004-04-23 19:27:30
Subject: Re: [HACKERS] What can we learn from MySQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group