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

Re: inherited tables failure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ozy(at)tiszanet(dot)hu, pgsql-bugs(at)postgresql(dot)org
Subject: Re: inherited tables failure
Date: 2001-08-16 19:58:08
Message-ID: 16148.997991888@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)org writes:
> 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.

This is not a bug; it's the way things are supposed to work in 7.1.
"*" is now the default behavior.  Use ONLY if you want to restrict
scans or updates to the parent table.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Mark StosbergDate: 2001-08-16 22:12:16
Subject: Re: Using nulls with earthdistance operator crashes backend (patch)
Previous:From: Stephan SzaboDate: 2001-08-16 19:17:43
Subject: Re: inherited tables failure

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