[mapserver-users] WFS fails is PostGIS table has capital characters in the name

Thu Dec 15 04:15:02 PST 2011

Jukka,

Does it work if you quote the name? In Oracle, if you have mixed case
table names, then those table names have to be quoted.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center

On 12/15/11 12:29 AM, "Rahkonen Jukka" <Jukka.Rahkonen at mmmtike.fi> wrote:

>Hi,
>
>It seems that Mapserver WFS fails if the PostGIS source table has
>capitalised characters in the name. For example with table named
>Natura2000_Suomi_2010 the DescibeFeatureType fails and error suggests
>that Mapserver is usin table name
>"natura2000_suomi_2010" in the query instead.
>
>[Thu Dec 15 07:22:38 2011].109270 msPostGISLayerGetItems(): Query error.
>Error (ERROR:  relation "natura2000_suomi_2010" does not exist
>LINE 1: select * from Natura2000_Suomi_2010 where false limit 0
>
>My Mapserver version is 6.0.1 on Ubuntu Linux.
>
>-Jukka Rahkonen-
>_______________________________________________
>mapserver-users mailing list
>mapserver-users at lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/mapserver-users