During my test run of PostgreSQL persistence I've noticed that it's broken. Problem exists when there is an update of process payload during instance life.

Insertion of process instance seems to work fine:

2021-06-11 14:01:16 UTC [183] LOG: duration: 1.043 ms execute <unnamed>: INSERT INTO process_instances (id, payload, process_id) VALUES ($1, $2, $3)
2021-06-11 14:01:16 UTC [183] DETAIL: parameters: $1 = 'b0ac44e3-efab-45fa-b29d-de7610ab2e25', $2 = '\xSOMEHEXCONTENTHERE', $3 = 'SubProcessId'

Then while trying to update payload an error is generated due to unexpected "end bracket" sign at the end:

2021-06-11 14:01:16 UTC [184] ERROR: syntax error at or near ")" at character 56
2021-06-11 14:01:16 UTC [184] STATEMENT: UPDATE process_instances SET payload = $1 WHERE id = $2)