Hacker News Reader

Table inheritance has some serious limitations regarding foreign keys and some other aspects. The following warning is in the official documentation in that chapter:

> These deficiencies will probably be fixed in some future release, but in the meantime considerable care is needed in deciding whether inheritance is useful for your application.

View on HN

Here is the section on the limitations. Having tried this out myself, please be aware that this is not really 'inheritance'. I had to ditch it completely from my design:

https://www.postgresql.org/docs/current/static/ddl-inherit.h...

For what I'm doing I got away with having insert/delete triggers on child tables that mirror their identity/type to a 'types' table. Also enforced through check constraints and FKs

I think this is being addressed now: https://blog.2ndquadrant.com/enhancements-to-partitioning-an...

Partitioned tables and child tables are different things; I'd be surprised if 2nd Q is actually is working on support for child tables. (Child tables I believe were historically used to implement partitioning, but Postgres now has native partitioning support.) There's no mention of FK support on child tables in the v11 release notes that I can find: https://www.postgresql.org/docs/11/static/release-11.html

Thanks. My bad.

Reply on news.ycombinator.com