>>>> Shridhar Daithankar <shridhar_daithankar@persistent.co.in> 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