Postgres Pro
Downloads
Home   >   mailing lists

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

From Christopher Kings-Lynne
Subject SET NULL on NOT NULL field
Date
Msg-id GNELIHDDFBOCMGBFGEFOMEDKCFAA.chriskl@familyhealth.com.au
Whole thread Raw
Responses Re: SET NULL on NOT NULL field  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: SET NULL on NOT NULL field  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Justin Clift
Date:
Subject: Re: Win32 port patches submitted
Next
From: Tom Lane
Date:
Subject: Re: Client failure allows backed to continue