Uppercase chars in table names will also cause trouble, avoid them. 2012/10/9 Puneet Kishor <[email protected]>
> > > 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 >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
