PostGIS missing quotes for columns in queries

[jbirch]

You can see in this example that the column names are not being quoted properly in the SQL statements to preserve case:

DECLARE crsselcmd_8122f830936479525e7e775d958cd3e1 CURSOR FOR SELECT "public"."testtab".geom,"public"."testtab".geom_name,"public"."testtab".geom_description FROM "public"."testtab"

[mloskot]

I improved a little two functions responsible for quoting SQL names and values (r3318).

[mloskot]

Recently, Riccardo Vignotto has reported similar problems when using FDO PostGIS provider from GEOMAP GROUP website (​http://www.geomapgis.com/web/geomap-group/fdo/index.html):

I see that if you query like this 'SELECT colUMN FROM TaBLe' postgre convert the query to 'SELECT column FROM table'. But if you use double quotes like this 'SELECT "colUMN" FROM "TaBLe"' it does not lower the case of characters. From log files I see that you don’t use double quotes when querying the db. So this is my suggestion for the next versions of the FDO provider that you develop.

I've asked Riccardo to check if he uses a patched version (r3318) of the provider.

Riccardo, I've added your email to CC of this ticket to keep you notified about news. I hope you don't mind.

[gregboone]

Further PostGIS Provider development has been routed to the PostgreSQL Provider. Advise using that provider.