Hi Wappler team.
I am getting the above error. I have validated that the JSON i’m trying to insert into a JSONB column is indeed valid, and without error.
Any advice what I can look into?
UPDATE:
Looks like a known knex/node/postgres issue: https://github.com/brianc/node-postgres/issues/442
The reference you link to started on 16 Sep 2013
A person in the forum you referenced with a link 7 years later replied on 25 Aug 2020–
Another option is to make your column have a type of
jsonb[]rather thanjsonb.
Is your error returned in node-pg:?
Since you’ve only reported the concluding error return without including the actual Query you used –
Is this following page relevant to how you are writing your queries?
March 30, 2021
https://azatb.com/2021/03/30/postgresql-jsonb-datatype-and-functions-linux-hint/