Re: SQL server application porting headache

Peter Darley wrote:
> Oskar,
> Instead of changing the application or changing PostgreSQL internals, can't
> you just change the table names to match the queries that are being used?
> Or is the app creating tables as it runs or something?
> Thanks,
> Peter Darley

No, since the application isn't consistent in its identifiers casing,
nor in its use of quotes. For example it issues the following
query:

SELECT "PassWord" FROM "Operators" WHERE Password='...';

There is no way PostgreSQL is gonna accept that without modifying
either PostgreSQL or the application, or possibly, as was suggested
elsewhere, make the ODBC driver lowercase every identifier, quoted
or not.

regards,
Oskar

--
/----------------------------------------------------------------------\
| Oskar Berggren beo(at)sgs(dot)o(dot)se |
| Network and Software Engineer SGS Datanätgrupp |
| Gothenburg, Sweden |
\----------------------------------------------------------------------/