Support for Postgres citext columns in SQLViews

Description

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.

Environment

Windows server 2012
tomcat 8
oracle java 8
postgres 9.4
64bit all

Status

Assignee

Unassigned

Reporter

David McQuillan

Triage

None

Fix versions

None

Affects versions

Components

Priority

Medium
Configure