Re: The folding of unquoted names to lower case in PostgreSQL

On Fri, Mar 14, 2003 at 02:08:54PM -0700, scott.marlowe wrote:
> I'm strictly talking about a setting that would only be used on systems
> being used to port from databases that fold to uppercase like Oracle. I
> wouldn't want any changes that affected folks who didn't turn on the
> option, only those who did.

Given that kludges are the order of the day, what about creating an
updatable vire for every (candidate) table, with upper-case names
(for, I suppose, the tables and the fields)? It's not pretty, but
it'd get you there. I think it wouldn't be too hard to write a
script to do this automatically.

It'd make an unholy mess, of course, but nobody said this had to be
clean.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110