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

From ohp@pyrenet.fr
Subject Re: how is that possible
Date
Msg-id Pine.UW2.4.53.0602101642290.15521@sun.pyrenet
Whole thread Raw
In response to Re: how is that possible  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: how is that possible
List pgsql-hackers
My understanding is that null or not, their should have been a foreign key
violation.

Maybe I misunderstood.
On Fri, 10 Feb 2006, Stephan Szabo wrote:

> Date: Fri, 10 Feb 2006 06:48:02 -0800 (PST)
> From: Stephan Szabo <sszabo@megazone.bigpanda.com>
> To: ohp@pyrenet.fr
> Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] 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.
>
>

-- 
Olivier PRENANT                    Tel: +33-5-61-50-97-00 (Work)
15, Chemin des Monges                +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                       +33-6-07-63-80-64 (GSM)
FRANCE                          Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)


pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: FW: PGBuildfarm member snake Branch HEAD Status changed from OK to ContribCheck failure
Next
From: "Kevin Grittner"
Date:
Subject: Re: Backslashes in string literals