Re: SET NULL on NOT NULL field

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SET NULL on NOT NULL field
Date: 2003-01-28 04:49:27
Message-ID: 10766.1043729367@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:
> I just noticed you can do this:
> create table blah (
> a not null references test on delete set null
> )

> Should that be prevented?

It already does. Or did you mean disallow the declaration? I can't see
anything in SQL92 that recommends disallowing the declaration.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-01-28 05:03:38 Re: SET NULL on NOT NULL field
Previous Message Bruce Momjian 2003-01-28 04:24:55 Re: Client failure allows backed to continue