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