View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003846 | SymmetricDS | Bug | public | 2019-01-03 19:45 | 2019-02-11 21:28 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.42 | ||||
| Target Version | 3.8.42 | Fixed in Version | 3.8.42 | ||
| Summary | 0003846: Postgres error column type tsvector but expression is of type character varying | ||||
| Description | On 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. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.8 d74aee9f 2019-01-08 08:09:43 Details Diff |
0003846: Postgres error column type tsvector but expression is of type character varying |
Affected Issues 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 Details Diff |
0003846: Postgres error column type tsvector but expression is of type character varying |
Affected Issues 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 Details Diff |
0003846: Postgres error column type tsvector but expression is of type character varying |
Affected Issues 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 Details Diff |
0003846: Postgres error column type tsvector but expression is of type character varying |
Affected Issues 0003846 |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-01-03 19:45 | elong | New Issue | |
| 2019-01-03 19:45 | elong | Status | new => assigned |
| 2019-01-03 19:45 | elong | Assigned To | => elong |
| 2019-01-08 13:10 | elong | Status | assigned => resolved |
| 2019-01-08 13:10 | elong | Resolution | open => fixed |
| 2019-01-08 13:10 | elong | Fixed in Version | => 3.8.42 |
| 2019-01-08 14:00 | admin | Changeset attached | => SymmetricDS 3.8 d74aee9f |
| 2019-01-08 14:00 | admin | Changeset attached | => SymmetricDS 3.10 302f952d |
| 2019-01-08 21:22 | elong | Relationship added | related to 0003851 |
| 2019-01-08 22:00 | admin | Changeset attached | => SymmetricDS 3.9 f7af4c87 |
| 2019-01-09 19:00 | admin | Changeset attached | => SymmetricDS 3.9 ac0cbebc |
| 2019-02-11 21:28 | admin | Status | resolved => closed |