SET NULL on NOT NULL field

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: SET NULL on NOT NULL field
Date: 2003-01-28 04:15:40
Message-ID: GNELIHDDFBOCMGBFGEFOMEDKCFAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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...

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-01-28 04:17:36 Re: Client failure allows backed to continue
Previous Message Justin Clift 2003-01-28 03:57:36 Re: Win32 port patches submitted