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