Omnis Postgres No nulls puzzle

Mike Rowan michael.rowan3 at
Sun Jun 12 22:43:31 UTC 2022

Morning all,
An example of a column definition in one of my tables in PG 14 .

prename text COLLATE pg_catalog."default" NOT NULL DEFAULT ''::text,
(thats two single quotes after DEFAULT)

I am no expert with PostgreSQL but this says to me :
"When this table is inserted or updated, check that this column is NOT NULL
and, if it is, set it to EMPTY."
Such inserts or updates are rejected due to null value in that column

Can someone on this friendly Omnis list please tell me how I am wrong?
Thanks as always.

More information about the omnisdev-en mailing list