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

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

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>,Shachar Shemesh <psql(at)shemesh(dot)biz>,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-24 05:56:43
Message-ID: 408A019B.4060307@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-www
Tom Lane wrote:
> Aside from the reality that apps aren't very consistent about their
> quoting behavior, the fly in this ointment is that whenever you query
> the database catalogs you will see the stored spelling of the name.
> So apps that rely on seeing the same spelling in the catalog that they
> entered could break.  (In practice this doesn't seem to be as big a
> problem as the sloppy-quoting-behavior issue, though.)

Shouldn't apps only really be querying the information schema if they're 
expecting spec compliant behavior? If so, a GUC variable with an access 
function ought to be enough to get up or down casing as desired, I'd think.

Joe


In response to

Responses

pgsql-www by date

Next:From: Stephan SzaboDate: 2004-04-24 07:43:25
Subject: Re: Do we prefer software that works or software that looks good?
Previous:From: Dennis BjorklundDate: 2004-04-24 05:52:13
Subject: Re: [HACKERS] What can we learn from MySQL?

pgsql-hackers by date

Next:From: Shachar ShemeshDate: 2004-04-24 07:19:30
Subject: Re: The case for preserving case.
Previous:From: Dennis BjorklundDate: 2004-04-24 05:52:13
Subject: Re: [HACKERS] What can we learn from MySQL?

pgsql-advocacy by date

Next:From: Stephan SzaboDate: 2004-04-24 07:43:25
Subject: Re: Do we prefer software that works or software that looks good?
Previous:From: Dennis BjorklundDate: 2004-04-24 05:52:13
Subject: Re: [HACKERS] What can we learn from MySQL?

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