Re: [GENERAL] Why does app fail?

[Paul Simpson]

>>>> Shridhar Daithankar <[EMAIL PROTECTED]> 25/02/2004 10:31:16 >>> >On Wednesday 25 February 2004 15:38, Paul Simpson wrote: >> Thank you for the advice, unfortunately, that isn't an option, you see I >> didn't write the application and so cannot control the calls it makes. What >> I need is for PG to do as it's told! >> >> I can only think of three solutions which I'd appreciate comments / advice >> on.... >> >> 1) Hack PG Source and re-compile to make upper-case the default table name. >> 2) Hack the ODBC driver source to get it to always add quotes to table >> names. 3) Given that the statement seems to be looking for the table name >> in one of the system tables, put a trigger on that table to automatically >> convert any new additions to upper case. > >I vote for option 2 It might take care of any other complaints such as >mismatch in locale etc. as well. I don't know really. > >Do we need to submit a TODO to hackers or on ODBC List? I am not too sure.. > >Shridhar >   Having spent a lot of time searching on the 'net, I suspect this would be a very popular option for a lot of people. What are the chances of getting this done fairly quickly, do you think?   Paul