From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Connah <simon.n.connah@protonmail.com>
cc: pgsql-novice@lists.postgresql.org
Subject: Re: Using "object orientated" tables?
In-reply-to: 
 <FD4Iyd89i-sbetQTcbUPO1SqWrYMGhzyso4ltpYmvWiI5LtHUxnPZNCyoJOhMOr3aQqvSKR9pISe55L3HStXrim-Q2wuufRQFkjGtAjIyS8=@protonmail.com>
References: 
 <FD4Iyd89i-sbetQTcbUPO1SqWrYMGhzyso4ltpYmvWiI5LtHUxnPZNCyoJOhMOr3aQqvSKR9pISe55L3HStXrim-Q2wuufRQFkjGtAjIyS8=@protonmail.com>
Comments: In-reply-to Simon Connah <simon.n.connah@protonmail.com>
	message dated "Wed, 11 May 2022 01:33:20 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <39421.1652233803.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 10 May 2022 21:50:03 -0400
Message-ID: <39422.1652233803@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/39422.1652233803%40sss.pgh.pa.us>
Precedence: bulk

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 these days?

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-C=
AVEATS