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

Activity

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