Re: Using "object orientated" tables? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Using "object orientated" tables?
Date
Msg-id 39422.1652233803@sss.pgh.pa.us
Whole thread Raw
In response to Using "object orientated" tables?  (Simon Connah <simon.n.connah@protonmail.com>)
Responses Re: Using "object orientated" tables?
List pgsql-novice
Simon Connah <simon.n.connah@protonmail.com> writes:
> I was wondering what the community thought of using table inheritance in PostgreSQL? Is it considered bad practice
thesedays? 

Mmm ... not if the various caveats[1] don't bother you.  The biggest
stumbling block for most people, I think, is that you can't have
foreign keys that reference the whole inheritance hierarchy.

            regards, tom lane

[1] https://www.postgresql.org/docs/current/ddl-inherit.html#DDL-INHERIT-CAVEATS



pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Using "object orientated" tables?
Next
From: Simon Connah
Date:
Subject: Re: Using "object orientated" tables?