Bulk History import feature sometimes results in ERROR about pg_gather

[jobinau]

A case analysis shows that the line contains an SQL statement with regular expression.
For example
work_order.extension_data->>'XCount')~E'\\d+(\\. ...

[jobinau]

Matching dot (.) in sed is unexpectedly very complex and found that it is not working as expected
https://www.unix.com/unix-for-dummies-questions-and-answers/21611-how-can-i-match-actual-dot-using-sed.html
Manytimes workarounds using Perl is suggested instead of Sed

[jobinau]

It can be confirmed that the logic of line substitution

/^COPY\|\\\./! s/\(.*\)/'"$coll_ts"\\t'\1/g

Won't work with Sed if there is regular expression involving \. is already present in the line

[jobinau]

Sed expression is reworked to avoid line replacement, instead used the logic of insertion of the timestamp to the beginning of the line. Fixed with following commit
136be5e