Horton
Menu

Re: Inheritance in PostgreSQL

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Luis Bruno <l.brunofidelis@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Date: 2023-10-17T21:56:08Z
Lists: pgsql-general 
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.