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

inherited tables failure

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: inherited tables failure
Date: 2001-08-16 17:06:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Laszlo Csite (ozy(at)tiszanet(dot)hu) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
inherited tables failure

Long Description
We have two tables inherited one from the other one. If you try to insert from the parent into the child by an "INSERT INTO" statement then the record is inserted into the child but into the parent too! Therefore in the parent duplicated rows appear. 

The other bug is if you delete a row from the parent then it erases from the child too. see the illustration below.

Sample Code

create table try (col1 int4);
create table try1 () inherits (try);  
insert into try (col1) values (15); 
select * from try1;   --> you get 0 row
select * from try;   --->you get 1 row
insert into try1 select * from try;  --> the answer is 1 row is inserted into try1

select * from try1;   --> you get 1 row
select * from try;   --->you get 2 row !!!!!!!!!!! <-That's wrong

delete from try;   
select * from try1;   --> you get 0 row !!!!!!!!!!! <-That's wrong
select * from try;   --->you get 0 row 

No file was uploaded with this report


pgsql-bugs by date

Next:From: Stephan SzaboDate: 2001-08-16 19:17:43
Subject: Re: inherited tables failure
Previous:From: Truong, LongDate: 2001-08-16 12:05:26
Subject: openVMS

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