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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-hackers pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2004-04-24 07:43:25 | Re: Do we prefer software that works or software that looks good? |
Previous Message | Dennis Bjorklund | 2004-04-24 05:52:13 | Re: [HACKERS] What can we learn from MySQL? |
From | Date | Subject | |
---|---|---|---|
Next Message | Shachar Shemesh | 2004-04-24 07:19:30 | Re: The case for preserving case. |
Previous Message | Dennis Bjorklund | 2004-04-24 05:52:13 | Re: [HACKERS] What can we learn from MySQL? |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2004-04-24 07:43:25 | Re: Do we prefer software that works or software that looks good? |
Previous Message | Dennis Bjorklund | 2004-04-24 05:52:13 | Re: [HACKERS] What can we learn from MySQL? |