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
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
