Re: BUG #2144: Domain NOT NULL constraints ignored in rules - Mailing list pgsql-bugs

"John Supplee" <john@supplee.com> writes:
> Description:        Domain NOT NULL constraints ignored in rules

Works for me:

regression=# create domain dint as int not null;
CREATE DOMAIN
regression=# create table t1 (f1 dint);
CREATE TABLE
regression=# create view v1 as select * from t1;
CREATE VIEW
regression=# create rule r1 as on insert to v1 do instead
regression-# insert into t1 values(new.f1);
CREATE RULE
regression=# insert into v1 values(1);
INSERT 0 1
regression=# insert into v1 values(null);
ERROR:  domain dint does not allow null values
regression=#

How about a test case?

            regards, tom lane