| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2000-05-24 14:34:01 | Re: Re: [HACKERS] Postgresql OO Patch |
| Previous Message | Bruce Momjian | 2000-05-24 14:20:19 | Re: setproctitle() |