News for hackers. Stuff that matters.
Re:New Features Coming in PostgreSQL 10 by iEchoic on Saturday April 08, 2017 @03:03PM (#14068413)
I'm so excited for table partitioning. I use table inheritance in several places in my current project, but have felt the pain of foreign key constraints not applying to inherited children. Reading about table partitioning, I'm realizing that this is a much better fit for my use case.

Postgres continues to amaze me with the speed at which they introduce the right features into such a heavily-used and production-critical product. Thanks Postgres team!

Re:New Features Coming in PostgreSQL 10 by amitlan on Saturday April 08, 2017 @03:06PM (#14068435)
Unfortunately, foreign keys won't be supported right away.

Read about the new feature and its limitations here: https://www.postgresql.org/docs/devel/static/ddl-partitionin...

Re:New Features Coming in PostgreSQL 10 by iEchoic on Saturday April 08, 2017 @03:28PM (#14068553)
Thanks, I hadn't read this. That's too bad, hopefully we'll see that in the future (if it's technically possible at all?). That'd be a huge feature for me.