On Oct 9, 2012, at 7:51 AM, Rahkonen Jukka <[email protected]> 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 > [email protected] > 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 _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
