public inbox for [email protected]
help / color / mirror / Atom feedFrom: Alvaro Herrera <[email protected]>
To: Joe Conway <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: Stephan Szabo <[email protected]>
Cc: Shachar Shemesh <[email protected]>
Cc: Robert Treat <[email protected]>
Cc: Dennis Bjorklund <[email protected]>
Cc: Bruce Momjian <[email protected]>
Cc: PostgreSQL-development <[email protected]>
Subject: Re: [pgsql-advocacy] What can we learn from MySQL?
Date: Sat, 24 Apr 2004 11:40:22 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<1082735128.22969.1106.camel@camel>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
On Fri, Apr 23, 2004 at 10:56:43PM -0700, Joe Conway wrote:
> 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.
Some questions:
Is there a way to make this work? At what level should the current
system be modified? If the parser or lexer is to be modified, are they
going to need database access? They are not allowed to, AFAIR.
One could invent a GUC setting for this, and have it set at database
creation time. How would shared catalogs be handled? Should we have a
template database for uppercase and another one for lower case
databases? Should non-shared catalogs be handled in a special way?
Or maybe it is a compilation switch. What issues would arise?
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Before you were born your parents weren't as boring as they are now. They
got that way paying your bills, cleaning up your room and listening to you
tell them how idealistic you are." -- Charles J. Sykes' advice to teenagers
view thread (145+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: [pgsql-advocacy] What can we learn from MySQL?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox