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

[Cristiano Sumariva]

Uppercase chars in table names will also cause trouble, avoid them.

2012/10/9 Puneet Kishor <punk.kish at gmail.com>

>
>
> 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
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20121009/0224a754/attachment.html>