Re: SET NULL on NOT NULL field

On Mon, Jan 27, 2003 at 21:23:01 -0800, Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:
> 
> On Tue, 28 Jan 2003, Christopher Kings-Lynne wrote:
> 
> > I just noticed you can do this:
> >
> > create table blah (
> >     a not null references test on delete set null
> > )
> >
> > Should that be prevented?  It shouldn't be too hard to test for really...
> 
> Maybe, although I don't think the spec prevents it.  In practice
> I'd guess it ends up being a more expensive way of saying no action.

No. You end up not being able to delete the referenced keys. I tested
this in 7.3 and you get the following message when you try it:
ERROR:  ExecUpdate: Fail to add null value in not null attribute col1