>>>> 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




ABOUT THIS E-MAIL
The information contained within this e-mail is privileged, confidential and protected from disclosure.

Any opinions expressed in this electronic communication do not necessarily reflect official policy of St Paul's Girls' School.

If you are not the intended recipient of this document or any part then please:

1) : inform the sender at the above address
2) : delete this e-mail immediately
3) : do not take copies nor disclose the contents of this document to anyone

PUPILS' COMMUNICATIONS
Only Senior School pupils of St Paul's Girls' School are permitted to send electronic mail and then only via our controlled system.
It is contrary to school rules for any other pupil to do so and they are regularly reminded of this fact.

VIRUS PROTECTION
All electronic mail traffic sent from this establishment is monitored and scanned for viruses prior to sending.





>>>> 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
Wed, 25 Feb 2004 10:39:42 +0000
"Paul Simpson" <Paul.Simpson@spgs.org>
Re: Why does app fail?
Just a couple of notes:

Make sure that you are using the latest available
version of the ODBC driver.  You can get the latest
snapshot of the .dll from Hiroshi's page:

http://www.geocities.jp/inocchichichi/psqlodbc/

There was discussion of, and agreement in principle
to, a user setting "foldtoupper", which would take
care of your problem, and all similar ones.  But
apparently that has not been picked up by anyone.  See
the following:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=15001.1027109813%40sss.pgh.pa.us&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DISO-8859-1%26q%3Dfoldtoupper%26btnG%3DGoogle%2BSearch%26meta%3Dgroup%253Dcomp.databases.postgresql.*

I am thinking that providing this option would be
important if we want to encourage more people to port
their apps from other RDBMS's.  But I am not
comptetent to contribute to that, so this is all I
will say about it.


--- Paul Simpson <Paul.Simpson@spgs.org> wrote:
> 
> 
> >>>> 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
> 
> 
> 
> 
> ABOUT THIS E-MAIL
> The information contained within this e-mail is
> privileged, confidential and protected from
> disclosure.
> 
> Any opinions expressed in this electronic
> communication do not necessarily reflect official
> policy of St Paul's Girls' School.
> 
> If you are not the intended recipient of this
> document or any part then please:
> 
> 1) : inform the sender at the above address
> 2) : delete this e-mail immediately
> 3) : do not take copies nor disclose the contents of
> this document to anyone
> 
> PUPILS' COMMUNICATIONS
> Only Senior School pupils of St Paul's Girls' School
> are permitted to send electronic mail and then only
> via our controlled system.
> It is contrary to school rules for any other pupil
> to do so and they are regularly reminded of this
> fact.
> 
> VIRUS PROTECTION
> All electronic mail traffic sent from this
> establishment is monitored and scanned for viruses
> prior to sending.
> 


__________________________________
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools

Wed, 25 Feb 2004 06:40:41 -0800 (PST)
Jeff Eckermann <jeff_eckermann@yahoo.com>
Re: Why does app fail?