Re: PostgreSQL Gotchas - Mailing list pgsql-general

From Matthew
Subject Re: PostgreSQL Gotchas
Date
Msg-id 43528DF6.4080106@zeut.net
Whole thread Raw
In response to Re: PostgreSQL Gotchas  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL Gotchas  (Chris Travers <chris@travelamericas.com>)
Re: PostgreSQL Gotchas  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Although ... it's true that there seem to be very few apps relying on
> case sensitivity per se, ie, expecting "Foo" and "foo" to be different.
> The complaints that I can remember were about programs that expected
> "FOO" and FOO (not quoted) to be the same.  So always-smash-to-lower-
> case might indeed solve most of the real-world problem for the Oracle
> camp as well.

Is it worth having a GUC variable that enables / disable this?   I hate
to add GUCs but this seems like a fairly significant change in expected
behavior.  Not sure it's a good idea, but I thought I should ask the
question anyway.

Matt


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: PostgreSQL Gotchas
Next
From: Peter Eisentraut
Date:
Subject: Re: PostgreSQL Gotchas