"invalid message" when string contains NUL char code

[evgeni-k]

Expected behavior

be able to insert data

Actual behavior

"invalid message" error is thrown with error code 08P01

Steps to reproduce

String value contains following record
"value\0"

pgp.helpers.insert(values, columnsSet);

Environment

• Version of pg-promise: 10.5.1
• OS type (Linux/Windows/Mac): Mac
• Version of Node.js: 12.6

[vitaly-t]

It is strictly the driver issue. This library can't, and should not do anything about it.

In short, PostggreSQL treats \0 as the string termination. The only proper way to pass string data with zeros is as binary, i.e. as bytea, which then will use Buffer as input, which will be escaped correctly. But regular strings cannot contain zeros.