ohp@pyrenet.fr wrote: > test=# create table t1 (i int primary key); > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "t1_pkey" for > table "t1" > CREATE TABLE > test=# create table t2 (i int references t2 1 on deley te cascade on > update cascade > );
The t2.i column is nullable. There is no bug here. Declare NOT NULL if that's what you want. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
