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

Activity

Show:
Carlos Ruiz
November 14, 2018, 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

Hiep Lq
November 20, 2018, 10:22 AM

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

Hiep Lq
February 12, 2020, 6:15 PM

will test and fix issue on your latest command

Heng Sin Low
July 19, 2020, 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
July 19, 2020, 4:40 AM

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

Assignee

Hiep Lq

Reporter

Hiep Lq

Labels

Tested By

None

Components

Priority

Major
Configure