[Geoserver-devel] [JIRA] (GEOS-7790) Support for Postgres citext columns in SQLViews

david mcquillan created an issue

GeoServer / ImprovementGEOS-7790

Support for Postgres citext columns in SQLViews

Issue Type:

ImprovementImprovement

Affects Versions:

2.9.1, 2.9.0

Assignee:

Unassigned

Components:

PostGIS

Created:

07/Oct/16 8:19 PM

Environment:

Windows server 2012
tomcat 8
oracle java 8

Labels:

geoserver postgis citext

Priority:

MediumMedium

Reporter:

david mcquillan

Geoserver SQL views do not support citext column fields.

Has been tested with same data when citext sql view does not see column, when converted to text column, sql view sees column.

Symptom was noticed where a layer was styled by citext attribute, after adding to sql view layer does not display as style depends on the column citext

I notice that citext support was added to geotools in GeoToolsGEOT-4713

but it seems hasnt made it to SQL views yet

Thanks guys for the hard work.

Add Comment

Add Comment

This message was sent by Atlassian JIRA (v1000.383.2#100014-sha1:783d425)

Atlassian logo