Thread: Case sensitivity
I am evaluating whether it is possible to migrate our Contact manager system to Postgres on Linux, but I am having difficulty because the client software was most moronically programmed to access tables using wildly different case structures, i.e. a table might be created 'MYTABLE', and accessed 'mytable', 'MyTable' or 'MYTABLE' depending on the context. Is there anyway to disable case-sensitivity in this case, either through Postgres config, or the ODBC drivers? I have no access to re-configure the clients, due to their wonderfully closed sourcedness. Thanks Dana Powers
> I am evaluating whether it is possible to migrate our Contact manager > system to Postgres on Linux, but I am having difficulty because the > client software was most moronically programmed to access tables using > wildly different case structures, i.e. a table might be created > 'MYTABLE', and accessed 'mytable', 'MyTable' or 'MYTABLE' depending on > the context. Is there anyway to disable case-sensitivity in this case, > either through Postgres config, or the ODBC drivers? I have no access to We have no trouble accessing tables with different case. TABLE, Table, table and taBLe are all the same to us, unless you put the table name in double-quotes. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
> > I am evaluating whether it is possible to migrate our Contact manager > > system to Postgres on Linux, but I am having difficulty because the > > client software was most moronically programmed to access tables using > > wildly different case structures, i.e. a table might be created > > 'MYTABLE', and accessed 'mytable', 'MyTable' or 'MYTABLE' depending on > > the context. Is there anyway to disable case-sensitivity in this case, > > either through Postgres config, or the ODBC drivers? I have no access to > > We have no trouble accessing tables with different case. TABLE, Table, > table and taBLe are all the same to us, unless you put the table name in > double-quotes. The problem is, if you create a table without "", the table name defaults to lower case, and all non ""ed references to the table also default to all lower case but if you create a table with ""s you cannot access it unless you specify all references to it also in ""s. My question is, is there anyway to nullify the "" behavior and set all tables to lowercase? Dana Powers powersdp@ctrvax.vanderbilt.edu
> > > I am evaluating whether it is possible to migrate our Contact manager > > > system to Postgres on Linux, but I am having difficulty because the > > > client software was most moronically programmed to access tables using > > > wildly different case structures, i.e. a table might be created > > > 'MYTABLE', and accessed 'mytable', 'MyTable' or 'MYTABLE' depending on > > > the context. Is there anyway to disable case-sensitivity in this case, > > > either through Postgres config, or the ODBC drivers? I have no access to > > > > We have no trouble accessing tables with different case. TABLE, Table, > > table and taBLe are all the same to us, unless you put the table name in > > double-quotes. > > The problem is, if you create a table without "", the table name > defaults to lower case, and all non ""ed references to the table also > default to all lower case but if you create a table with ""s you cannot > access it unless you specify all references to it also in ""s. My > question is, is there anyway to nullify the "" behavior and set all > tables to lowercase? So you are creating with quotes, but want to access it without quotes? Can't do that. Why not just remove the quotes from the queries? I suppose you could hack out the quote stuff to force everything to lowercase, even if it has quotes. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Bruce Momjian wrote: > > > > > I am evaluating whether it is possible to migrate our Contact manager > > > > system to Postgres on Linux, but I am having difficulty because the > > > > client software was most moronically programmed to access tables using > > The problem is, if you create a table without "", the table name > > defaults to lower case, and all non ""ed references to the table also > > default to all lower case but if you create a table with ""s you cannot > > access it unless you specify all references to it also in ""s. My > > question is, is there anyway to nullify the "" behavior and set all > > tables to lowercase? > > So you are creating with quotes, but want to access it without quotes? > Can't do that. Why not just remove the quotes from the queries? I > suppose you could hack out the quote stuff to force everything to > lowercase, even if it has quotes. > Problem is, I don't have control over the client queries. Third party closed source contact manager. So I guess I'll try to hack something together. Thanks Bruce Dana
Just a suggestion, but if you have or are a C programmer, you could edit the part of Postgres that receives queries to convert everything it receives to lower case. Might slow things down a bit, but it should solve your problem. Alternatively, you could do the same thing to the ODBC driver, which might be a bit easier and have less of a performance impact. At 02:04 PM 9/20/99, Dana Powers wrote: >Bruce Momjian wrote: >> >> > > > I am evaluating whether it is possible to migrate our Contact manager >> > > > system to Postgres on Linux, but I am having difficulty because the >> > > > client software was most moronically programmed to access tables using >> > The problem is, if you create a table without "", the table name >> > defaults to lower case, and all non ""ed references to the table also >> > default to all lower case but if you create a table with ""s you cannot >> > access it unless you specify all references to it also in ""s. My >> > question is, is there anyway to nullify the "" behavior and set all >> > tables to lowercase? >> >> So you are creating with quotes, but want to access it without quotes? >> Can't do that. Why not just remove the quotes from the queries? I >> suppose you could hack out the quote stuff to force everything to >> lowercase, even if it has quotes. >> >Problem is, I don't have control over the client queries. Third party >closed source contact manager. So I guess I'll try to hack something >together. Thanks Bruce >Dana > >************ >