Re: how is that possible - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: how is that possible
Date
Msg-id 20060210144551.GB6650@surnet.cl
Whole thread Raw
In response to how is that possible  (ohp@pyrenet.fr)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: ohp@pyrenet.fr
Date:
Subject: how is that possible
Next
From: Stephan Szabo
Date:
Subject: Re: how is that possible