Re: inheritence behavior question ....

Nope what really bothers me is that I see the son's values while querying
the father !
That w/o specifying the father*
<snip>
test=> select * from father;
col1
------
1
2
3
1
(4 rows)
</snip>

I have absolutely no problem with the inserts in the son !
Dropping the constraints at Son's level sound weird to me but I can agree
with that w/o toomuch problem !

It's the query result that bothers me !

thomas,

--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id : smetsthomas
----- Original Message -----
From: "Cornelia Boenigk" <poppcorn(at)cornelia-boenigk(dot)de>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>; <tsmets(at)brutele(dot)be>
Sent: 25 March, 2002 4:12 AM
Subject: Re: [GENERAL] inheritence behavior question ....

Hi Thomas

> Could some one explain why the last insert did not fail ?

Because you inserted into the table son;-)
So why should it fail?

Greetings
Conni