Forgot to attach the error log:
21 Mrz 21:34:55 ERROR [data.jdbc] - Error Performing SQL query: SELECT “oid”, “art”, encode(asBinary(force_2d(“wkb_geometry”),‘XDR’),‘base64’) FROM “public”.“kva_av_bdbed” WHERE (“wkb_geometry” && GeometryFromText(‘POLYGON ((606159.7701284027 230239.6055220589, 606159.7701284027 230380.00552205893, 606348.9701284027 230380.00552205893, 606348.9701284027 230239.6055220589, 606159.7701284027 230239.6055220589))’, -1) AND ((“art” = 0 OR (“art” = 28 OR “art” = 30 OR “art” = 31)) OR lower(“art”) != lower(0)))
org.postgresql.util.PSQLException: ERROR: function lower(integer) does not exist
-----Ursprüngliche Nachricht-----
Von: Ziegler Stefan
Gesendet am: Sonntag, 22. März 2009 14:29
An: geoserver-users
Betreff: [Geoserver-users] problems with sld filter, postgresql 8.3 and geoserver 1.7.3Hi
I running into some problems upgrading our productive GeoServer (1.6) on our intranet server where we use Postresql 8.3.3. The resulting sql query looks like this:SELECT “oid”, “art”, encode(asBinary(force_2d(“wkb_geometry”),‘XDR’),‘base64’) FROM “public”.“kva_av_bdbed” WHERE (“wkb_geometry” && GeometryFromText(‘POLYGON ((606159.7701284027 230239.6055220589, 606159.7701284027 230380.00552205893, 606348.9701284027 230380.00552205893, 606348.9701284027 230239.6055220589, 606159.7701284027 230239.6055220589))’, -1) AND ((“art” = 0 OR (“art” = 28 OR “art” = 30 OR “art” = 31)) OR lower(“art”) != lower(0)))
The problem is the lower()-function which seems not to work with non-string values 1 with Postgresql 8.3 and onwards. Same query works with GeoServer 1.6 and Posgresql 8.3 because of the missing lower() functions calls in the query and GeoServer 1.7.3 and Posgresql 8.1.
regards
StefanMit freundlichem Gruss
Stefan Ziegler
Leiter AufsichtKanton Solothurn
Bau- und Justizdepartement
Amt für Geoinformation
Rötistrasse 4
4501 Solothurn
Telefon 032 627 75 96
Telefax 032 627 75 98
stefan.ziegler@anonymised.com
http://www.so.ch