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

Activity

Show:
Andrea Aime
December 10, 2017, 1:55 PM

Closing all non bug report tickets that has seen no activity in the last year. If you are interested in this ticket we encourage you to re-open it only after securing the necessary development resources.
Please to read this guide to learn how to best deal with this type of requests: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

Assignee

Unassigned

Reporter

David McQuillan

Triage

None

Fix versions

None

Affects versions

Components

Priority

Medium
Configure