View Issue Details

IDProjectCategoryView StatusLast Update
0003846SymmetricDSBugpublic2019-02-11 16:28
ReporterelongAssigned Toelong 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.8.42 
Target Version3.8.42Fixed in Version3.8.42 
Summary0003846: 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.
TagsNo tags attached.

Relationships

related to 0003851 closedelong Postgres error column type tsvector but expression is of type character varying 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 d74aee9f

2019-01-08 08:09:43

admin

Details Diff
0003846: Postgres error column type tsvector but expression is of type
character varying

0003846
mod - symmetric-db/src/main/java/org/jumpmind/db/model/TypeMap.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDmlStatement.java Diff File

SymmetricDS: 3.10 302f952d

2019-01-08 08:09:43

admin

Details Diff
0003846: Postgres error column type tsvector but expression is of type
character varying

0003846
mod - symmetric-db/src/main/java/org/jumpmind/db/model/TypeMap.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDmlStatement.java Diff File

SymmetricDS: 3.9 f7af4c87

2019-01-08 08:09:43

admin

Details Diff
0003846: Postgres error column type tsvector but expression is of type
character varying

0003846
mod - symmetric-db/src/main/java/org/jumpmind/db/model/TypeMap.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDmlStatement.java Diff File

SymmetricDS: 3.9 ac0cbebc

2019-01-08 08:09:43

admin

Details Diff
0003846: Postgres error column type tsvector but expression is of type
character varying

0003846

Issue History

Date Modified Username Field Change
2019-01-03 14:45 elong New Issue
2019-01-03 14:45 elong Status new => assigned
2019-01-03 14:45 elong Assigned To => elong
2019-01-08 08:10 elong Status assigned => resolved
2019-01-08 08:10 elong Resolution open => fixed
2019-01-08 08:10 elong Fixed in Version => 3.8.42
2019-01-08 09:00 admin Changeset attached => SymmetricDS 3.8 d74aee9f
2019-01-08 09:00 admin Changeset attached => SymmetricDS 3.10 302f952d
2019-01-08 16:22 elong Relationship added related to 0003851
2019-01-08 17:00 admin Changeset attached => SymmetricDS 3.9 f7af4c87
2019-01-09 14:00 admin Changeset attached => SymmetricDS 3.9 ac0cbebc
2019-02-11 16:28 admin Status resolved => closed