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

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

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: 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-24 17:46:41
Message-ID: 20040424174641.GA7253@phlogiston.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-www
On Fri, Apr 23, 2004 at 11:45:28AM -0400, Robert Treat wrote:

> lower will now simply be folder upper. the only people who will have a
> problem are those who quote on one end but not the other, which is bad
> practice anyways...  so i would say if your serious about it, make the
> patch as GUC "case_folding" for upper or lower and get a taste for what
> breaks inside the db. 

If it were that easy, it wouldn't matter, right?  That is, if you had
a system which was either consistently quoted or consistently
unquoted, then you'd never run into the problem of the upper-or-lower
question.

It's precisely _because_ systems often have been maintained by
various cranks for 20 years that it's a problem.  One guy thinks
quoting is stupid.  Another thinks that if you don't quote, you're
asking for trouble,  A third has been rigourous in following the
quoting convention he learned in his last job.  The ship date is
three weeks away, and there are 802 "P1" bugs filed.  What chance do
you think there is that someone is going to scrub all the checkins of
quotes (or apply them carefully)?  This is _exactly_ why standards
compliance for this stuff matters, and why backward comaptibility is
also a top priority.

A

-- 
Andrew Sullivan  | ajs(at)crankycanuck(dot)ca

In response to

pgsql-www by date

Next:From: Jordan HendersonDate: 2004-04-24 19:05:06
Subject: Re: [HACKERS] What can we learn from MySQL?
Previous:From: Bruno Wolff IIIDate: 2004-04-24 17:10:01
Subject: Re: [HACKERS] What can we learn from MySQL?

pgsql-hackers by date

Next:From: Jordan HendersonDate: 2004-04-24 19:05:06
Subject: Re: [HACKERS] What can we learn from MySQL?
Previous:From: Thomas HallgrenDate: 2004-04-24 17:31:50
Subject: GUC custom variables

pgsql-advocacy by date

Next:From: Marc G. FournierDate: 2004-04-24 18:05:35
Subject: Re: Press Release Party
Previous:From: Bruno Wolff IIIDate: 2004-04-24 17:10:01
Subject: Re: [HACKERS] What can we learn from MySQL?

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