[
https://issues.apache.org/jira/browse/SIS-328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Martin Desruisseaux closed SIS-328.
-----------------------------------
> EPSG factory on PostgreSQL fails because of missing cast
> --------------------------------------------------------
>
> Key: SIS-328
> URL: https://issues.apache.org/jira/browse/SIS-328
> Project: Spatial Information Systems
> Issue Type: Bug
> Components: Referencing
> Affects Versions: 0.7
> Environment: PostgreSQL
> Reporter: Martin Desruisseaux
> Assignee: Martin Desruisseaux
> Fix For: 0.8
>
>
> The EPSG factory works as expected on Derby. But attempt to use the factory
> on PostgreSQL sometime produces the following error message:
> {noformat}
> ERROR: operator does not exist: epsg."CRS Kind" ~~ unknown
> SQL state: 42883
> Hint: No operator matches the given name and argument type(s). You might need
> to add explicit type casts.
> {noformat}
> The issue occurs in expressions like {{coord_ref_sys_kind LIKE 'projected%'}}
> with the {{coord_ref_sys_kind}} column defined as an enum when Apache SIS is
> using PostgreSQL. The fix is to cast the {{CRS Kind}} enum to
> {{VARCHAR(24)}}. The bug does not happen in Derby because that column is
> already a {{VARCHAR(24)}} since Derby does not support enums.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
