[Geoserver-devel] [jira] (GEOS-6386) Problems with SQL-Views in PostGIS

_Failed_to_Retrieve · March 9, 2014, 12:32pm

Christian Vogt created an issue

Issue Type:	Bug
Affects Versions:	2.5-RC2
Assignee:	Andrea Aime
Components:	PostGIS
Created:	09/Mar/14 7:31 AM
Environment:	Windows 7 64 bit, PostgreSQL 9.2
Priority:	Major
Reporter:	Christian Vogt

I encountered some problems when using SQL-views with geoserver 2.5 RC2. First I created a simple SQL-View: “select * from …”.
When trying to access this view-based layer with a filter like “geom intersects POLYGON ((…” the following error is raised:
“org.postgresql.util.PSQLException: Operation on mixed SRID geometries”.

This always happens when trying to select features with the “old” GetFeatureInfo-Method (disabling the VectorRenderingLayerIdentifier and using the VectorBasicLayerIdentifier)!
I have written some other OWS-operatiions which filter a SQL-view and get the same error message. In geoserver-versions < 2.5 this code worked against the same PostGIS-Database. Could this be a geotools-problem?

Add Comment

This message was sent by Atlassian JIRA (v6.1.6#6162-sha1:7af547c)