Re: inheritence behavior question .... - Mailing list pgsql-general

From
Subject Re: inheritence behavior question ....
Date
Msg-id 01c001c1d3e5$2cf6d530$6501a8c0@calvin
Whole thread Raw
In response to inheritence behavior question ....  (<tsmets@brutele.be>)
Responses Re: inheritence behavior question ....
List pgsql-general
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






pgsql-general by date:

Previous
From: Heiko Klein
Date:
Subject: Re: ODBC problem
Next
From: Oliver Elphick
Date:
Subject: Re: inheritence behavior question ....