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@cornelia-boenigk.de>
To: "pgsql-general" <pgsql-general@postgresql.org>; <tsmets@brutele.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