Mapserver, PostGIS and case

[Flavio Hendry]

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:flavio at tydac.ch
############         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 <rdmailings at DUIF.NET>
To: MAPSERVER-USERS at LISTS.UMN.EDU
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