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

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

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Shachar Shemesh <psql(at)shemesh(dot)biz>
Cc: 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 09:22:33
Message-ID: Pine.LNX.4.44.0404231117270.4551-100000@zigo.dhs.org (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-www
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.

> that even if I write a patch to start migration, I'm not likely to get
> it in.

Just changing to uppercase would break old code so such a patch should not
just be commited. But would people stop a patch that is backward
compatible (in the worst case a setting during initdb)? I'm not so sure
they will.

--
/Dennis Björklund


In response to

Responses

pgsql-www by date

Next:From: Hans-Jürgen SchönigDate: 2004-04-23 09:47:31
Subject: Re: [HACKERS] What can we learn from MySQL?
Previous:From: Dave PageDate: 2004-04-23 09:06:09
Subject: Re: Dump of the current site DB needed

pgsql-hackers by date

Next:From: Hans-Jürgen SchönigDate: 2004-04-23 09:47:31
Subject: Re: [HACKERS] What can we learn from MySQL?
Previous:From: Karel ZakDate: 2004-04-23 08:52:32
Subject: Re: [HACKERS] What can we learn from MySQL?

pgsql-advocacy by date

Next:From: Hans-Jürgen SchönigDate: 2004-04-23 09:47:31
Subject: Re: [HACKERS] What can we learn from MySQL?
Previous:From: Karel ZakDate: 2004-04-23 08:52:32
Subject: Re: [HACKERS] What can we learn from MySQL?

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