| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Chris Travers <chris(at)travelamericas(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Stephen Frost <sfrost(at)snowman(dot)net>, "Aly S(dot)P Dharshi" <aly(dot)dharshi(at)telus(dot)net>, "Gavin M(dot) Roy" <gmr(at)ehpg(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL Gotchas |
| Date: | 2005-10-13 18:18:21 |
| Message-ID: | 1129227501.29961.209.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2005-10-13 at 13:09, Chris Travers wrote:
> Any chance of adding a configuration option for future versions in order
> to set case folding behavior? It seems that PostgreSQL has really
> attempted to be as standards-compliant as possible and this is one area
> where improvement could be made without breaking backward compatibility...
>
> We already have configuration options for setting whether NULL = NULL
> returns TRUE or NULL, and a few other legacy options for preventing past
> non-standard behavior from breaking compatibility with current versions.
The problem, as explained to me when I floated this idea, is that the
CATALOGS are all in lower case, and many references to them are behind
the case folding mechanism (i.e. they get accessed by their lower case
names directly by backend software).
So, one would also have to have some way of working around that.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2005-10-13 18:18:56 | Re: On "multi-master" |
| Previous Message | Chris Travers | 2005-10-13 18:09:34 | Re: PostgreSQL Gotchas |