I ran into this issue with a linked Postgres table. The table is quite simple, it has a primary key and a boolean column with a not-null constraint (and a default value).
If I try to update this column in Manifold 9.0.193, either through the GUI or with an update statement, I get this error in the database log:
ERROR: null value in column "mycolumn" of relation "mytable" violates not-null constraint
DETAIL: Failing row contains (1, null).
STATEMENT: UPDATE "public"."mytable" SET "mycolumn"=$1 WHERE "id"=$2
This happens whether I connect as superuser, or a different account.
It looks like Manifold is attempting to set the column to null first, which fails.
Am I doing something wrong? Can I do this differently?
I know I can write a native SQL query, but sometimes it's nice just to edit a field interactively.