When I empty the input of a jsonb field, I want it to set to null.
The field is nullable in both forest conf and in DB.
The field reverts to the previous value once I hit save. I get the success message telling that the entry has been saved.
The CREATE works well when I leave the input blank : the field will be set to null.
Error is only occuring on an UPDATE for me when the field has been set to some value and then I want to set it back to null.
Also I can update the field to any other value and it will work, I just cannot set it to null.
When looking at the logs, I would be expecting and UPDATE statement, but I only get SELECT.
But no error.
Please provide any relevant information about your setup.
- Package Version: email@example.com
- Express Version: 4.17.1
- Sequelize Version: 5.15.2
- Database Dialect: node-postgres
- Database Version: 8.5.1
- Project Name: Greenly-Corporate