Re: how is that possible

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.