On Mon, Jan 27, 2003 at 21:23:01 -0800, Stephan Szabo <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html