Re: [HACKERS] I thought this was picked up ages ago?

> What I was trying to do was attempt to get MapInfo to use postgresql for
> storing tables using ODBC. For it to work it needs a table called
> MAPINFO_MAPCATALOG. The problem is the table/column name case. It sends
> the following query which fails:
> SELECT "SPATIALTYPE", "TABLENAME", "OWNERNAME", "SPATIALCOLUMN",
> "DB_X_LL2, "DB_Y_LL", "DB_X_UR", "DB_Y_UR", "COORDINATESYSTEM", "SYMBOL",
> "XCOLUMNNAME", "YCOLUMNNAME" FROM "MAPINFO_MAPCATALOG" WHERE TABLENAME =
> 'wds';
> Obviously it's missing the "" from the where clause...

That's interesting. It's inconsistant SQL, but would work on most
systems because they tend to convert unquoted names to upper case
internally, whereas Postgres converts them to lower case.

- Thomas

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California