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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
Cc: Shachar Shemesh <psql(at)shemesh(dot)biz>,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 11:45:54
Message-ID: 20459.1082720754@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-www
Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> writes:
> On Fri, 23 Apr 2004, Shachar Shemesh wrote:
>> When I ask about non-standard complience of Pg (turning unquoted 
>> identifiers to lowercase instead of uppercase, violating the SQL 
>> standard, and requring an expensive rewrite of clients), and I get the 
>> answer "uppercase is ugly", I think something is wrong.

> I would love if someone fixed pg so that one can get the standard 
> behaviour. It would however have to be a setting that can be changed so we 
> are still backward compatible.

Yes.  There have been repeated discussions about how to do this, but
no one's come up with a solution that seems workable.  See the archives
if you care.

For the foreseeable future, backwards compatibility is going to trump
standards compliance on this point.  That doesn't mean we don't care
about compliance; it does mean that it is not the *only* goal.

I find it a bit odd to be debating this point in this thread, seeing
that one of the big lessons I draw from MySQL is "standards compliance
does not matter"...

			regards, tom lane

In response to

pgsql-www by date

Next:From: David CostaDate: 2004-04-23 12:32:50
Subject: Re: What can we learn from MySQL?
Previous:From: Alexey BorzovDate: 2004-04-23 11:37:43
Subject: Re: Dump of the current site DB needed

pgsql-hackers by date

Next:From: Jan WieckDate: 2004-04-23 11:59:54
Subject: Re: contrib vs. gborg/pgfoundry for replication solutions
Previous:From: Greg Sabino MullaneDate: 2004-04-23 11:37:30
Subject: Re: contrib vs. gborg/pgfoundry for replication solutions

pgsql-advocacy by date

Next:From: Merlin MoncureDate: 2004-04-23 12:27:11
Subject: Re: What can we learn from MySQL?
Previous:From: Robert BernierDate: 2004-04-23 11:07:41
Subject: Re: What can we learn from MySQL?

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