Re: PostgreSQL Gotchas - Mailing list pgsql-general

From Scott Marlowe
Subject Re: PostgreSQL Gotchas
Date
Msg-id 1129227501.29961.209.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: PostgreSQL Gotchas  (Chris Travers <chris@travelamericas.com>)
Responses Re: PostgreSQL Gotchas  (Chris Travers <chris@travelamericas.com>)
List 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.

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: PostgreSQL Gotchas
Next
From: Andrew Sullivan
Date:
Subject: Re: On "multi-master"