Re: Why does app fail? - Mailing list pgsql-general

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?

 

Paul

>>> Jeff Eckermann <jeff_eckermann@yahoo.com> 25/02/2004 14:40:41 >>>
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