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

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 (view raw or flat)
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

pgsql-bugs by date

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

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