hi richard had the same problems ... seem not to like uppercase or mixed case in table names at all. if you use lower case for your table names in postgres it should do it without all the quotes stuff ...
Mit freundlichem Gruss / Best Regards Flavio Hendry ---------------------------------------------------------------- TYDAC Web-Site: http://www.tydac.ch TYDAC MapServer: http://www.mapserver.ch ---------------------------------------------------------------- ############ Mit freundlichen Gruessen / Kind Regards ############ mailto:[EMAIL PROTECTED] ############ TYDAC AG - http://www.tydac.ch #### #### Geographic Information Solutions #### #### Luternauweg 12 -- CH-3006 Bern ############ Tel +41 (0)31 368 0180 - Fax +41 (0)31 368 1860 ---------------------------------------------------------------- -----Original Message----- From: Richard Duivenvoorde <[EMAIL PROTECTED]> To: [email protected] Date: Fri, 9 Mar 2007 19:39:42 +0100 Subject: [UMN_MAPSERVER-USERS] Mapserver, PostGIS and case > Hi List, > > I've found some other postings about it. But think I've encountered a > bug or otherwise some non-logical behaviour. > > I changed a PostGIS table with a geomety column name the_geom to > LOCATIE. > > CREATE TABLE "POINTLAYER" > ( > ... > "LOCATIE" geometry NOT NULL, > ... > > After some fiddling (reading the postgresql help on 'Identifiers and > Key > Words' and the mapserver list etc) around I was able to show a MAP > using > the following DATA string in the mapfile: > > DATA '"LOCATIE" FROM (select *, oid from "public"."POINTLAYER") > as > foo using unique oid using SRID=28992' > > But the featureinfo requests keep failing then with an mapserver > error: > > Fri Mar 09 19:23:53 2007 - msPOSTGISLayerGetItems(): Query error. > msPOSTGISLayerGetItems: tried to find the geometry column in the > results > from the database, but couldnt find it. Is it miss-capitialized? > '"LOCATIE"' > > After changing the column name LOCATIE to locatie: > > CREATE TABLE "POINTLAYER" > ( > ... > locatie geometry NOT NULL, > ... > and datastring: > > DATA '"locatie" FROM (select *, oid from "public"."POINTLAYER") as > foo > using unique oid using SRID=28992' > > produces a map, but NO featureresponse, but errors: > > msPOSTGISLayerGetItems: tried to find the geometry column in the > results > from the database, but couldnt find it. Is it miss-capitialized? > '"locatie"' > > changing the DATA-string to: > > DATA 'locatie FROM (select *, oid from "public"."POINTLAYER") as foo > using unique oid using SRID=28992' > > is producing both a map and a featureinfo response :-) > > It looks like there is some fiddling around with double quotes in the > mapserver code, but it looks like the mapping part and featureinfo > part > are working in different ways with quotes? > > So, it's working for me now, but I thought that it may be helpfull to > others to read this. Should I post a bug for this? > > Richard
