case folding and postgres

From: emf <postgresql(at)mindlace(dot)net>
To: postgresql-hackers(at)postgresql(dot)org
Subject: case folding and postgres
Date: 2004-04-22 22:08:43
Message-ID: 9E660E0E-94A9-11D8-AB26-000A959B1F9A@mindlace.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

I have a project I'm moving from mysql to postgresql. It has both a
fair amount of code and a moderate amount of data. In MySQL the
identifiers are all MixedCase, but the query strings are never quoted.

I would like to change the default behaviour of postgresql to not fold
the case to lower. If I change scansup.c 's
downcase_truncate_identifier() to not lowercase identifiers, will I
break anything (other than case insensitivity?)

Furthermore, is there any way I could package this patch such that it
would be accepted? A suggestion I received from #postgresql was to
implement upper casing, lower casing, and leave-it-alone casing and to
have a per-db setting for that. Another approach I wouldn't mind adding
is a start-time option.

Thank you for CCing me, as I am not subbed to postgresql-hackers list.
--
nothing can happen inside a sphere
that you could not inscribe upon it.
~mindlace http://mindlace.net

Browse pgsql-hackers by date

  From Date Subject
Next Message Darren King 2004-04-22 22:14:02 Re: contrib vs. gborg/pgfoundry for replication solutions
Previous Message Tom Lane 2004-04-22 21:33:54 Re: valgrind errors