[
http://jira.codehaus.org/browse/GEOS-2779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrea Aime reopened GEOS-2779:
-------------------------------
Reopen to assign the fix-for field
> 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
> Fix For: 1.7.4
>
> 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
