gistfile1.txt

[local] eijebong@test_bug=# CREATE DOMAIN sql_identifier AS character varying;
CREATE DOMAIN
[local] eijebong@test_bug=# CREATE TABLE foo(a sql_identifier, b character varying not null);
CREATE TABLE
[local] eijebong@test_bug=# INSERT INTO foo(a, b) VALUES(NULL, NULL);
ERROR:  23502: null value in column "b" violates not-null constraint
DETAIL:  Failing row contains (null, null).
SCHEMA NAME:  public
TABLE NAME:  foo
COLUMN NAME:  b
LOCATION:  ExecConstraints, execMain.c:2008
[local] eijebong@test_bug=# INSERT INTO foo(a, b) VALUES(NULL, 'a');
INSERT 0 1