[mapserver-users] WFS fails if table name includes a dot character

[Puneet Kishor]

On Oct 9, 2012, at 7:51 AM, Rahkonen Jukka <Jukka.Rahkonen at mmmtike.fi> wrote:

> Hi,
> 
> It may be an odd idea to use dots in table/feature type names, but because I made such a test and faced a problem so I report it here.
> Source table is in PostGIS and its name is "dot.test".  WFS DescribeFeatureType leads to following error
> 
> [Tue Oct  9 10:56:02 2012].214191 msPostGISLayerGetItems(): Query error. Error
> (ERROR:  schema "dot" does not exist
> LINE 1: select * from dot.test where false limit 0
>                      ^
> ) executing SQL: select * from dot.test where false limit 0
> [Tue Oct  9 10:57:12 2012].923891 msPostGISLayerGetItems(): Query error. Error
> (ERROR:  schema "dot" does not exist
> LINE 1: select * from dot.test where false limit 0
>                      ^
> ) executing SQL: select * from dot.test where false limit 0
> 
> 
> -Jukka Rahkonen-
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users


If using non-standard characters, double quote the entity name. So, try

SELECT * FROM "dot.test" WHERE ...

To be completely unambiguous, prefix the schema name. So, if the table is in schema foo, try

SELECT * FROM "foo.dot.test" WHERE ...





--
Puneet Kishor