Re: case sensitivity on table & column names / workaround?

Ludek Finstrle wrote:
> What about updateable views? It could be the way for replication and name
> changing. I'm not sure it's only an idea.

Yes, I'd loosely considered this but then figured it wouldn't work b/c I
wouldn't be able to change the capitalization of the column identifiers
as well, but I guess I can do that with 'AS's in my CREATE VIEW
statement, eh?

Also, at the moment, the tables are readonly on the PG side so I don't
even need them to be updateable, but it's good to know that that feature
exists.

I suppose the is the best solution for now, though still not quite ideal
of course. Thanks for suggesting it, Luf; I'll give it a shot.

Any chance we might see some sort of feature in the ODBC driver (or the
backend) in the future to e.g., check an option that says "Ignore double
quotes on identifiers (and thus allow them to be folded to lower case)"?

Obviously, that'd probably be the most ideal situation for me here and
perhaps anyone else who is doing something where they're tightly
integrated with MSSQL or another backend that handles capitalization
differently.

Thanks again,

jl