[Tilecache] postGis table problem

[Walter Lorenzetti]

Hi All,

I've a problem with a postgis layer

my .cfg declaration:

[pglayer]
type=PostGIS
dsn=host=localhost dbname=mydbname user=myuser password=mypassword
layer=mytable
fid=gid
geometry=the_geom

when I try:

http://localhost/webgis/fs/featureserver.cgi/pglayer?maxfeature=1

I obtain the seguent error:

An error occurred: syntax error at or near "to"
LINE 1: SELECT AsText(the_geom # defaults to the_geom) as fs_text_ge...
                                          ^

  File "/var/www/webgis/fs/FeatureServer/Server.py", line 298, in cgiHandler
    format, content = service.dispatchRequest( params, path_info, host, post_data, request_method, accepts )
  File "/var/www/webgis/fs/FeatureServer/Server.py", line 145, in dispatchRequest
    result = method(action)
  File "/var/www/webgis/fs/FeatureServer/DataSource/PostGIS.py", line 203, in select
    cursor.execute(str(sql), attrs)

I don't understand where is the problem

someone can help me?

Thanks in advance

Walter



-- 
Please no  .doc, .xls, .ppt, .dwg:
https://www.faunalia.it/dokuwiki/doku.php?id=public:OpenFormats

Walter Lorenzetti
email+jabber: lorenzetti at faunalia.it
www.faunalia.it
Cell: (+39) 347-6597931  Tel+Fax: (+39) 0587-213742
Piazza Garibaldi 5 - 56025 Pontedera (PI), Italy