Re: [HACKERS] What can we learn from MySQL? - Mailing list pgsql-advocacy

From Joe Conway
Subject Re: [HACKERS] What can we learn from MySQL?
Date
Msg-id 408A019B.4060307@joeconway.com
Whole thread Raw
In response to Re: [HACKERS] What can we learn from MySQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-advocacy
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


pgsql-advocacy by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: [HACKERS] What can we learn from MySQL?
Next
From: Stephan Szabo
Date:
Subject: Re: Do we prefer software that works or software that looks good?