Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

2pack: support export from normal string column to text long string column

Description

postgresql support well long string. so i modify some column (sql command) to long string.

now when i export 2pack from old (or pure) instance it will import empty to this column.
reason: it treatment column like blob, so try to read from binary.
solution: check if have text value, set like text, other treatment like blob

Environment

None

Attachments

3
  • 20 Nov 2018, 10:21 AM
  • 22 Oct 2017, 12:22 PM
  • 29 Sep 2017, 01:55 AM

Activity

Show:

Hiep Lq July 19, 2020 at 4:40 AM

yeb for same column
one instance use short string type (example string, text)
other instance use long string type (text long)

Heng Sin Low July 19, 2020 at 12:29 AM

Hi , so the use case here is the source and target is using different text data type ? if yes, what are the data type involve ?

Hiep Lq February 12, 2020 at 6:15 PM

will test and fix issue on your latest command

Hiep Lq November 20, 2018 at 10:22 AM

correct case string value is "acb|cdf" will wrong detect as blobs

Carlos Ruiz November 14, 2018 at 8:26 PM

Found that commit 1031d73 still had an issue and it was not working fine.

Fixed in 6.1 with commit 9c91b54

Also, noticed the opposite case is also broken - this is: in case a 2pack is generated on a system with a blob column, and then imported in a system where that column is string, the import leaves wrong data. Maybe could be worthy to fix that possibility also?

Regards,

Carlos Ruiz

Fixed

Details

Assignee

Reporter

Labels

Components

Fix versions

Priority

Created September 29, 2017 at 1:53 AM
Updated July 1, 2021 at 12:11 PM
Resolved May 4, 2021 at 3:02 PM