Hi,
Unfortunately, I have to live with an existing table PostgresSQL with TSVector field mapped to a java String in my Entity. When trying to do a simple insert I have got the following error:
ERROR 8725 — [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: column “searchable_idx” is of type tsvector but expression is of type character varying
Hint: You will need to rewrite or cast the expression.
Does anyone already did this? any hint?
Development environment:
IntelliJ Idea 2018.2.7
Java 8
JPA standard annotations (except for this TSVector stuff)
PostgresSQL 11