Re: Why does app fail? - Mailing list pgsql-general
From | Jeff Eckermann |
---|---|
Subject | Re: Why does app fail? |
Date | |
Msg-id | 20040225144041.87202.qmail@web20809.mail.yahoo.com Whole thread Raw |
In response to | Re: Why does app fail? ("Paul Simpson" <Paul.Simpson@spgs.org>) |
List | pgsql-general |
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
pgsql-general by date: