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

Christian Vogt created an issue

GeoServer / BugGEOS-6386

Problems with SQL-Views in PostGIS

Issue Type:

BugBug

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:

MajorMajor

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

Add Comment

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

Atlassian logo