Why does app fail?

#11

On Wed, 25 Feb 2004, Paul Simpson wrote:

Quote:

I have downloaded it, thanks.
I'm not sure about this "foldtoupper" idea (particularly as they are
also talking about leaving the tablenames alone in the system tables.

What I don't understand is why the system can't be told simply to be
case sensitive. That way, if a table is created as MyTaBlE then it is
called MyTaBlE without requiring quotes, or am I missing something here?

It could, but I think that'd be even further from spec complience than
what we do now (fold to lowercase). Foldtoupper should provide a setting
that is not backward compatible with postgresql versions but meets the SQL
spec for handling unquoted names.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

#12

Quote:

I have, therefore, come to the conclusion that the app requires table names in
Upper case. How can I force this to work?

Check your ODBC driver; some ODBC drivers have an option to quote
identifiers. If yours doesn't, then maybe you should look around and see if
you can find one that does. (In general, when I've been forced to buy
commercial ODBC drivers, I've had good luck with OpenLink's products.)

--
Scott Ribe
scott_ribe (AT) killerbytes (DOT) com
http://www.killerbytes.com/
(303) 665-7007 voice

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Why does app fail?

comp.databases.postgresql.general comp.databases.postgresql.general

Re: Why does app fail? - 02-25-2004 , 09:54 AM

Re: Why does app fail? - 03-01-2004 , 07:32 PM