Hi. Same thing is when I save table in public schema or other schema. When I run: SELECT type FROM geometry_columns WHERE f_table_name = 'bus_stops' AND f_table_schema = 'topology'
I get Type character varying (30) POINT 2014-09-19 20:40 GMT+00:00 Salvatore Larosa <[email protected]>: > Hi, > > On Fri, Sep 19, 2014 at 9:15 PM, Mira Maric <[email protected]> wrote: >> Hi. I am using lizmap web client form editing layer bus_stops. >> Bus_stops layer is in Postgis database. I am import it to the database >> from the shapefile with SPIT plugin. > > Which QGIS and LizMapWC versions ? > >> >> When I try to edit layer with lizmap webclient I get next message: >> >> An error occured for : 'SELECT *, ST_AsText() AS astext FROM >> "topology"."bus_stops" WHERE ST_Intersects( >> ST_MakeEnvelope(429253.865738,5407067.308823,429265.809023,5407079.252109, >> 3857 ), ST_Transform(, 3857 ) )', the message:invalid query (ERROR: >> syntax error at or near "," > > What the following query returns?: > SELECT type FROM geometry_columns WHERE f_table_name = 'bus_stops' AND > f_table_schema = 'topology' > > Why the "bus_stops" table is into the topology schema? I would > recommend you to use a different schema > > Regards, > -SL > > -- > Salvatore Larosa > linkedIn: http://linkedin.com/in/larosasalvatore > twitter: @lrssvt > skype: s.larosa > IRC: lrssvt on freenode _______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
