------- Original Message -------
On Wednesday, May 11th, 2022 at 02:50, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>
> 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
Thank you. I'll be sure to read that.
Simon.