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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
