You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We are receiving a invalid input syntax for type json error when inserting a string value into a JSONB column on PGSQL using upsertGraph with a payload like: { jsonField: "value" }
Similar to this comment here it seems that if a plain string is used as a value for a JSONB column on PGSQL an error is generated even if the property is in jsonAttributes
To work around this we can do something like this which works but it would be nice to know if there is a supported way or if we are missing something obvious
$beforeInsert() { if (this.jsonField) { this.jsonField = JSON.stringify(this.jsonField); } }
Thanks for building such an awesome orm. Let me know if you need more details or more detailed steps to repeat.
benvd, omidh28, SquidEpps and lorenzopicolilorenzopicoliDeanZhou9 and Warkanlock