AW: Postgresql OO Patch

Zeugswetter Andreas SB <zeugswettera@wien.spardat.at>

From: Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
To: "'Postgres Hackers List'" <hackers@postgresql.org>
Date: 2000-05-24T14:21:00Z
Lists: pgsql-hackers
> One more time for the <general> mailing list...
> 
> Hands up if you have objections to the patch I recently submitted for
> postgresql. It fixes the long standing bit-rot / bug  that DELETE and
> UPDATE don't work on inheritance hierarchies, and it adds the ONLY
> syntax as mentioned in SQL3 and as implemented by Informix. 
> The downside
> is it breaks compatibility with the old inheritance syntax. 
> But there is
> a backward compatibility mode. I.e. "SELECT * FROM foobar*" becomes
> "SELECT * FROM foobar", and "SELECT * from foobar" becomes "SELECT *
> FROM ONLY foobar".
> 
> Benefits:
> *) SQL3 says it.

Imho this alone more than justifies the patch.
We should also change our keyword "inherits" to "under".

Andreas