Re: Editing problem for bool fields with not null

Vladimir Kokovic wrote:
> Hi,
> 
> I've tried to edit BOOL NOT NULL field which have value TRUE within
> 'Edit Data' window,
> but error dialog appeared with text
> "ERROR: null value in column "vazeci" violates not-null constraint"
> even field has DEFAULT TRUE clause !

The boolean editor in the grid uses a tri-state control which can select
TRUE, FALSE and NULL. If you set it to NULL as it sounds you have, it
will attempt to explicitly update the value to NULL which Postgres will
reject in your case because of the NOT NULL clause.

Note that Postgres will only use the default value for an INSERT which
doesn't specify a value for the column, or for an INSERT or UPDATE when
the column value is specified as the keyword DEFAULT (which is not
possible in the Edit Grid).

Regards, Dave.