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

AW: Postgresql OO Patch

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Postgres Hackers List'" <hackers(at)postgresql(dot)org>
Subject: AW: Postgresql OO Patch
Date: 2000-05-24 14:21:00
Message-ID: 219F68D65015D011A8E000006F8590C604AF7D97@sdexcsrv1.f000.d0188.sd.spardat.at (view raw or flat)
Thread:
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

Responses

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2000-05-24 14:34:01
Subject: Re: Re: [HACKERS] Postgresql OO Patch
Previous:From: Bruce MomjianDate: 2000-05-24 14:20:19
Subject: Re: setproctitle()

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