Re: SET NULL on NOT NULL field - Mailing list pgsql-hackers

From Stephan Szabo
Subject Re: SET NULL on NOT NULL field
Date
Msg-id 20030127212113.A87170-100000@megazone23.bigpanda.com
Whole thread Raw
In response to SET NULL on NOT NULL field  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: SET NULL on NOT NULL field  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-hackers
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.



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Client failure allows backed to continue
Next
From: "Marc G. Fournier"
Date:
Subject: Re: interactive docs error