Skip site navigation (1) Skip section navigation (2)

Re: inheritence behavior question ....

From: <tsmets(at)brutele(dot)be>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: inheritence behavior question ....
Date: 2002-03-25 10:09:30
Message-ID: 01c001c1d3e5$2cf6d530$6501a8c0@calvin (view raw or flat)
Thread:
Lists: 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(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






In response to

Responses

pgsql-general by date

Next:From: Oliver ElphickDate: 2002-03-25 11:01:35
Subject: Re: inheritence behavior question ....
Previous:From: Heiko KleinDate: 2002-03-25 09:47:42
Subject: Re: ODBC problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group