Re: Bug #719: Restoring inherited data destroys parent table data.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rolsthoorn(at)irdetoaccess(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #719: Restoring inherited data destroys parent table data.
Date: 2002-07-25 15:11:09
Message-ID: 18546.1027609869@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> Restoring inherited data destroys parent table data.

No it doesn't. You appear to be expecting the pre-7.1 behavior of
SELECT on a parent table. Recent versions default to doing the
equivalent of "SELECT FROM parent*".

See the SQL_INHERITANCE configuration parameter if you prefer the
old way.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2002-07-26 02:06:09 Bug #720: Unable to make postgreSql 7.2.1 on Slackware 7.1 Linux 2.2.16
Previous Message pgsql-bugs 2002-07-25 10:15:26 Bug #719: Restoring inherited data destroys parent table data.