From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This |
Date: | 2023-10-23 17:00:31 |
Message-ID: | 2f586e74-3657-4ef1-ad05-8992a55b4fdd@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/23/23 09:51, Achilleas Mantzios wrote:
> Στις 23/10/23 17:01, ο/η Alvaro Herrera έγραψε:
>> On 2023-Oct-23, Achilleas Mantzios - cloud wrote:
>>
>>> I believe this text is false on too many accounts. So, what's the
>>> consensus
>>> about Inheritance in PostgreSQL, I am going to give a talk on it in
>>> November
>>> and I wouldn't like to advertise/promote/teach something that the
>>> community
>>> has decided to abandon or drop. Actually I proposed several topics
>>> and they
>>> chose this one (Inheritance).
>> There are several things wrong with table inheritance; see [1] in our
>> docs, in addition to the things that the wiki page notes. I think it's
>> good advice to stay clear of it, and if you're giving a talk, do not
>> talk about inheritance except to mention its drawbacks. Regarding your
>> talk, I would strongly suggest to ask them to choose another topic from
>> your list.
>
> Yes, those limitations are known, and must be dealt. The wiki IMHO is
> aggressive and insulting plus the advice to use FK instead of
> inheritance is at least laughable. I don't think there should be such an
> official text on the official PostgreSQL site.
I don't know enough to say either way. What I do know is that this is
the Wiki and you can sign up to edit it.
>
> Thanks!
>
>> [1]
>> https://www.postgresql.org/docs/16/ddl-inherit.html#DDL-INHERIT-CAVEATS
>>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2023-10-23 17:06:23 | Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This |
Previous Message | Achilleas Mantzios | 2023-10-23 16:58:17 | Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This |