Re: Bug #719: Restoring inherited data destroys parent table data. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #719: Restoring inherited data destroys parent table data.
Date
Msg-id 18546.1027609869@sss.pgh.pa.us
Whole thread Raw
In response to Bug #719: Restoring inherited data destroys parent table data.  (pgsql-bugs@postgresql.org)
List pgsql-bugs
pgsql-bugs@postgresql.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

pgsql-bugs by date:

Previous
From: "Ivan Dolinin"
Date:
Subject: Can't solve this problem
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #720: Unable to make postgreSql 7.2.1 on Slackware 7.1 Linux 2.2.16