Hi,
I want to publish a layer using SQL view, it gives me this error: ERREUR: erreur de syntaxe sur ou près de « ; » Position : 255 this is the SQL: select nom_province , sum(nombre_2004), code_province from province, commune, commune_maladie where code_province = province and commune_maladie.code_commune = commune.code_commune and id_maladie = 1 group by nom_province , code_province ; I tested it in postgesSQL/PostGis i get the result, so the sql query works in it. but not in geoserver 2.1.0 thanks for the help -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/SQL-View-geoserver-2-1-0-error-but-works-in-postgis-tp6407789p6407789.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
