SLD filter against Postgresql 8.3.+
-----------------------------------
Key: GEOS-2779
URL: http://jira.codehaus.org/browse/GEOS-2779
Project: GeoServer
Issue Type: Bug
Affects Versions: 1.7.3
Environment: Red Hat Linux, Apache Tomcat 5.5, Java 1.6
Reporter: Stefan Ziegler
Assignee: Andrea Aime
Attachments: db_dump.zip, geo_gemeinden.sld, shapes.zip
SLD filters (in this case PropertyIsNotEqual) are creating SQL statements that won't work against Postgresql 8.3.+
The query uses the Postgresql lower() function even with Integers which worked before Postgresql 8.3 (see: http://developer.postgresql.org/pgdocs/postgres/functions-string.html)
From catalina.out:
24 Mrz 15:17:55 ERROR [data.jdbc] - Error Performing SQL query: SELECT "ogc_fid", "bzrk_nr", encode(asBinary(force_2d("wkb_geometry"),'XDR'),'base64') FROM "public"."geo_gemeinden" WHERE ("wkb_geometry" && GeometryFromText('POLYGON ((573689.3996582031 199049.72729492188, 573689.3996582031 275985.3977050781, 663634.6003417969 275985.3977050781, 663634.6003417969 199049.72729492188, 573689.3996582031 199049.72729492188))', -1) AND (lower("bzrk_nr") != lower(1105) AND lower("bzrk_nr") != lower(1102)))
org.postgresql.util.PSQLException: ERROR: function lower(integer) does not exist
Attached: database table dump (plus shapefiles) and a SLD file.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira