Re: [HACKERS] SET NULL on NOT NULL field

2003-01-28 Thread Bruno Wolff III
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

Re: [HACKERS] SET NULL on NOT NULL field

2003-01-28 Thread Stephan Szabo
On Tue, 28 Jan 2003, Bruno Wolff III wrote: 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

Re: [HACKERS] SET NULL on NOT NULL field

2003-01-28 Thread Christopher Kings-Lynne
Christopher Kings-Lynne [EMAIL PROTECTED] 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

[HACKERS] SET NULL on NOT NULL field

2003-01-27 Thread Christopher Kings-Lynne
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 ---(end of broadcast)--- TIP 2: you can get off all lists

Re: [HACKERS] SET NULL on NOT NULL field

2003-01-27 Thread Stephan Szabo
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

Re: [HACKERS] SET NULL on NOT NULL field

2003-01-27 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] 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