Postgres Pro
Downloads
Home   >   mailing lists

Re: Inheritance in PostgreSQL - Mailing list pgsql-general

From David G. Johnston
Subject Re: Inheritance in PostgreSQL
Date
Msg-id CAKFQuwbGx3caZx4YqsWttEPR6pj-oUS5Nu0tny4GHkYS7XKGYQ@mail.gmail.com
Whole thread Raw
In response to Inheritance in PostgreSQL  (Luis Bruno <l.brunofidelis@gmail.com>)
Responses RE: Inheritance in PostgreSQL  (Jeff Laing <Jeff.Laing@synchronoss.com>)
List pgsql-general
Tree view
On Tue, Oct 17, 2023 at 2:49 PM Luis Bruno <l.brunofidelis@gmail.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.

pgsql-general by date:

Previous
From: Luis Bruno
Date:
Subject: Inheritance in PostgreSQL
Next
From: Ron
Date:
Subject: Re: Inheritance in PostgreSQL