Re: Inheritance in PostgreSQL

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Luis Bruno <l(dot)brunofidelis(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Inheritance in PostgreSQL
Date: 2023-10-17 21:56:08
Message-ID: CAKFQuwbGx3caZx4YqsWttEPR6pj-oUS5Nu0tny4GHkYS7XKGYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Oct 17, 2023 at 2:49 PM Luis Bruno <l(dot)brunofidelis(at)gmail(dot)com> wrote:

> I'm particularly interested in the advantages of the inheritance concept
> in PostgreSQL
>

There really are none nowadays and the entire feature should be avoided,
IMO. No one else has tried to implement it in their engines for good
reasons. Stick with relational models in a relational database.

Also of note:
https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_varchar.28n.29_by_default

I'm tempted to add "Don't use inheritance" to that page...but fortunately
it doesn't come up that often.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-10-17 22:16:43 Re: Inheritance in PostgreSQL
Previous Message Luis Bruno 2023-10-17 21:42:57 Inheritance in PostgreSQL