View Issue Details

IDProjectCategoryView StatusLast Update
0003851SymmetricDSBugpublic2019-01-08 16:25
ReporterelongAssigned Toelong 
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.9.0 
Target Version3.9.17Fixed in Version3.9.17 
Summary0003851: Postgres error column type tsvector but expression is of type character varying
DescriptionOn Postgres, a column of type TSVECTOR will capture and send, but it can receive an error during load:

2019-01-03 15:57:55,643 ERROR [server] [AcknowledgeService] The outgoing batch 100 failed: ERROR: column "textsearch" is of type tsvector but expression is of type character varying
Hint: You will need to rewrite or cast the expression.

Appears to work on some versions of Postgres and JDBC driver, but not others.

Relationships

related to 0003846 resolvedelong Postgres error column type tsvector but expression is of type character varying 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-01-08 16:22 elong New Issue
2019-01-08 16:22 elong Status new => assigned
2019-01-08 16:22 elong Assigned To => elong
2019-01-08 16:22 elong Relationship added related to 0003846
2019-01-08 16:24 elong Status assigned => resolved
2019-01-08 16:24 elong Resolution open => fixed
2019-01-08 16:24 elong Fixed in Version => 3.9.17
2019-01-08 16:25 elong Summary 0003846: Postgres error column type tsvector but expression is of type character varying => Postgres error column type tsvector but expression is of type character varying