Re: SET NULL on NOT NULL field

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> I just noticed you can do this:
> create table blah (
>     a not null references test on delete set null
> )

> Should that be prevented?

It already does.  Or did you mean disallow the declaration?  I can't see
anything in SQL92 that recommends disallowing the declaration.
        regards, tom lane