On Fri, 10 Feb 2006 ohp@pyrenet.fr wrote:
> After a typo, I've just noticed the following :
>
> ~ 14:58:33: createdb test
> CREATE DATABASE
> ~ 14:58:42: psql test
> Welcome to psql 8.1.2, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> 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
> );
> CREATE TABLE
> test=# insert into t2 values (default);
> INSERT 0 1
> test=# select * from t1;
> i
> ---
> (0 rows)
>
> test=# select * from t2;
> i
> ---
>
> (1 row)
>
> test=# \q
>
> should'nt the insert fail or have I mised something?
Why do you think it should have failed? It looks okay to me.