Re: [GENERAL] on cascade set null works on not null columns

2004-01-26 Thread Bruce Momjian
Baldur Norddahl wrote: > Hi, > > I just noticed that I could do this: > > webshop=# create table foo (bar text not null primary key); > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey" for > table "foo" > CREATE TABLE > webshop=# create table foo2 (bar text not null, fore

[GENERAL] on cascade set null works on not null columns

2004-01-24 Thread Baldur Norddahl
Hi, I just noticed that I could do this: webshop=# create table foo (bar text not null primary key); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey" for table "foo" CREATE TABLE webshop=# create table foo2 (bar text not null, foreign key (bar) references foo(bar) on upda