SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bytea
CONTEXT: unnamed portal parameter $5 = '...'
The payload contains an url. Upon json_encode, it will add backslashes to escape the uri i.e http:\/\/127.0.0.1:8080\/ which I guess somewhat invalid for bytea column. Removing the URL from the payload resolves the issue.
The payload contains an url. Upon
json_encode
, it will add backslashes to escape the uri i.ehttp:\/\/127.0.0.1:8080\/
which I guess somewhat invalid forbytea
column. Removing the URL from the payload resolves the issue.