Re: SET NULL on NOT NULL field

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
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 05:23:01
Message-ID: 20030127212113.A87170-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2003-01-28 05:23:32 Re: interactive docs error
Previous Message Bruce Momjian 2003-01-28 05:22:12 Re: [PATCHES] IPv6 Support for INET/CIDR types. (fwd)